Thread: Is Select DML?

Hi all,

I have one basic question... My friend was saying SELECT as DML... I told him SELECT won't come under DML.... since it is only retreiving data......

who is correct?

Lookin for replies....

Select is a dml statement.

Here is the list of dml statements
select
delete
update
insert
lock table
explain plan
call

Krishna,

Please chk the link.... SQL - Wikipedia, the free encyclopedia

Regards,
Karthi

It is given that the standard SELECT query is considered separate from SQL DML, as it has no persistent effects on the data stored in a database........

Your doubt is you are not manipulating database objects using select statement. Just you are selecting or query data from database. So it is not DML statement.

DML statements do not commit data automatically.
DDL statements auto commit data.

Select is not DML .
It is Data Retrival Language(DRL) since it involvs no data manipulation.

I have given reply based on oracle documentation.

Here is the link