Home » SQL & PL/SQL » SQL & PL/SQL » Retrive the sequence after an INSERT
Retrive the sequence after an INSERT [message #30924] Mon, 31 May 2004 00:34 Go to next message
Milly
Messages: 72
Registered: March 2004
Member
Hi ALL!

I have to retrieve the value of the sequence associated to a table, after the insert, in a transaction, in an unique statement...

All this I have to do in a ado command launched in a vb6 application....

 

thanks!!

 

Report message to a moderator

Re: Retrive the sequence after an INSERT [message #30935 is a reply to message #30924] Mon, 31 May 2004 05:15 Go to previous message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
You can use the RETURNING clause of the INSERT statement to retrieve the sequence number :-

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_913a.htm#2064186

Specify a BIND VARIABLE in the INTO portion.

Takmeister

Report message to a moderator

Previous Topic: LONG datatype conversion
Next Topic: One parameter for multible select-statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 18:45:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.