Oracle SQL - AI-powered Oracle SQL assistant

Example

SELECT * FROM employees WHERE department_id = 10;

Scenario

Used for querying specific data from the database. In this case, it retrieves all employee records from department 10.

Example

SELECT e.name, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id;

Scenario

Combines records from two tables based on related columns. Here, it retrieves employee names along with their respective departments.

Example

SELECT department_id, COUNT(*) FROM employees GROUP BY department_id;

Scenario

Aggregates data by specified columns, allowing summaries like totals or averages. This query counts the number of employees per department.

Example

SELECT * FROM employees ORDER BY hire_date DESC;

Scenario

Sorts results by specified columns. This query lists employees by their hire date, with the most recent hires first.

Example

INSERT INTO employees (name, hire_date, department_id) VALUES ('John Doe', '2024-01-01', 10);

Scenario

Adds new records to a table. This inserts a new employee into the employees table.

Example

UPDATE employees SET salary = salary * 1.10 WHERE department_id = 10;

Scenario

Modifies existing records. This query gives a 10% raise to all employees in department 10.

Example

DELETE FROM employees WHERE employee_id = 1001;

Scenario

Removes records from a table. In this case, it deletes the employee with the ID 1001.

Example

SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

Scenario

Allows nested queries for more complex logic. This query finds all employees earning above the average salary.

Example

SELECT AVG(salary) FROM employees;

Scenario

Performs calculations like sum, average, count on data sets. This query returns the average salary of all employees.