Executing PL/SQL Blocks and Functions - Exercise

Contact Us or call 1-877-932-8228
Executing PL/SQL Blocks and Functions - Exercise

Executing PL/SQL Blocks and Functions

Duration: 10 to 15 minutes.
  1. Using a SQL*Plus/SQL Developer command, call a procedure in an Oracle supplied package to print out "Hello Universe!".
  2. Create and execute a call to the same procedure that will print out "Hello Universe!" using an anonymous block.
  3. Execute a function call to print out the structure of the JOBS table using a function from an Oracle supplied package.

Solution:

Language-Features/Solutions/development_cycle_solution.sql
exec dbms_output.put_line('Hello Universe!');

begin
   dbms_output.put_line('Hello Universe!');
end;
/

select dbms_metadata.get_ddl('TABLE','JOBS')
from dual;

Code Explanation

Next