SUBSTR examples in Oracle

Database
Oracle

SUBSTR examples in Oracle

Different uses of SUBSTR function in Oracle are shown here. Example-1: use of SUBSTR without length SELECT SUBSTR( ‘Advanced Database Management System’, 9 ) TEXT FROM dual; Output: Example-2: use of SUBSTR with positive length SELECT SUBSTR( ‘Advanced Database Management System’, 9,8 ) TEXT FROM dual; Output: Example-3: use of SUBSTR with negative length SELECT […]

Read More