-
col id heading 編號; col username heading 用戶名; col salary heading 工資; select * from users; select username, salary from users;查看全部
-
create 【TEMPRORARY】 tablespace tablespace_name tempfile|datafile 'xxx.dbf/ size 10m desc dba_date_files select file_name from dba_data_files where tabspace_name='TEST1_TABLESPACES':查看全部
-
example列子 temp 臨時表空間 user 用戶數據庫對象 dba_tablespaces connect scott/tiger oracle select 用；結尾 dba_tablespaces 正常只有temp是臨時表空間 temporary_tablespace 是臨時表空間 alter user username default temporary 設置臨時表空間 alter user system default tablespace system 更改默認表空間查看全部
-
COL USERNAME HEADING 用戶名； COL username format a10; COL salary format 9999.9; COL salary format 999.9; COL salary format $9999.9; COL salary CLEAR;查看全部
-
ALTER TABLE table_name RENAME CONSTRAINT ck_salary TO ck_salary_new; desc user_constraints SELECT constraint_name,constraint_type,status FROM user_constraints WHERE table_name='USERINFO'; ALTER TABLE userinfo_f4 DISABLE CONSTRAINT constraint_name; ALTER TABLE userinfo_f4 DROP CONSTRAINT constraint_name; ALTER TABLE userinfo_f DROP PRIMARY KEY;查看全部
-
ALTER TABLE userinfo_c3 DROP CONSTRAINT ck_salary_new;查看全部
-
CREATE TABLE userinfo_c3 (id varchar2(10) primary key,username varchar2(20),salary number(5,0)); ALTER TABLE userinfo_c3 ADD CONSTRAINT ck_salary_new CHECK(salary>0);查看全部
-
CREATE TABLE userinfo_c(id varchar2(10) primary key,username varchar2(20),salary number(5,0) CHECK(salary>0)); INSERT INTO userinfo_c values(1,'aaa',-50); CREATE TABLE userinfo_c2(id varchar2(10) primary key, username varchar2(20),salary number(5,0),constraint ck_salary check(salary>0));查看全部
-
ALTER TABLE userinfo_u2 DROP CONSTRAINT un_username_new;查看全部
-
CREATE TABLE userinfo_u2 (id varchar2(10) primary key,username varchar2(20)); ALTER TABLE userinfo_u2 ADD CONSTRAINT un_username_new UNIQUE(username);查看全部
-
create table userinfo_u(id varchar2(10) primary key,username varchar2(20) unique,userpwd varchar2(20)); create table userinfo_u1(id varchar2(10) primary key,username varchar2(20),constraint un_username unique(username));查看全部
-
select constraint_name,constraint_type,status from user_constraints where table_name='USERINFO_F4'; alter table userinfo_f4 disable constraint fk_typeid_alter; select constraint_name, constraint_type,status from user_constraints where table_name='USERINFO_F4'; alter table userinfo_f4 drop constraint fk_typeid_alter;查看全部
-
create table userinfo_f4(id varchar2(10) primary key,username varchar2(20),typeid_new varchar2(10)); alter table userinfo_f4 add constraint fk_typeid_alter foreign key(typeid_new) references typeinfo(typeid); alter table userinfo_f4 add constraint fk_typeid_alter2 foreign key(typeid_new) references typeinfo(typeid);查看全部
-
create table userinfo_f2(id varchar2(10) primary key,username varchar2(20),typeid_new varchar2(10),constraint fk_typeid_new foreign key(typeid_new) references typeinfo(typeid));查看全部
-
create table typeinfo(typeid varchar2(10) primary key,typename varchar2(20)); create table userinfo_f(id varchar2(10) primary key,username varchar2(20),typeid_new varchar2(10) references typeinfo(typeid)); create table userinfo(id varchar2(10) primary key,username varchar2(20),typeid_new varchar2(10) references typeinfo(typeid)); insert into userinfo_f(id,typeid_new) values(1,2);查看全部
舉報
0/150
提交
取消