NOT BETWEEN with varchar type : VARCHAR2 « SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE employees (
  2    au_id    CHAR(3)     NOT NULL,
  3    au_fname VARCHAR(15) NOT NULL,
  4    au_lname VARCHAR(15) NOT NULL,
  5    phone    VARCHAR(12) NULL    ,
  6    address  VARCHAR(20) NULL    ,
  7    city     VARCHAR(15) NULL    ,
  8    state    CHAR(2)     NULL    ,
  9    zip      CHAR(5)     NULL
 10  );

Table created.

SQL>
SQL> INSERT INTO employees VALUES('A01','S','B','111-111-1111','75 St','Boston','NY','11111');

1 row created.

SQL> INSERT INTO employees VALUES('A02','W','H','222-222-2222','2922 Rd','Boston','CO','22222');

1 row created.

SQL> INSERT INTO employees VALUES('A03','H','H','333-333-3333','3800 Ave, #14F','San Francisco','CA','33333');

1 row created.

SQL> INSERT INTO employees VALUES('A04','K','H','444-444-4444','3800 Ave, #14F','San Francisco','CA','44444');

1 row created.

SQL> INSERT INTO employees VALUES('A05','C','K','555-555-5555','114 St','New York','NY','55555');

1 row created.

SQL> INSERT INTO employees VALUES('A06',' ','K','666-666-666','390 Mall','Palo Alto','CA','66666');

1 row created.

SQL> INSERT INTO employees VALUES('A07','P','O','777-777-7777','1442 St','Sarasota','FL','77777');

1 row created.

SQL>
SQL>
SQL>
SQL> SELECT au_fname, au_lname, zip
  2    FROM employees
  3    WHERE zip NOT BETWEEN '20000' AND '89999';

AU_FNAME        AU_LNAME        ZIP
--------------- --------------- -----
S               B               11111

SQL>
SQL>
SQL> drop table employees;

Table dropped.

SQL>
SQL>








10.4.VARCHAR2
10.4.1.Varchar type column
10.4.2.Compare VARCHAR2 type value for equlity
10.4.3.Use Like operator on VARCHAR2 column
10.4.4.Update VARCHAR column
10.4.5.INSTR(first_name,',', 1)
10.4.6.Add an index to a varchar2 type column
10.4.7.varchar2 type column with default value
10.4.8.Not equal operator for varchar
10.4.9.NOT BETWEEN with varchar type
10.4.10.Use IN for varchar type
10.4.11.varchar type not equals or null value
10.4.12.varchar type not equals or not null value
10.4.13.Concatenate strings
10.4.14.Use concatenated string in where clause
10.4.15.Search for String Across Columns
10.4.16.Save HTML value to table
10.4.17.Save xml data to varchar2 type column