Answers for "oracle pl sql substring"

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 "oracle pl sql substring"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#