Not equals : NOT « Query Select « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Query Select
  3. NOT
SQL>
SQL>
SQL> create table departments
  2  ( deptno NUMBER(2)     constraint D_PK
  3                         primary key
  4  , dname  VARCHAR2(10)
  5  , location VARCHAR2(8)
  6  , mgr    NUMBER(4)
  7  ) ;

Table created.

SQL>
SQL> insert into departments values (10,'ACCOUNTING','NEW YORK',7);

1 row created.

SQL> insert into departments values (20,'TRAINING',  'DALLAS',  4);

1 row created.

SQL> insert into departments values (30,'SALES',     'CHICAGO', 6);

1 row created.

SQL> insert into departments values (40,'HR',        'BOSTON',  9);

1 row created.

SQL>
SQL>
SQL> select dname, location
  2  from   departments
  3  where  location <> 'CHICAGO';

DNAME      LOCATION
---------- --------
ACCOUNTING NEW YORK
TRAINING   DALLAS
HR         BOSTON

SQL>
SQL> drop table departments;

Table dropped.

SQL>








2.25.NOT
2.25.1.NOT to negate a boolean value
2.25.2.Or, and, not
2.25.3.NOT operator has higher priority than AND
2.25.4.Not empty(null)
2.25.5.Not equals
2.25.6.Not equals: not vs <>
2.25.7.not in (1,2,3,NULL)
2.25.8.not in vs not exists
2.25.9.Not has the lowerest priority
2.25.10.Not(condition1 and condition2)
2.25.11.Using Not in and subquery