Re: Require Solution for this SQL problem

On Sat, 15 Sep 2007 03:47:34 -0700, Nick <nachiket.shirwalkar_at_gmail.com> wrote:

>Hi,
>
>I have two tables TableA and TableB. I have a stored procedure which
>runs every morning and based on some logic dumps rows from TableA to
>TableB. In Table B there are two additional colums ID and RunID. ID is
>a normal sequence applied for all rows. But the RunId should be
>constant for a run of stored proc.

very simple: set up a sequence. Increment it only once in your procedure.
Problem solved.

-- 
Sybrand Bakker
Senior Oracle DBA