最新回答 / qq_不说话的公仓鼠_0
你所说的时间是主键创建的时间还是指其他的时间字段？数据字典user_constraints中 有一个字段last_change字段 是最后修改时间的字段 你可以按照这个排一下序。
2016-05-16
select file_name from dba_temp_files where tablespace_name='TEMPSTUDENT_TABLESPACE';未选定行是啥意思？
2016-05-16
select constraint_name from user_constraints where table_name='USERINFO';
alter table userinfo
rename constraint pk_id to new_pk_id;
select constraint_name,status from user_constraints where table_name='USERINFO';
alter table userinfo
drop constraint new_pk_id;
alter table userinfo
rename constraint pk_id to new_pk_id;
select constraint_name,status from user_constraints where table_name='USERINFO';
alter table userinfo
drop constraint new_pk_id;
2016-05-10
create table userinfo_p1
(id number(6,0),
username varchar2(20),
userpwd varchar2(20),
constraint pk_id_username primary key(id,username));
select constraint_name from user_constraints where table_name='USERINFO_P1';
select constraint_name from user_constraints where table_name='USERINFO_P';
(id number(6,0),
username varchar2(20),
userpwd varchar2(20),
constraint pk_id_username primary key(id,username));
select constraint_name from user_constraints where table_name='USERINFO_P1';
select constraint_name from user_constraints where table_name='USERINFO_P';
2016-05-10