Can someone please explain the INSERT syntax that is in the Oracle Database 10g SQL class. I can't seem to find anyone who knows.
An example of the statement that I don't understand is:
(SELECT last_name, salary
WHERE department_id = 50)
What is the SELECT statement in the INSERT clause of the INSERT statement doing? Thanks for any help anyone can give me.
June 19, 2006 1:18 PM
June 20, 2006 10:27 AM