Subscriber Comments Reply Video 44 | SQL query to find second occurrence of character in string

Subscriber Comments Reply Video 44 | SQL query to find second occurrence of character in 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

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

[daljeetsingh]

With ds as
( select 'BANANA' s from dual ),
D1 as (
Select s,
Substr( s, level, 1) c,
Rownum,
Row_number() over (partition by s, Substr(s, level, 1) order by rownum)
r_no
From ds,
lateral ( select level from dual connect by level <= length (s) ) order by rownum )
Select s, c from D1
Where
C not in (select c from D1 where r_no >2) and
R_no= 2 and
Rownum = 1;

[sreekanthreddy]

Thank you so much for your explanation

[arjunl]

Very Good Explanation Anna,
Thanqq Guruji😍

[themavrck]

Please make vedio on exception handling when working with Oracle collection

[rajeshnaidu]

Dear Siva,
I need your help on to achieve this scenario

In one table one row data need to split 2 columns.

table structure like as below:

Name type
Dept1 de
Dept2 de
Dept3 de
Sect1 se
Sect2 se
Sect3 se

My desired output should be like as below

Type name type name
De dept1 se sect1
De dept2 se sect2
De dept3 se sect3

Thanks for helping people .

[SriLife]

Will it work on bunch of strings available in a table. Insted of on one string.

[theboss]

Thank you for video. Waiting for Talend tutorials

[dhavalpandya]

Hi Sir,
Why we are using Lateral join here ?
Can not we directly use something like
Select S from dual connect by level <= length(S)

[ramakantmishra]

Can't we just simply take the top 1 record where cnt=2 Order by level?

[srikanthk.chandiran]

Hi Sir, This is fantastic video. With gratitude, Srikanth.