测试技能：oracle基础表由字段找表名、找注释、取部门头一条、拼接、替换、日期相加减

一、字符串拼结

–concat日期格式
select concat(‘0938’, to_char(sysdate,’hh24missyyyymmdd’)) strDateTime from dual;

select trunc(sysdate)-(INTERVAL ‘17’ YEAR) from dual; –查多少年

select REPLACE(‘/apps/opp/operator/images’, ‘/’ ,’\’) 返回值 from dual;

二、减去相应的天数

select sysdate,to_char(sysdate-184,’yyyy-mm-dd HH24:MI:SS’) from dual; –减184天

三、取部门中的每一行

select t.org_code, t.op_code

from (select row_number() over(partition by org_code order by open_date desc) rn, uum_operator.*
from uum_operator) t

where t.rn = 1;

四、由字段找出表名，字典项

–数据字典子表；
select * from sys_dd_item t where t.dd_id like ‘%CIF_VOCATION%’ for update;

–字段查表
select table_name from user_tab_columns where column_name like ‘

%VC%’

select *
from user_tab_columns
where Table_Name=’用户表’
order by column_name

–获取表注释：

select *
from user_tab_comments
where Table_Name=’用户表’

order by Table_Name

–获取字段注释：

select *
from user_col_comments
where Table_Name=’用户表’

order by column_name