Oracle数据库创建计算字段
程序员文章站
2022-06-17 19:39:22
创建product表;
执行:
select prod_id,p1_num,p1_price,p1_num * p1_price as sum from product where order_nu...
创建product表;
执行:
select prod_id,p1_num,p1_price,p1_num * p1_price as sum from product where order_num = 1000;
输出:
订单号为1000的商品名,购买数量,单价,总价。