create table customer(id number(5),firstname varchar2(20),lastname varchar2(20),purchase product varchar2(30),price decimal(5));
insert into customer values(001,'ammu','anu','printer',4566.9);
insert into customer values(002,'bala','bharath','apple laptop',4556.8);
insert into customer values(003,'hardrick','pandiya','keyboard',5000.6);
insert into customer values(004,'thava','mani','cpu',3000.7);
select*from customer;
select id, cast(price as integer)intprice from customer;
select firstname cast||''||lastname from  where id=002;