Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert new records using sequences

Status
Not open for further replies.
TimPro

TimPro

Programmer
Feb 26, 2002
8
IE
Sorr for such a trivial problem, but could someone please tell me the syntax for inserting new rows in a db using sequences for a primary key.
thanks
 
Sort by date Sort by votes
In Forms you can use:

SELECT ZAKAZNIK_SEQ.NEXTVAL INTO :block1.ID FROM DUAL;

where :block1.ID is primary key.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kss444
  • Locked
  • Question
Insert Decode help
Replies
9
Views
132
kss444
kss444
taqmeena
  • Locked
  • Question
Using Crystal Reports with Form 6i
Replies
0
Views
105
taqmeena
taqmeena
haste
  • Locked
  • Question
ora-000936 on insert from sql expression
Replies
2
Views
78
haste
haste
bgmit
  • Locked
  • Question
oracle 10g connection using vb.net(2005)
Replies
1
Views
101
bgmit
bgmit
bookouri
  • Locked
  • Question
anybody using secure web.show_document
Replies
0
Views
68
bookouri
bookouri

Part and Inventory Search

Sponsor

Back
Top