SQL Oracle Java JSP JDBC PHP MORE

Oracle WHERE Clause

To select, update, delete specific record from the table where clause is used.

Oracle Where Clause use for Select

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;

The WHERE clause specifies which record or records that should be selet. If you omit the WHERE clause, all records will be select.

Oracle Where Clause use for Delete

DELETE column_name,column_name
FROM table_name
WHERE column_name operator value;

The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted.

Oracle Where Clause use for Update

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

The WHERE clause specifies which record or records that should be Update. If you omit the WHERE clause, all records will be Update.