Oracle

Database
Oracle

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 creation statements on SQL developer by using multiple examples. Example-1: Creating a table with a primary key(s) The following statement will create a table named ‘customers’ with four fields (id, […]

Read More
Database
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 new database with separate database schema then it is necessary to use different username and password. You can create a new user from the command line by using SQL PLUS […]

Read More
Database
Oracle

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’, ‘Oracle’, ‘MySQL’ ) Replaced_text FROM dual; Output: Example-2: use of REPLACE in the table create the post table with the following structure: CREATE TABLE post ( post_id NUMBER GENERATED BY […]

Read More
Database
Oracle

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, not live to eat’, ‘eat’ ) TEXT FROM dual; Output: Example-2: use of INSTR with positions and occurrence SELECT INSTR( ‘Eat to live, not live to eat’, ‘live’, 5, 2) […]

Read More
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
Database
Oracle

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 a table named members that consists of 5 fields, acc_id, acc_name, acc_type, acc_nid, acc_create_date. acc_id and acc_nid char and other fields are varchar. CREATE TABLE members ( acc_id CHAR(10), acc_name VARCHAR2(50), acc_type VARCHAR2(7), […]

Read More
Database
Oracle

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 from any table based on different criteria. How these types of tasks can be done using SQL developer of Oracle 12c is shown in this tutorial. Before starting this tutorial […]

Read More
Database
Oracle

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 operations. SQL developer provides GUI to do database task more easily. If you install oracle 11g or oracle 12c then SQL developer will be installed by default. How you can […]

Read More
Database
Oracle

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 from SQL plus to run oracle home page from the browser. Before starting this tutorial you have to install oracle 12c. The installation steps of oracle 12c is shown in […]

Read More
Database
Oracle

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 and install it on your computer. Go to the following URL location and download oracle installer according to the configuration of your computer. https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Click on Accept License Agreement and […]

Read More