Write the syntax used to load a procedure???

1.	Write the syntax used to load a procedure???
Answer» The SYNTAX to create a procedure in Oracle is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (PARAMETER [,parameter]) ] IS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [procedure_name]; When you create a procedure or FUNCTION, you may define parameters.

Discussion