Oracle Dynamic Query Execute IMMEDIATE SELECT INTO Use method

Create or replace procedure test_table is

L_table_name VARCHAR2 (50);

Query_stat varchar2 (100);

L_zyq T_djjcxx.zyq%type;

L_jh varchar2 (20);

L_djjcxx T_djjcxx%rowtype;

Begin

L_JH: = ' 7874 ';

Select name into L_table_name from Testa;

Dbms_output.put_line (L_table_name);

Query_stat: = ' select * from ' | | l_table_name| | ' where JH=:L_JH ';

EXECUTE IMMEDIATE query_stat into l_djjcxx using L_jh;

Dbms_output.put_line (L_DJJCXX.ZYQ);

End test_table;

Query_stat inside if write select Zyq into L_zyq from ' | | l_table_name| | ' Where Jh=:l_jh ' will complain. The red is the place to pay attention to