INSTR examples in Oracle
Different uses of INSTR function in Oracle are shown here. Example-1: use of INSTR from the beginning of the string SELECT INSTR( 'Eat to live,…
Learn by easy steps
Different uses of INSTR function in Oracle are shown here. Example-1: use of INSTR from the beginning of the string SELECT INSTR( 'Eat to live,…
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…
This tutorial will help you to learn the uses of major data types in Oracle. Example-1: Use of char, varchar2 and Date data types Create…