Oracle Dynamic SQL

The syntax for executing dynamic SQL is:

Excute immediate Dynamic SQL statement using-bound parameter list returning into output parameter list

Test table: Table: Student (id,name,age);

Example: Storage

Create or Replace procedure P_stu_info (s_id number) is  v_name varchar2 (n);  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 | | ' The Age of: ' | | To_char (V_age)); exception when  others then    dbms_output.put_line (' cannot find the corresponding student '); end P_stu_info;

Oracle Dynamic SQL