Latest Answer : A sequence generates a list of unique numbers that identifiy the rows and columns of a table. ...
I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change?
Latest Answer : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ...
Latest Answer : Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle') ...
Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Applications)Module HRMSeg - 000001,000002.Pls update on thisRegardsVenu
Dear 1 simple qustion is how i can get out put likescott's sal is 2000becoz ' is special char i can not pipe it with enameasename||'scan we use escape sequence but i know that escape seq is only 4 % and _ plz tell me anybody
Is there any limit on like this number of parameters should be passed into a function? Or can we pass any number of arguments into a function?
What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?
Latest Answer : SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP'; ...
How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write?
