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
Sur cette page du site, vous pouvez voir la vidéo en ligne Pass comma separated string inside IN Operator durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur GoLearningPoint 12 août 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 827 fois et il a aimé 6 téléspectateurs. Bon visionnage!
