select max(to_number(a_id) from tblauthor;

select max(to_number(substr(a_id,2,20))) from tblauthor;

select tblbooks.title,tblstock_detail.quantity,tblstock_detail.rate
from tblbooks,tblstock_detail
where tblbooks.b_id = tblstock_detail.b_id and tblstock_detail.st_id='S1';


select tblbooks.title,tblsales_detail.quantity,tblsales_detail.price
from tblbooks ,tblsales_detail
where tblbooks.b_id = tblsales_detail.b_id and tblsales_detail.s_id = 'S4';

 select tblpublisher.p_name,tblstock_master.st_date,tblstock_master.tot_cost
from tblpublisher,tblstock_master
where tblpublisher.p_id  =tblstock_master.p_id and tblstock_master.st_date between
 '01-feb-01' and '28-feb-01';


select tblcustomer.c_name,to_char(sales_date),tblsales_master.tot_cost
from tblcustomer,tblsales_master
where tblcustomer.c_id  =tblsales_master.c_id and tblsales_master.sales_date between
 '01-feb-01' and '28-feb-01';