一、遇到的问题
1、insert into ......的场合发生,ORA-01843: not a valid month 错误
问题:timestamp类型不一致。timestamp的日期格式为YYYY-MM-DD HH24:MI:SS.FF6
解决方法(回话级别的设置):
alter session set nls_date_language='AMERICAN';
alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF';
查看会话参数:
select * from nls_session_parameters where parameter='NLS_DATE_LANGUAGE'
二、一些实用的语句
1、查询表结构
select
-- ut.owner as 用户名,
-- ut.table_name as 表名,
ut.COLUMN_NAME as 字段名,
uc.comments as 注释,
ut.DATA_TYPE as 类型,
ut.DATA_LENGTH as 长度,
ut.NULLABLE as 是否为空,
ut.data_default as 默认值
from all_tab_columns ut
inner JOIN all_col_comments uc
on ut.TABLE_NAME = uc.table_name and ut.COLUMN_NAME = uc.column_name
where ut.Table_Name=upper('T_SRV_WAYBILL_COMMISSIONS');