...............
sname varchar2(20) default 'zhouyong';
.............
select id from person where name=sname;
.................
结果:
ORA-00904: "ZHOUYONG": invalid identifier
请教该怎样写才会拼成诸如
selectid from person where name=’zhouyong‘;
部分实现:
TYPE refcursorIS REF CURSOR;
c1 refcursor;
..........
str := 'select id from person where name ='''||sname||'''';
open c1 for str;
fetch c1 into var_id;
.......................................
上帝这点问题居然花费了我两天时间,哦,笨小孩!