Oracle SQL Practical question | SQL to convert comma separated string to rows and vice versa

Oracle SQL Practical question | SQL to convert comma separated string to rows and row of data to comma separated string

--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

[pankajkharade]

Hi Sir, if the input is having special characters then regexp neglects those special characters so is it possible that output will be along with including special characters
ex Input : ab51, ef#, 4i@, kl7n, ko9, =rx1 Output : ab51, ef, 4i, kl7n, ko9, rx1

[pathagara]

Thank for very nice way of answering it. Please give a solution for the same question without listagg function.

[YogeshSingh-stdx]

How can I achieve the same in Oracle 11 g . Converting column into row data

[chandudevarapu]

Happy Divali to you and your family siva Garu... Keep posting the wonderful videos like this... If it is possible please post Regular Expressions video

[dineshnikam]

How to merge two columns having different datatypes in single column?

[djjiang]

Thank you Sir ! Very good stuff! Question: do you know for SQLite, what should we use to split columns into rows?

[md.kamalhasan]

Sir I have a scenario where a table column havin multiple comma separated string is stored in single column...now I want that column to be used in subquery where it takes each string as different values

[subbareddygade]

Happy Diwali siva Sir,
sir, can i use first scenario this query
select deptno, wm_concat(ename) from emp group by deptno;

[aravindrajendran]

Your Thumbnail creation is really good bro..
Which let us to watch video...👌👍
Keep rocking...

[srinivass]

Can you please explain with and without no copy hint for out parameters !!!!

[Kaish]

what is 1, l indicating in regexp expression- regexp_substr(ename, '\w+', 1, l) towards end of the video

[devikas]

Hi sir,

How to extract the value from the below string?
Var:=

How to extract values 123, 345, 678 alone?

[vsr]

Thank you siva, wish you happy Diwali 🎉

[kunuturuaravindareddy]

Hi siva can you please make a video on extracting first_name, middle_name, last_name from a name like mahendra singh dhoni
first name mahendra, middle name singh, last name dhoni and it can be not just 3 words but also virat kohli where only two names present.Thank you for videos i learned a lot.

[harishukkisala]

Sir, the query is not working is there any other way suggest me pls .T hanks in advance.

[anonymoussocialissues]

Not executing last query it's showing SQL command not properly ended. I wrote a query. select dept_no, ename, regexp_count(ename, ', ' )+1, regexp_substr(ename, '/w+', 1, l) from emp, lateral ( select level l from dual connect by level<= regexp_count( ename, ', ')+1);

[subhashisoracle]

happy and prosperous diwali to you bhai and your family

[Ganeshay-]

All viewer ek to banta hai 👍 this tutorial is over all best in world .

[themavrck]

How can we separate, seperated value into seperate column

[spunch]

lateral(select level 1 from dual connect by level <= regexp_count('123, bbb', ')+1 ) not working