Category: Oracle

The Oracle IS NULL and IS NOT NULL are comparison conditions used to test for nulls. Oracle IS NULL and IS NOT NULL example Select * From invoices i Where i.printed IS NULL; Select * From invoices i Where i.printed IS...

The Oracle NOT operator returns TRUE if the following condition is FALSE. Returns FALSE if it is TRUE. The NOT operator can be used NOT EXISTS, NOT Between, NOT Like, NOT IN. Oracle NOT example Select * From users_log u Where...

The Oracle LIKE operator specify a test involving pattern matching. Oracle LIKE example Select * From customers c Where c.name Like '%CORPORATE%'; Select * From customers c Where c.name Like 'CORP%'; -- begin with CORP Select * From customers c Where...

The Oracle HAVING clause restricts the rows of a GROUP BY clause. Oracle HAVING example Select c.name, sum(c.income) AS "Total Income" From customers c Group By c.name Having sum(c.income) > 50; Select c.name, sum(c.income) AS "Total Income" From customers c Where...

The Oracle GROUP BY clause groups a select result into subsets that have matching values for one or more columns. Oracle GROUP BY example Select id, product, avg(amount), sum(amount), max(amount), count(*) From sales Group By id, product Order By id ;...