Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: SELECT: Scalar Select Jump to:  
Category: >> Oracle PL/SQL >> SELECT: Scalar Select Bookmark and Share

<< lastnext >>

Snippet Name: SELECT: Scalar Select

Description: The scalar SELECT command retrieves columns and rows from a table based on specified criteria.

Use the optional TOP keyword to display only the first num_rows number of rows of the query results that match the selection criteria. If you include the TOP keyword, you must also include an ORDER BY clause to order (or sort) the selected rows.

Also see:
» TABLE - Using Select Statement With D...
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT / UNIQUE values
» SELECT: Get UNIQUE / DISTINCT values
» 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
» 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

SELECT [ TOP num_rows ] { * | scalar_column_expr [ AS alias_name ],... }
 FROM [ database_name.]object_name
 [ WHERE condition ]
 [ ORDER BY column_name_or_alias [ ASC | DESC ] ,... ];
 
 
SELECT * FROM call.status WHERE Item_Severity = 4;
 
 
-- in this example, the virtual column Item_Severity + Tally is 
-- populated by adding the values of the two columns together:
 
SELECT Item_Severity, Item_Severity + Tally FROM call.status;
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 266 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?