查找所有表含有某个字段的表
select table_name from DBA_TAB_COLUMNS whereCOLUMN_NAME='ID_EP_CONTRACT_HEADER';
select *from all_tab_columnswhere column_name='PARENT_ASSET_IND';
修改当前会话语言环境
讲语言改为英文
ALTER SESSION SET NLS_LANGUAGE=american;
将语言改回中文:
ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
将地域改为英文:
ALTER SESSION SET NLS_TERRITORY=america;
将地域改为中文:
ALTER SESSION SET NLS_TERRITORY=CHINA;
日期格式
BETWEEN to_date('2017-09-01 00:00:00','yyyy-MM-dd HH24:mi:ss') AND to_date('2017-09-18 00:00:00','yyyy-MM-dd HH24:mi:ss')
不为空
select *from INVOICES WHERE FUNDED_DATE IS NOT NULL ORDER BY FUNDED_DATE DESC;