var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to chage this informix sql to oracle sql?
anyone know how to chage this informix sql to oracle sql?
select cust_name[1,40] from customer;
the original cust_name is char(60), i just want its first 40 character. how to do that?
thanks for ur help!
Please use Function Substr(str,begin,length)
Originally Posted by jasontck
select Substr(cust_name,1,40) as cust_name