iteye_12263的博客

工具栏(Tools)—>生成数据库(Generate Database)—>常规 Generate name in empty comment 勾选

database(数据库)->edit current DBMS->general->script->sql->CaseSensitvityUsingQuote 下面的value选中No

现象：使用plsql/developer工具导出数据时出现错误,具体示例如下: EXP-00056: 遇到 ORACLE 错误 6550 ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 15:...

oracle to_date,to_char,to_number 用法 24 小时的形式显示出来要用 HH24 select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual; select to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mi:ss') from dual; ...

查询表字段明细 select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE from all_tab_columns where table_name='tablename' 字段注释 select * from user_col_comments; 表注释 select ...

select tab.TABLE_NAME, --表名 tab.COLUMN_NAME, --字段名 tab.DATA_TYPE, --字段类型 tab.DATA_LENGTH, --字段长度 col.comments, --字段注释 comm.c...