Oracle 查询语句

Oracle 按照 in 的顺序排序

SELECT t.* FROM table_name t where t.field_code in () order by instr(,t.field_code )

Oracle 查询结果有没有重复的

select * from (select t.code,count(1) from table t group by t.code having count(1) > 1)

select tli.d_dealdate
  from (select li.c_projectcode,
               li.d_dealdate,
               row_number() over(partition by li.c_projectcode order by li.c_liquidationstatus desc nulls last) rn
          from tproject_liquidation_info li, tproject_info tp
         where li.c_projectcode = tp.c_projectcode) tli
 where tli.rn = 1
   and tli.c_projectcode = c.c_projectcode

在PL/SQL中中查找某个字段属于哪个表的SQL语句

SELECT t.TABLE_NAME FROM cols t WHERE t.COLUMN_NAME = 字段名(大写)