Query

From Oracle FAQ
Jump to: navigation, search

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.

Also see[edit]

  • 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
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #