结构化查询语言SQL Within PL _ SQL.pptVIP

SQL Within PL / SQL Chapter 4 SQL Within PL / SQL SQL Statements DML in PL / SQL Pseudocolums Transaction Control SQL StatementsUsing SQL in PL / SQL The only SQL statements allowed in PL/SQL are: DML (data manipulation language) transaction control DDL (data definition language) statements are not permitted SQL StatementsDML in PL / SQL The DML statements permitted are: Select Insert Update Delete DML in PL / SQLSelect SELECT statement in PL/SQL retrieves data from a database table into: PL/SQL record set of PL/SQL variables Using SELECT in PL/SQL should only return one row When you need