Substr and Instr in Oracle|Extracting data from String 

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.

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

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

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

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

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

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❤️

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

Superb bro

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

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

To extract COM query: SELECT SUBSTR(TEXT,INSTR(TEXT,'.',1,2)+1,INSTR(TEXT,'.',1,3)-INSTR(TEXT,'.',1,2)-1) FROM DOMAIN_NAME;

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

Loved the video ..to the point it is

great explaining skills!!

I have ever seen this type of explanation 🙏

Vivek, Thanks for nice explanation. I am not getting the answer for 10th question. Can u please explain.....

Thanks for the share knowledge and also i like it

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

where do we get the answers for those practice excersiges

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

7 th ans= select substr('THE@THIS~THEN|THERE#THEIR',instr('THE@THIS~THEN|THERE#THEIR','|',1,1)+1,instr('THE@THIS~THEN|THERE#THEIR','#',1,1)-instr('THE@THIS~THEN|THERE#THEIR','|',1,1)-1)from Sample;

Thank you very much. It helped a lot :)

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?

6 th = select instr('THE@THIS~THEN|THERE#THEIR','TH',1,4)as result from Sample;

select substr('corona virus updates',instr('corona virus updates',' ',1)+1,instr('corona virus updates',' ',1,2)-instr('corona virus updates',' ',1)) from dual;

5th ans = select substr(rough,instr(rough,' ',1,1)+1,instr(rough,' ',1,2)-instr(rough,' ',1,1)-1)as rsult from sample;

What if u don't know how many times a dot occured before @domain and u want the last name (assume there are firstname.middlename.lastname@dmain and some data has no middle name). How to get last name in this case

Thank you

how to get exact match of first name and last name from email in oracle

HOW CAN I EXTRACT ONLY THE WORD ASIA FROM ABCINDIA(ASIA). PLEASE REPLY ME.. SIR

8th ans=RDBMS

9 th ans = ABCD

select substr(text,instr(text,'.',1,3)+1,instr(text,'.',1,4)-instr(text,'.',1,3)-1)from susbtr_instr; select substr(text,instr(text,'.',1,4)+1)from susbtr_instr;

Sir, Can you help me in solving this Question. Select * from EMP; Sample ------------- Siddhartha-T1000 Siddhartha-T1000-A Output : ------------- T1000 T1000-A Please help me Sir using regular expressions!