CoderZone.org

Category: >> Oracle PL/SQL >> SELECT into a table Bookmark and Share

<< lastnext >>

Snippet Name: SELECT into a table

Description: Create a table by SELECTing rows into it from another table or tables.

Also see:
» TABLE - Using Select Statement Wi...
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT / UNIQUE valu...
» SELECT: Get UNIQUE / DISTINCT valu...
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT state...
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

SELECT <clause>
INTO <clause>
FROM <clause>
WHERE <clause>
 
CREATE TABLE <table_name> AS
SELECT <column_name, column_name, ..., <column_name>
FROM <table_name>;
 
CREATE TABLE user_list AS
SELECT *
FROM old_users;
 
SELECT * FROM user_list;
 
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 29