Snippet Name: SELECT Description: Use a SELECT statement or subquery to retrieve data from one or more tables, object tables, views, object views, or materialized views. Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select Comment: (none) Language: PL/SQL Highlight Mode: PHP Last Modified: March 05th, 2009
Description: Use a SELECT statement or subquery to retrieve data from one or more tables, object tables, views, object views, or materialized views.
Also see:» TABLE: Using Select Statement With Data » SELECT: Case insensitive search » SELECT: Partition Select » SELECT: Select For Update » SELECT: Using Functions » SELECT: Get DISTINCT or UNIQUE values » SELECT: Get UNIQUE and DISTINCT values » SELECT: Scalar Select » SELECT with HAVING Clause » SELECT with GROUP BY Clause » SELECT with WHERE Clause » SELECT with SAMPLE clause » SELECT placement » SELECT into a table » SELECT name columns » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select
SELECT * FROM <table_name>; -- select all columns and records in a single table SELECT * FROM some_table;