GitHub

SQL_PLSQL_Exercises_for_Understanding

SELECT INSTR('BANANA AND ANANAS','AN',2,3) FROM DUAL; SELECT INSTR('BANANA AND ANANAS','A',1,2) FROM DUAL; SELECT INSTR('BANANA AND ANANAS','AN',3,2) FROM DUAL ...
LinkedIn

Mastering SQL SUBSTR and INSTR for String Manipulation

Mastering SUBSTR and INSTR in SQL 🧙‍♂️📊 Stop struggling with messy text data. 🛑 If you work with databases, you know that raw data is rarely perfect. Cleaning names, extracting domains from emails, ...
GitHub

EllData/SQL_INSTR

select phone_number, substr(phone_number, instr(phone_number, '.', 1,1)+1, instr(phone_number, '.', 1,2)-instr(phone_number, '.', 1,1)) melumat from hr.employees ...
makeuseof

SQL String Functions: 10 of the Most Useful

Sandra is a Tech enthusiast with a Journalism and Full-stack web development background. She specializes in web development and Cloud technology. For leisure, Sandra enjoys a good thriller, hugging ...
LinkedIn

SQL REGEXP Functions Explained: REGEXP_REPLACE, REGEXP_LIKE, REGEXP_COUNT & REGEXP_INSTR

🚀 Let’s learn together and grow Day 9 &10/ 365 – SQL Interview Learning 👉 REGEXP_REPLACE, REGEXP_LIKE, REGEXP_COUNT & REGEXP_INSTR Explained. Today we’ll cover four very important REGEXP functions ...