PL/SQL 中,如何把2个字符串直接起来?
如;
p1_sql='select * FROM DUAL1 ';
P2_SQL='WHERE ASSET_ROW_ID=''AFDSAF-FDSA'' AND DATE=TRUNC(SYSDATE)';
现定义一个P3_sql变量,使之为p1_sql 和p2_sql的连接.
使p3_sql='select * FROM DUAL1 where ASSET_ROW_ID=''AFDSAF-FDSA'' AND DATE=TRUNC(SYSDATE)';
如何写?