Why can't such a script be executed in Oracle?

szj0571

SELECT * FROM TableName
where '10, 11, 13, 12, 40, 47, 48, 49, 90, 92, 91, 94, 95, 96, 30, 31, 33, 34, 35, 24, 20, 21' like '%' + menuid + ',%' order by menuid
The above paragraph I can execute normally in MS SQL, but I put an invalid number error in oracle. How should the above sentence be written in Oracle? menuid is a column in the table TableName, the record content in it may be 10 or 11 ....

whbilly

In oracle:

SELECT * FROM TableName
where munuid in (10,11,13,12,40,47,48,49,90,92,91,94,95,96,30,31,33,34,35,24,20,21 ') order by menuid;

idpublic

SELECT * FROM TableName
where menuid like '%' || variable || ',%' order by menuid

idpublic

sql server

drop table #a
create table #a (menuid varchar (20), aaa varchar (20))

insert into #a
select '10', 'aa'
union
select '20', 'bb'
union
select '30', 'bb'
union
select '11', 'bb'
union
select '210', 'bb'


SELECT * FROM #a
where '10, 11, 13, 12, 40, 47, 48, 49, 90, 92, 91, 94, 95, 96, 30, 31, 33, 34, 35, 24, 20, 21'
like '%' + menuid + ',%'
order by menuid

-
10aa
11bb
20bb
30bb
--lz what are you going to do?

idpublic

idpublic
 
 
   SELECT * FROM TableName
where menuid like '%' || variable || ',%' order by menuid


---------
I'm wrong
Finally understood the meaning of lz

idpublic

CREATE TABLE ta (menuid VARCHAR2 (20), aaa VARCHAR2 (20))

for connection in oracle ||
INSERT INTO ta
SELECT '10', 'aa' FROM dual
UNION
SELECT '20', 'bb' FROM dual
UNION
SELECT '30', 'bb' FROM dual
UNION
SELECT '11', 'bb' FROM dual
UNION
SELECT '210', 'bb' FROM dual



SELECT * FROM ta
WHERE '10, 11, 13, 12, 40, 47, 48, 49, 90, 92, 91, 94, 95, 96, 30, 31, 33, 34, 35, 24, 20, 21'
 LIKE '%' || TO_CHAR (menuid) || ',%' ORDER BY menuid

shijieb16

oracle connector is ||, not +

szj0571

I changed the method, but first collect, thank you very much!