Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Like % function with varchar2 type

SQL> CREATE TABLE customers   2  (   3     id                NUMBER,   4     lname         VARCHAR2(40)   CONSTRAINT           customer_lname_nn NOT NULL,   5     main_phone_number VARCHAR2(25),   6     credit_limit      NUMBER,   7     email             VARCHAR2(30)   8  ); Table created. SQL> select lname, credit_limit   2  from   customers   3  where  lname like 'Q%'; no rows selected SQL> SQL> drop table customers; Table dropped.