Convert Strings To Rows of data in Oracle DB | Regular Expression Scenario Based Question | Part 04
Vložit
- čas přidán 5. 09. 2024
- Hello Learners :),
please mail on studentforyou07@gmail.com for any query .
Please find Below queries are solved in this tutorial :
CREATE TABLE EMP_DET(
EMP_ID VARCHAR2(50) NOT NULL,
F_NAME VARCHAR2(50) NOT NULL
)
INSERT INTO EMP_DET (EMP_ID,F_NAME) VALUES('E1','Rahul');
INSERT INTO EMP_DET (EMP_ID,F_NAME) VALUES('E2','Rohan');
INSERT INTO EMP_DET (EMP_ID,F_NAME) VALUES('E3','Rony');
INSERT INTO EMP_DET (EMP_ID,F_NAME) VALUES('E4','Ravi');
INSERT INTO EMP_DET (EMP_ID,F_NAME) VALUES('E5','Rohit');
SELECT * FROM EMP_DET WHERE EMP_ID IN(SELECT REGEXP_SUBSTR('E1,E3,E4','[^,]+',1,LEVEL)
FROM DUAL
CONNECT BY REGEXP_SUBSTR('E1,E3,E4','[^,]+',1,LEVEL)IS NOT NULL);
#sql #sqlinterviewquestionsandanswers #sqlinterviewquestions #sqlinterview#oracle #sqlquery #development #interview #sqlserver
#ScenarioBasedSQLQuestions
👍👍
👍