Mar 9, 2012 · SELECT Statement with substr in WHERE Clause Asked 13 years, 11 months ago Modified 12 years, 8 months ago Viewed 107k times

I've started using SUBSTR and INSTR in Oracle but I got confused when I came across this. SELECT PHONE, SUBSTR(PHONE, 1, INSTR(PHONE, '-') -1) FROM DIRECTORY; So I know SUBSTR cuts …

Feb 21, 2015 · I am having problem with sql. I want to join two tables, employee and class instructor. Condition is that employee is having unid column like 'u0871457' where as class instructor is having …

Jul 2, 2024 · Oracle SQL query using regexp_substr to get string between 2 strings Asked 1 year, 7 months ago Modified 1 year, 7 months ago Viewed 163 times

Apr 7, 2022 · How to convert regexp_substr (Oracle) to SQL Server? Asked 3 years, 10 months ago Modified 3 years, 10 months ago Viewed 2k times

8 SELECT REGEXP_SUBSTR('STRING_EXAMPLE','[^_]+',1,1) from dual is the right answer, as posted by user1717270 If you use INSTR, it will give you the position for a string that assumes it contains …

Mar 15, 2017 · how to use regexp_substr Asked 8 years, 11 months ago Modified 8 years, 11 months ago Viewed 6k times

Aug 9, 2010 · I am writing a query in Oracle. I want to get a string from the right hand side but the string length is dynamic. Ex: 299123456789 I want to get 123456789 substr (PHONE_NUMBERS,-X,Y) X …

Feb 18, 2015 · 4 You seem to be confusing the concat function, substr function and the concatentation operator (||). You aren't using substr to get the first character of the first name, and to restirct the …

Jun 17, 2014 · I think what you are doing is quite safe. substr() is not going to "add" characters to the end of the string when the string is too short. I have depended on this behavior in many databases, …