CRUD operation in ORACLE:

What is CRUD operation?

Within programming , the acronym CRUD stands for create, read, update and delete. These are the four basic functions of CRUD. Also, each letter within the acronym can ask all functions executed in electronic database applications and mapped to a typical HTTP method, SQL statement or DDS operation.

The first regard to CRUD operations came from Haim Kilov in 1990 in a piece of writing titled, “From semantic to object-oriented data modeling.” However, the term was first made popular by James Martin’s book (1983), Managing the Data-base Environment. Here’s a breakdown

 

CREATE procedures: Performs the INSERT statement to create a new record.
READ procedures: Reads the table records supported the first keynoted within the input parameter.
UPDATE procedures: Executes an UPDATE statement on the table supported the required primary key for a record within the WHERE clause of the statement.
DELETE procedures: Deletes a specified row within the WHERE clause.

 

Click the following link for CRUD operation

CRUD Operation by using SQL 

CRUD Operation by using PL/SQL