Create procedure in Oracle
Procedure is used to execute the block of SQL statements multiple times in the database server. It works similar to the function or procedure of…
Category: Oracle
Create View in Oracle
View is a virtual table that is created from an existing database table. The way of creating, updating, and deleting view has been shown in…
Create auto-increment or auto-generated field in Oracle
The auto-increment attribute is used in the primary key field of the database table to increment the field automatically when any new record is inserted…
Third Normal Form (3NF) in Oracle
The concept of the third normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
Second Normal Form (2NF) in Oracle
The concept of the second normal form (2NF) has been explained in this tutorial by using the Oracle database tables. Run the SQL Developer application…
First Normal Form (1NF) in Oracle
The concept of the first normal form (1NF) has been explained in this tutorial by creating the tables in the Oracle database. Run the SQL…
Run Oracle 21c Home Page from the browser
Some settings need to configure to run oracle 21c home page from the browser. After completing the installation of oracle 21c, do the followings tasks…
Create table by using SQL statements in Oracle
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…
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',…