Question: why select is dml in oracle?
Answer: The SELECT ... INTO form is considered to be DML because it manipulates (i.e. modifies) data. ... As an example of the lack of distinction, the Oracle 11.2 Concepts Guide includes SELECTS as DML as follows: Data manipulation language (DML) statements query or manipulate data in existing schema objects.