In Oracle you can create functions (standalone or in a package) and use them in a select statement.

Jun 17, 2014 · I want to trim a string to a specified length. If the string is shorter, I don't want to do anything. I found a function substr() which does the job. However there is nothing in the Oracle …

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 …

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 …

Nov 14, 2022 · The third argument to substr() is the length of the sub-string, not the end position. You would need to work out the number of characters between the underscore and period. Or do it with …

Oct 4, 2022 · i am using oracle sql. i would like to substr starting from characters XY0 and include 2 or 3 more characters until '-' sign in the string These characters may be anywhere in the string. Original

Dec 17, 2015 · The trick with instr() is to use a negative offset, which starts the counting from the end our string. So instr(col1, ' ', -1) will locate the last space in COL1. My solution uses a WITH clause …

Jul 18, 2017 · I have VP3 - Art & Design and HS5 - Health & Social Care, I need to get string after '-' in Oracle. Can this be achieved using substring?

Jun 15, 2018 · Just for completeness' sake, here's a solution using regular expressions (not very complicated IMHO :-) ): select regexp_substr( …

SELECT Rtrim(Substr('123642134 10',1,Instr('123642134 10',' '))) AS quarter_cd FROM dual; Uses of string function used in upper query Instr ()- to get position of any character or space from the given …