Oracle WHERE Clause

The Oracle WHERE clause allows you to filter the results from an SQL statement.

This Oracle WHERE clause chooses which rows to filter in result from an SQL statement For Update SQL: Only rows that meet the search condition are updated. If you omit the search condition, all rows in the table are updated.

For Oracle SELECT INTO SQL: Only rows that meet the search condition are selected. If you omit the search condition, all rows in the table are selected.

For INSERT INTO Oracle SQL: Only rows that meet the search condition are inserted. If you omit the search condition, all rows in the table are inserted.

For DELETE SQL: Only rows that meet the search condition are deleted. If you omit the search condition, all rows in the table are deleted.

where sql server Examples

UPDATE emp SET sal = sal * 1.10 WHERE job = 'ANALYST' AND DEPTNO = 20;

In this example, we've used the WHERE clause to filter our results from the emp table. The SQL statement above would update all rows from the emp table where job = 'ANALYST' AND DEPTNO = 20.

We can also use the WHERE Oracle clause to join multiple tables together in a single SQL statement with Oracle inner join or outer join.

Learn more about Oracle Function inner joins Learn more about insert into Oracle Learn more about Oracle order by Learn more about insert into where Learn more about Oracle select into Learn more about sql server where Learn more about Oracle select where


	29-11-2006 Guida Oracle 10g

	29-11-2006 Guida Oracle9i

	29-11-2006 Create Functions

	Oracle Function
	Delete
	Between
	Check
	Count
	Datatypes
	Oracle Delete Statement
	Distinct
	Exists
	Functions
	Grant Revoke
	Oracle Group by
	Having
	Oracle Function in
	Indexes
	Insert
	Intersect
	Is null
	Joins
	Substr

Oracle Functions PLSQL l Consulenza Software Verona l Siti Web Verona l Exceptions l Oracle Errors l Oracle Collaborations Suite l Products l Contact