oracle 前N行
select date_id,customer_code,product_code,brand_owner_code,sale_qty,sale_amt from t_sale_in where rownum <5;
oracle 字符串转化成数字
select date_id,customer_code,product_code,brand_owner_code,to_number(sale_qty),to_number(sale_amt) from t_sale_in where rownum <5
|
