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

<< lastnext >>

Snippet Name: AND Condition

Description: The AND condition allows you to create an SQL statement based on 2 or more conditions being met. It can be used in any valid SQL statement - select, insert, update, or delete.

Also see:
» ORDER BY Clause
» FLASHBACK: AS OF clause
» BETWEEN Condition
» LIKE Condition
» Combining the AND and OR Conditions
» OR Condition
» WHERE Clause - Joins
» WHERE Clause - Conditions
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» UPDATE: with RETURNING clause
» INSERT With Returning Clause
» Date Functions: WHERE Clause Joins
» Having Clause
» WITH Clause: Single alias
» WITH Clause: Double alias

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

-- The syntax for the AND condition is:
 
SELECT columns
FROM tables
WHERE column1 = 'value1'
AND column2 = 'value2';
 
-- The AND condition requires that each condition be must 
-- be met for the record to be included in the result set. 
-- In this case, column1 has to equal 'value1' and column2 
-- has to equal 'value2'.
 
 
 
-- Example #1
 
-- The first example that we'll take a look at involves a very 
-- simple example using the AND condition.
 
SELECT *
FROM suppliers
WHERE city = 'New York'
AND TYPE = 'PC Manufacturer';
 
-- This would return all suppliers that reside in New York 
-- and are PC Manufacturers. Because the * is used in the select, 
-- all fields from the supplier table would appear in the result 
-- set.
 
 
 
--Example #2
 
-- Our next example demonstrates how the AND condition can be 
-- used to "join" multiple tables in an SQL statement.
 
SELECT orders.order_id, suppliers.supplier_name
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
AND suppliers.supplier_name = 'IBM';
 
-- This would return all rows where the supplier_name is IBM. 
-- And the suppliers and orders tables are joined on supplier_id. 
-- You will notice that all of the fields are prefixed with the 
-- table names (ie: orders.order_id). This is required to 
-- eliminate any ambiguity as to which field is being referenced; 
-- as the same field name can exist in both the suppliers and 
-- orders tables.
 
 


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 183 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?