Oracle Sql语句大全

--查找数据库实例
select * from v$instance

--查看所有表空间
select name from v$tablespace;

--时间格式
select to_char(a.admission_date_time,'yyyy-MM-dd HH24:mi:ss') aa from pat_visit a;

--获取年月
select to_char(p.discharge_date_time, 'yyyy-mm') as strdate;

--上个月
add_months(trunc(to_date('2022-01-01','yyyy-MM-dd')),-1)

--拼接时间
select to_date(to_char(sysdate, 'yyyy-mm-dd') || ' 23:59:59', 'yyyy-MM-dd HH24:mi:ss') from dual;

--修改表名
ALTER TABLE DATACENTER.DC_CDA_INFO_SUBPROJECT RENAME TO DC_CDA_DATAITEMSETTING;

--同义词
create or replace public synonym DC_CDA_FILESETTING for DATACENTER.DC_CDA_FILESETTING;

--字段合并显示
select dept_discharge_from,wm_concat(t.patient_id) patient_id from pat_visit t group by t.dept_discharge_from;

--模糊查询(右)
where regexp_like(r.diagnosis_code,'^(A40|A41|T81.411)')