????8??????SELECT ??????????RETURNING INTO????

?????????????У?????????????SELECT??????????????RETURNING??????????????????RETURNING coloumn_name INTO ??????????DML????????????????????????????

DECLARE
         sql_stat VARCHAR2(200);
         v_empno  tb2.empno%TYPE := &eno;
         v_ename  tb2.ename%TYPE;
    
       BEGIN
         sql_stat := 'SELECT ename FROM tb2 WHERE empno =:eno
                      RETURNING ename INTO :v_ename ';
         EXECUTE IMMEDIATE sql_stat
           USING v_empno
           RETURNING INTO v_ename;
         DBMS_OUTPUT.PUT_LINE('The employee name is ' || v_ename);
       END;

?????????

?????????SQL????е?RETURNING coloumn_name INTO????????EXECUTE IMMEDIATE?????????INTO????????????

DECLARE
         sql_stat VARCHAR2(200);
         v_empno  tb2.empno%TYPE := &eno;
         v_ename  tb2.ename%TYPE;
    
       BEGIN
         sql_stat := 'SELECT ename FROM tb2 WHERE empno =:eno';
                --       RETURNING ename INTO :v_ename ';     --???RETURNING???
         EXECUTE IMMEDIATE sql_stat
           INTO v_ename                                        --????INTO?????????????
           USING v_empno;
           --RETURNING INTO v_ename;                           --???RETURNING???
         DBMS_OUTPUT.PUT_LINE('The employee name is ' || v_ename);
       END;

???????????

????1???????DDL?????????e?????????y?????????????SQL?????????????????

????2?????????schema?????????????????schema??????????SQL?????????????????

????3?????SQL?鯔????÷?????(;)??

????4?????PL/SQL?鯔???????б?????????飬??????β?????????÷??(;)??

????5???????????????????????USING NULL?????????????????????????????δ????????????????????

????6?????????????????????????????????????????????

????7??????????????????SQL?д????????????????????????????????????????chr(39)???????????á?

????8?????SQL??RETURNING INTO????DML??????????????SELECT?????????????????EXECUTE IMMEDIATE?????????INTO??????????