database - oracle中如何使用通配符？

Question

SELECT * from TB_PETS where PET_NAME like '_[ali]%';

为什么这段代码不起作用？我试图列出所有具有第二个字符的记录是 a, l, i 但它不起作用。

标签： databaseoracle-sqldeveloperoracle-apex

Answer 1

只需使用

SELECT * from TB_PETS where PET_NAME like '_ali%';

它应该给你你想要的

with TB_PETS as (
select 'Kalito' as PET_NAME from dual union all
select 'Maline' from dual union all
select 'Kumpara' from dual
)
SELECT * from TB_PETS where PET_NAME like '_ali%';

PET_NAME
Kalito
Maline