If i want to insert all records from another table I can use the following
INSERT INTO <table_name> <SELECT Statement>;
I would like to know how oracle handles this in the backend. What is the difference between running the above statement and running individual insert statements assuming that there are 100000 records.
By using a single statement does oracle parse the statement only once instead of parsing it 100000 times?
In 10g does oracle automatically do bulk insert by doing INSERT INTO <table_name> <SELECT Statement>
Any inputs are appreciated.