sequence number [message #80280] |
Tue, 03 September 2002 04:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
bezgouri
Messages: 3 Registered: September 2002
|
Junior Member |
|
|
hi all,
i have a master detail bloc.
the detail block B contains 10 lines
and the table B contains a field line_id
i want to insert the line_id(it's generated from 1 to 10) in the table B
now in order to insert i just do ommit but how can i insert the line_id
thanks in advance
|
|
|
Re: sequence number [message #80288 is a reply to message #80280] |
Tue, 03 September 2002 17:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Tejpal Saraswat
Messages: 22 Registered: August 2002
|
Junior Member |
|
|
Hi bezgouri
Just write in the Pre-Insert trigger
:block_name.Line_ID := sequence_no
automatically ur sequence will get inserted in to Table.
try it.
best Regds
Tej
|
|
|