Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Like with % on both sides

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