Help ! Storing value in temp variable in sqlplus
From: Patrick McCarthy <pmccarth_at_rpc.unb.ca>
Date: 1995/07/05
Message-ID: <3te724$ih3_at_sol.sun.csd.unb.ca>#1/1
Date: 1995/07/05
Message-ID: <3te724$ih3_at_sol.sun.csd.unb.ca>#1/1
Qualifier :> I am a novice user.
I need to create a sql script file which will pull the max(value) of a field and store it into a temporary variable (temp_var). I then must add 1 to the temp value (temp_var + 1) and then insert the value into a table (insert into table values (temp_var, null, null.......)
I am just not sure how to create this temp variable, give it a value and then reference the variable in a later insertion function call.
Any help would be greatly appreciated.
Thanks in advance.
Patrick McCarthy
Systems Developer
RPC
email -> pmccarth_at_rpc.unb.ca
Received on Wed Jul 05 1995 - 00:00:00 CEST