Question

pl/sql like 子句怎么使用变量

declare
ss varchar2(20);
begin
ss:='tom';

select * from student where name like '%ss%';
end;

在like子句模糊匹配的内容中可以用变量ss吗？如果能用怎么用？

Answer 1

如ss是varchar类型的话
sql Server:
like '%'+@ss+'%' (SQL Server中所有用户定义的变量都以“@”开头)
oracle:
like '%'||ss||'%'

Answer 2

declare
@ss varchar(20);
begin
set @ss='tom';

select * from student where name like '%'+@ss'%';
end;

Answer 3

select * from student where name like '%'||ss||'%';