Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
Oracle
Oracle WHERE

Oracle WHERE

The Oracle WHERE clause can be used in a SELECT statement, UPDATE statement, or DELETE statement.

Oracle WHERE example

Select *
From users u 
Where u.name = 'EVA' ;

Select *
From books b 
Where b.author = 'SMITH'
And book_name Like '%ORACLE%'

Select 
id, name, create_date
From users  
Where create_date > 
	(Select create_date
	From users
	Where name='SCOTT');

Tutorials

  • Oracle Tutorial
  • Oracle Create Table
  • Oracle Insert
  • Oracle Update
  • Oracle Delete
  • Oracle Anonymous Block
  • Oracle Data Types
  • Oracle Conditional Statements
  • Oracle Transaction Statements
  • Oracle Loop Statements
  • Oracle Cursors
  • Oracle Create Procedure
  • Oracle Create Function
  • Oracle Create Package
  • Oracle Create View
  • Oracle Create Trigger
  • Oracle Exception

Recent Posts

  • Java Polymorphism
  • Java Encapsulation
  • Java Abstraction
  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
  • PostgreSQL Create database user, alter and drop username
  • PostgreSQL Alter table name. Modify column name
Coder Tutorial Copyright © 2025. | Privacy Policy
Back to Top ↑
x