Pass comma separated string inside IN Operator
How Comma Separated Values can be passed to IN Operator to display result?
Select * From Employee;
Select * From Employee Where NAME IN('Ravi,Akif,Pritesh,Karan');
SELECT REGEXP_SUBSTR('Ravi,Akif,Pritesh,Karan','[^,]+', 1, Level) From Dual
CONNECT BY REGEXP_SUBSTR('Ravi,Akif,Pritesh,Karan', '[^,]+', 1, Level) IS NOT NULL;
SELECT * From EMPLOYEE Where NAME IN
(
SELECT REGEXP_SUBSTR('Ravi,Akif,Pritesh,Karan','[^,+', 1, Level) From Dual
CONNECT BY REGEXP_SUBSTR('Ravi,Akif,Pritesh,Karan', '[^,]+', 1, Level) IS NOT NULL
);
SET SERVEROUTPUT ON
CREATE OR REPLACE PROCEDURE GetDetails( in_myString in varchar)
As
Cursor C1 IS
Select NAME,DEPTID,SALARY From EMPLOYEE
Where NAME in (Select Regexp_Substr(in_myString ,'[^,]+', 1, level) From Dual
Connect By Regexp_Substr(in_myString, '[^,]+', 1, level) IS Not Null);
Begin
For rec in C1
Loop
DBMS_OUTPUT.PUT_LINE('EMPLOYEE ' ||rec.NAME ||' Is Associted With ' || rec.DEPTID || ' with Salary : ' || rec.SALARY);
End Loop;
End;
BEGIN
GETDETAILS('RRavi,Akif,Pritesh,Karan');
END;
CREATE OR REPLACE PROCEDURE GetDetails(in_myString in Varchar)
As
Cursor C1 IS
Select NAME,DEPTID,SALARY From EMPLOYEE
Where INSTR(in_myString,NAME) {Greater Than} 0;
BEGIN
For rec in C1
Loop
DBMS_OUTPUT.PUT_LINE('EMPLOYEE ' ||rec.NAME ||' Is Associted With ' || rec.DEPTID || ' with Salary : ' || rec.SALARY);
End LOOP;
End;
Home Page
https://tipsfororacle.blogspot.com/
#GoLearningPoint
En esta página del sitio puede ver el video en línea Pass comma separated string inside IN Operator de Duración hora minuto segunda en buena calidad , que subió el usuario GoLearningPoint 12 agosto 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 827 veces y le gustó 6 a los espectadores. Disfruta viendo!
