Why SQLECT statement is called as a DML
589704Aug 18 2007 — edited Aug 20 2007Dear Friends,
I have read in many Oracle Documents that SELECT statement belongs to DML But I strongly believe that SELECT is a Data Retrieval Language (DRL).
We can have a DRL in a DML like INSERT INTO table1 as SELECT * FROM table2.
Is this the only reason why we call a SELECT statement as DML??? If yes then what abt this: CREATE TABLE table1 as SELECT * FROM table2.
I am confused. Why the SELECT statement is a DML.
In my view DML means the language which manipulates the data (Records of one or more tables) in the database. But SELECT statement does not manipulate the data in the database. So why is it being called as DML.
Any authentic reason would be appreciated.
Have a Nice Day.
Thanks & Regards,
Ahmed.