Question

Define procedurr and nonprocedure dml in oracle

Answer 1

Embedded SQL statements incorporate DDL, DML, and transaction control statements within a procedural language program. They are used with the Oracle Precompilers. Embedded SQL statements allow you to do the following: Define, allocate, and release cursors (DECLARE CURSOR, OPEN, CLOSE)