From Oracle FAQ
A query is a SQL SELECT statement that reads data from tables and views within the database, and returns the result set to the requester. Queries cannot change data within the database, use DML statements if you need to make changes.
- Select - statement used for querying the database.
- Join - query data from several tables.
- Subquery - SELECT statement in the WHERE- or HAVING-clause of another SELECT statement.
- Inline view - SELECT statement in the FROM-clause of another SELECT statement.
- SQL Reference
|Glossary of Terms