Oracle dynamic SQL, oraclesql

Oracle dynamic SQL, oraclesql

The syntax for executing dynamic SQL statements is:

Excute immediate dynamic SQL statement using binding parameter list returning into output parameter list

 

Test Table: student (id, name, age );

Example: Storage

Create or replace procedure p_stu_info (s_id number) is v_name varchar2 (10); v_age number; begin execute immediate 'select name, age from studentwhere id =: 1 'using s_id returning into v_name, v_age; dbms_output.put_line (v_name | 'age:' | to_char (v_age); exception when others then dbms_output.put_line ('student not found '); end p_stu_info;