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…
Category: Database
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…
How to make HTML template dynamic using Reactjs, PHP and MySQL
Steps:1. Before starting this tutorial, you have to complete the previous tutorial that converts any HTML template into reactJS project. How you can make a…
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',…
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…