Like with % on both sides : Like « Select Query « Oracle PL / SQL

1. Oracle PL / SQL
2. Select Query
3. Like

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.

   
    
    
  

Related examples in the same category