Question

ORACLE 存储过程语句怎么用参数？

我的参数是enddate

在存储过程中

select "tdate" into enddate from TABLEA where "tdate" like 'enddate%' order by "tdate" desc;
会出错
在SQL中
select "tdate" into enddate from TABLEA where "tdate" like '2008010%' order by "tdate" desc;
就可以，但是存储中不知道怎么表达。
能指点下吗

Answer 1

select "tdate" into enddate from TABLEA where "tdate" like enddate||'%' order by "tdate" desc;