|
is this u want
SQL> create table ex(name char(20),id number);
Table created.
SQL> insert into ex values('&name',&id);
Enter value for name: p will
Enter value for id: 1
old 1: insert into ex values('&name',&id)
new 1: insert into ex values('p will ',1)
1 row created.
SQL> /
Enter value for name: will g
Enter value for id: 2
old 1: insert into ex values('&name',&id)
new 1: insert into ex values('will g',2)
1 row created.
SQL> /
Enter value for name: p will g
Enter value for id: 3
old 1: insert into ex values('&name',&id)
new 1: insert into ex values('p will g',3)
1 row created.
SQL> select * from ex where name like '%will%';
NAME ID
-------------------- ----------
p will 1
will g 2
p will g 3
|