Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

Delete Value from LOV after selecting it

This example illustrate how to remove a value from LOV after selecting it ( removing from the LOV not from the Database ) the point here is making restriction on values duplication in case we select the value again from the LOV that post his values on unique filed.





download the fmb file from this link :-



-------------------------
For more details , have a look for the codes :-

you must first to create this table on your Database:

CREATE GLOBAL TEMPORARY TABLE reg (
region_id NUMBER , region_name VARCHAR2(25)
) ON COMMIT DELETE ROWS;


and then do this in your Oracle Forms :






That's ALL , have a nice day.


Share/Save/Bookmark

1 comments:

  1. Unknown said...
     

    شكرا على الفرم الجميلة اول مرة أشوف حد بيحب يخدم كده

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-