Difference between revisions of "SELECT Reference"

Revision as of 11:13, 9 January 2013

CREATE TABLE emp (ID NUMBER, name VARCHAR2(40));

@@ Line 1: / Line 1: @@
-{{SELECT Ref}}
+CREATE TABLE emp (ID NUMBER, name VARCHAR2(40));
-The [[SELECT]] command is used to show data from a database.
-The output from a SELECT statement is always a grid - with a number of rows and a number of columns.
-The simplest SELECT commands involve a single table:
-<div class='ht'>
-<source lang='sql'>
-SELECT name, population
-  FROM bbc
- WHERE region='North America'
-</source>
-</div>