oracle 常用操作

dual

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

oracle数据类型

SELECT * FROM DBA_TYPES WHERE OWNER IS NULL;

字符集

select * from nls_database_parameters;
-- 服务端的字符集
select * from V$NLS_PARAMETERS;
select userenv('language') from dual;
-- 客户端的字符集
select * from nls_instance_parameters;

觉得文章实用，请在右上方点个赞