Question: why select is dml statement?
Answer: The SELECT ... INTO form is considered to be DML because it manipulates (i.e. modifies) data. In common practice though, this distinction is not made and SELECT is widely considered to be part of DML. ... Data manipulation language (DML) statements query or manipulate data in existing schema objects.