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.