Snippet Name: SELECT name columns Description: Select specific columns by naming the columns to be used. 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 » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
Description: Select specific columns by naming the columns to be used.
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 » UPDATE: Update from a SELECT statement » Inserting into SELECT statement » INSERT with Select
SELECT <column_name, column_name, ..., <column_name> FROM <table_name>; SELECT age, gender, city FROM user_list;
