Multiple choice technology databases

Which of the following syntax is correct for creating a proc

  1. CREATE OR REPLACE PROCEDURE <<Procedure name>> as

  2. CREATE OR REPLACE PROCEDURE <<Procedure name>>(Parameter list) as

  3. CREATE OR REPLACE PROCEDURE <<Procedure name>> is

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle PL/SQL procedure creation requires either AS or IS keyword after the procedure name. Parameter lists are optional. Both CREATE OR REPLACE PROCEDURE name AS and CREATE OR REPLACE PROCEDURE name IS are valid syntax. Adding a parameter list before AS/IS is also valid when parameters are needed.

Keep practicing — related questions