Answers for "substring in where clause oracle"

SQL
6

oracle substring

-- ORACLE substr(string, start, [, length ])
SELECT substr('Hello World', 4, 5) FROM DUAL;       -- lo Wo
SELECT substr('Hello World', 4) FROM DUAL;          -- lo World
SELECT substr('Hello World', -3) FROM DUAL;         -- rld
SELECT substr('Hello World', -3, 2) FROM DUAL;      -- rl
Posted by: Guest on March-22-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language