Oracle SQL-Oracle SQL Database Management

Example

SELECT * FROM employees WHERE department_id = 10;

Scenario

A company’s HR department needs to extract information about employees in a specific department. Using a simple SELECT statement, they can retrieve all records from the employees table where the department_id matches 10. This function is essential for retrieving specific data from large databases efficiently.

Example

UPDATE employees SET salary = salary * 1.1 WHERE performance_rating = 'A';

Scenario

After an annual performance review, a company decides to give a 10% raise to all employees with an 'A' performance rating. The UPDATE statement in Oracle SQL allows the company to modify existing records in the database based on specified criteria, ensuring that only the intended records are updated.

Example

CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department_name VARCHAR2(50));

Scenario

A company is expanding and needs to create a new structure for managing its departments. Oracle SQL's Data Definition Language (DDL) allows the creation of new tables, which define the structure of the database. In this case, a new table named 'departments' is created with fields for department_id and department_name.