【oracel】sql语句

1.case when

select g.goodsid as "商品编号",
       g.goodsnumber as "商品ID",
       g.goodsname as "商品名称",
       CASE g.gettype
         WHEN '1' THEN
          '网点自领'
         WHEN '2' THEN
          '物流配送'
         WHEN '3' THEN
          '网点自领和物流配送'
         WHEN '4' THEN
          '虚拟便民'
         ELSE
          '其他'
       END as "配送方式",
       u.custname as "所属商户",
       g.goodsAmount as "库存数量",
       g.goodsPrice as "协议价",
       CASE g.authStatus
         WHEN '1' THEN
          '待审核'
         WHEN '2' THEN
          '已授权'
         WHEN '3' THEN
          '已下架'
         WHEN '4' THEN
          '违规商品'
         WHEN '5' THEN
          '已删除'
         WHEN '6' THEN
          '拒绝授权'
         WHEN '7' THEN
          '待授权'
         ELSE
          '其他'
       END as "授权状态" 
  from GoodsInfo@emall_dblink g, CUSTINFO@emall_dblink u 
 where g.custid = u.custid and u.custname != '广州晶东贸易有限公司';