Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources] نسخه متنی

Lab 20.1 Exercises

20.1.1 Use the EXECUTE IMMEDIATE Statement

Create the following PL/SQL script:

-- ch20_1a.sql, version 1.0
SET SERVEROUTPUT ON
DECLARE
sql_stmt VARCHAR2(200);
v_student_id NUMBER := &sv_student_id;
v_first_name VARCHAR2(25);
v_last_name VARCHAR2(25);
BEGIN
sql_stmt := 'SELECT first_name, last_name'||
' FROM student' ||
' WHERE student_id = :1';
EXECUTE IMMEDIATE sql_stmt
INTO v_first_name, v_last_name
USING v_student_id;
DBMS_OUTPUT.PUT_LINE ('First Name: '||v_first_name);
DBMS_OUTPUT.PUT_LINE ('Last Name: '||v_last_name);
END;

Execute the script, then complete the following exercises: