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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!