create table customer(id number(5),firstname varchar2(20),lastname varchar2(20),purchase product varchar2(20),price decimal(5));
insert into customer values(001,'akshaya','ammu','printer',3000.50);
insert into customer values(002,'anu','eadagam','mouse',4000.50);
insert into customer values(003,'ajith','kumar','keyboard',5000);
select*from customer;
select cast(price as integer)intprice from customer;
select firstname||''||lastname from customer where id=002;
select instr(firstname,'a')from customer where id=001;
select ltrim('ak','shaya')ltrim from customer;
select rtrim('anu','eadagam')rtime from customer;
select length(firstname)from customer where id=002;
select replace(firstname, 'deepi','ka')from customer;