Oracle Forms | How to Create Auto Primary key By PRE-INSERT -36
Oracle Forms | How to Create Auto Primary key By PRE-INSERT -36
To See More Forms Tutorial Click here • Oracle Forms: How to Install Oracle D...
To See More Reports Tutorial Click here • Introduction To Database & Out Line T...
Dear viewer, In this tutorial you will learn How to Create Auto Primary key by PRE-INSERT.
You also learn How to Create Auto Primary key by sequence.
Code:
SELECT NVL(MAX(USERID),100)+1
INTO :USERID
FROM USERINFO;
Or,
-Create Sequence
Code:
Select sequence_name.nextval into :USERID from sys.dual;
To Get more Tutorial Subscribe The Channel
click here / @oracledbsolutions2678
To Get All Post Like The Facebook Page
Click here / oracledbsolutions
Follow us:
Facebook: / oracledbsolutions
Youtube link: / @oracledbsolutions2678
Facebook Group: / 465557066961548
Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780