PL/SQL (MOSC)

MOSC Banner

one table is input into another

edited Dec 23, 2009 6:31PM in PL/SQL (MOSC) 9 commentsAnswered
I have 2 tables .. one will act as the input for another ...

I have a routine that produces table1 records.  These are records I want to status.

Table 2 is the status for the records.   What I want to do is take the records that are

in Table 1 and add them to Table 2.  The ids, serial are the keys.  What is in table 1 isn't

in table 2.   so I want to add the id, serial from table 1 to table 2 and hard code the status field and key_ed columns. 



Table 1     id,  serial
Table 2     id, serial, status, key_ed

I've been trying things like

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center