Substr and Instr in Oracle|Extracting data from String

Using Substr and Instr We can extract any string from a Text/Column,.
This video Explain Instr and Substr in detail along with 10 practice Exercises that will help you gain expertise in the topic
You can use the below code to create the table and insert the data
create table susbtr_instr
(
text varchar2(1000)
);

#Instr #Substr #TechCoach

[jagdeeshj]

Thanks Tech coach. We usually tend to forget how to correctly use substr instr, if we do not use it frequently. Saved me good time with this quick reference.

[ekramquadri]

i struggled last 3 days and u resolved my query 🙏🙏🙏

[shruthis]

Seriously you are very good in explaining.. I have learned so much from your videos.. you deserve more subscribers.. all the best👍

[seshadharan]

Very clear explanation👏👏, thanks alot.. Finally I understood clearly with help of your video.

[kishorshitole]

Sir I want search (, ) comma notation from string with the help of instr function.
Please give me query.
Sir please help me.

[optimistic_guy]

Again you helped me . Just what i was looking for. Specially the last condition. Thank you again

[AliBaba-mxof]

Thanks for the video sir. I have learnt lot of things about instr Nd substr..

[manasikhadpe]

This is exactly what I was looking for 🙌 Thank you so much 🙏

[ramashrayayadav]

Sir how do i get this with hel of loop i want to how loop works on substring and instring plz explain in detail
Thank you

[prash]

Thanks Vivek for the explanation. I had a question. If occurrence of dots varies in texts, then how can I retrieve the last substring from it?

[vishwannadhvishwa]

Vivek, Thanks for nice explanation.

I am not getting the answer for 10th question.

Can u please

[wrathwick]

Very well explanation ... Keep posting like intresting content.. these are very helpful for us We waiting for you to back....❤️
And it's been a year for the last video u have uploaded,
we need a guide like you, so pls try to make video regularly on weekly basis or your wish. Thanks for the knowledge sharing #TechCoach❤️

[irfanmishi]

where do we get the answers for those practice excersiges

[Nalini]

To Extract PQR Query:
SELECT SUBSTR(TEXT, INSTR(TEXT, '.', 1, 1)+1, (INSTR(TEXT, '@', 1, 1)-INSTR(TEXT, '.', 1, 1))-1)FROM DOMAIN_NAME;

[swapnaram]

I have ever seen this type of explanation 🙏

[sowmyaramesh]

Thank you so much for the detailed explanation.It was really helpful. can you please post a video on P.K, F.K and unique key

[aiswithvdata]

Thanks for the share knowledge and also i like it

[mayhem]

Thank you very much. It helped a lot :)

[irfanmishi]

for 1st question ans= select substr(text, instr(text, '.', 1, 2)+1, instr(text, '.', 1, 3)-instr(text, '.', 1, 2)-1) from susbtr_instr;

[Nalini]

To extract COM query:

SELECT SUBSTR(TEXT, INSTR(TEXT, '.', 1, 2)+1, INSTR(TEXT, '.', 1, 3)-INSTR(TEXT, '.', 1, 2)-1) FROM DOMAIN_NAME;