Home -> Usenet -> comp.databases.oracle -> Re: Help ! Storing value in temp variable in sqlplus

Re: Help ! Storing value in temp variable in sqlplus

From: Stefan Scheck <scheck_at_ask.uni-karlsruhe.de>
Date: 1995/07/06
Message-ID: <3th1vi$j0a_at_nz12.rz.uni-karlsruhe.de>#1/1 







Hi,



if you want to use a temp-variable, you have to use PL/SQL.



Easier:



INSERT INTO MY_TABLE (MY_COLUMN)



SELECT MAX(MY_COLUMN)+1 FROM MY_TABLE;


Hope it helps.



Greetings,


Stefan Scheck.
Received on Thu Jul 06 1995 - 00:00:00 CEST












Original text of this message