20.1.1 Use the EXECUTE IMMEDIATE StatementCreate 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:
|