Create table by using SQL statements in Oracle 12c
Using create table statement table columns and constraints can be declared very easily. This tutorial will help you to learn different types of database table…
Category: Oracle
How to create new database user on Oracle 12c from SQL Developer
By default, we make a connection with the database by the username and password of any default user. But when we need to create any…
REPLACE examples in Oracle
Different uses of REPLACE function in Oracle are shown here. Example-1: use of REPLACE in the string SELECT REPLACE( 'Oracle is a relational database system',…
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,…
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…
Run Oracle 12c Home Page from the browser
Some settings need to configure to run oracle 12c home page from the browser. After completing the installation of oracle 12c, do the followings tasks…
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…