-
编辑 删除
修改表结构后一定会另依赖对象失效吗？
修改表结构后一定会另依赖对象失效吗？create table wxh_tbd as select * from dba_objects;Table created. create or replace PROCEDURE wxh_test_tbd 2 is ...
-
编辑 删除
FLASHBACK的多版本查询
col a for 99999999999999999999select timestamp_to_scn(to_timestamp('2011-01-24 16:17:38','yyyy-mm-dd hh24:mi:ss')) a from dual; ...
-
编辑 删除
连接条件字符类型不一样。
drop table wxh_tbd1;Table dropped.rop table wxh_tbd2;Table dropped.create table wxh_tbd1 (id number ,name varchar2(2000));Table created.create table wxh_tbd2 (id varchar2(1000) ,name varchar2(200...
-
编辑 删除
ORA-00904，修改字段长度报错
alter table ALI_TPCRM_ACCESS_AREA modify SCOPE VARCHAR2(4000);alter table ALI_TPCRM_ACCESS_AREA modify SCOPE VARCHAR2(4000)  ...
-
编辑 删除
ORA-01442，又遭遇疑难杂症
select nullable from user_tab_columns where table_name='WORKDAYTYPE';NU--YYYYYYY7 rows selected.alter table WORKDAYTYPE modify CREATOR NOT NULL;alter table WORKDAYTYPE modify ...
