Multiple choice technology databases

Which of the following is NOT VALID in PL/SQL ?

  1. Select … into

  2. Update

  3. Create

  4. Delete

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In PL/SQL, Data Manipulation Language (DML) statements like SELECT...INTO, UPDATE, and DELETE are natively supported. However, Data Definition Language (DDL) statements like CREATE cannot be executed directly and must be run using dynamic SQL (EXECUTE IMMEDIATE).