一,PL/SQL使用文档
在登录上PL/SQL Developer后,在对象的选项里面找到——>my objects——>tables——>根据你要的表名——>view(查看)
1,用pl/sql查看表里字段代表的含义——注释
SQL> select userenv('language') from dual; #查询字符集
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL> show user
USER is "SYS"
SQL> conn reyn/oracle
Connected.
SQL> show user
USER is "reyn"
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL> set pagesize 1000;
SQL> set linesize 1000;
SQL> select * from v$nls_parameters;
PARAMETER VALUE
---------------------------------------------------------------- ------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACT