| muzu |
Posted: Aug 21, 2007 10:00:51 AM |
Total Post: 37
Joined: Aug, 2007
|
| How sequence_name.nextval can be used in the query of type "Select list of subquery in an insert statement." where the sequence is generated in the select list of subquery in an insert statement. Can any one show this type with an example ? |
|
|
 charan |
| Posted: Aug 21, 2007 06:21:12 PM |  |
|
Total Post: 1
Joined: Aug, 2007
|
In Insert statement, seq.nextval will not work . it can be executed with dual like below.
select Gledi_invoice.nextval from dual;
if you want to insert sequence of numbber try with max(number) + 1 in subquery.
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 22, 2007 12:24:41 AM | |
|
Total Post: 246
Joined: Aug, 2007
|
First select the sequence number to a variable using dual table and then use in insert statement
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
