PL/SQL Delete

The Delete statement is part of Data Manipulation Language and allows the user to delete a single record or multiple records in a table. Syntax: DELETE FROM table; — delete all records DELETE FROM table WHERE condition; — delete single or multiple records; Example 1: DELETE FROM employees; — delete all records DELETE FROM employees…(Continue Reading)

PL/SQL Update

The Update statement is part of Data Manipulation Language and allows the user to update a single record or multiple records in a table. Syntax: UPDATE table SET column1 = new_value1; UPDATE table SET column1 = value1, column2 = value2, column3 = value3, … WHERE condition; Example 1: UPDATE employees SET salary = 100; UPDATE…(Continue Reading)

PL/SQL Insert

The Insert statement is part of Data Manipulation Language and  allows the user to insert a single record or multiple records into a table. Syntax: INSERT INTO table VALUES (value1, value2, value3, …); INSERT INTO table (column1, column2, column3, …) VALUES (value1, value2, value3, …); INSERT INTO table1 (column1, column2) SELECT column1, column2 FROM table2; Example…(Continue Reading)

PL/SQL Select

Syntax: select * from table; select column_name1, column_name2 from table_name; select column_name1, column_name2 from table_name where condition; Examples: select * from employees; select * from employees where dep_id=10; select name, salary from employees where dep_id=10;