Difference between revisions of "SELECT Reference"

Revision as of 12:00, 31 December 2012

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

@@ Line 1: / Line 1: @@
-{{SELECT Ref}}
+CREATE TABLE emp (ID NUMBER, name VARCHAR2(50));
-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' class='sql'>
-SELECT name, population
-  FROM bbc
- WHERE region='North America'
-</source>
-</div>