Retrieving Data with Queries
The most basic SQL statement is a query. A query is a SQL statement that uses the SELECT command to retrieve information from a database. A query's result set is the set of columns and rows that the query requests from a database server. For example, the following query retrieves all rows and columns from the ORDERS table:
NOTEAll relational database systems, including Oracle, do not guarantee the physical order of rows in a table;therefore, do not be surprised if the order of the rows in your result sets are not identical to the order of the rows in the example result sets in this book. Later in this chapter, you ...
Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
