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,…
Category: 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…
Oracle data types examples
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…
Create tables and use SELECT query using SQL Developer
Using SQL Developer you can easily create table and insert data without writing any query. After inserting data, SELECT query is used to retrieve data…
How to use SQL Developer and connect with a database
When the Oracle in installed and configured properly then the user can run and use SQL Developer to create database and do other database related…
How to install Oracle 12c on Windows
Oracle is a popular database software to develop large application. You can download the latest standard or enterprise version of oracle from the oracle website…