View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 08:48 AM
monesseldeur
 
Posts: n/a
Default store result of query in variable

Hi all,

I'm trying to write a script in which I need the result of a query to
perform an insert in a table.

Something like this:

var = select max(Xid) from tbl_X;
var = var + 1;
insert into tbl_X (Xid) values (var);

Is this possible without uising Pl/SQL?
Reply With Quote