Wednesday, June 24, 2020

Create a basic PL/SQL block

Solution:
======
write the keyword BEGIN and END.Place your code between BEGIN and END.Example is below
======================================================================
BEGIN
here write your executable code;
END;
===========
If you want to introduce variables for your PL/SQL block, you must precede your block with a
DECLARE section. Here’s an example:

DECLARE
One or more variable declarations
BEGIN
One or more PL/SQL statements
END;

No comments:

Post a Comment