數(shù)據(jù)字典總結(jié)(oracle10g)-在線瀏覽
2025-08-04 06:32本頁面
【正文】 _tab_privs。8 To see current database name 查看當(dāng)前數(shù)據(jù)庫(kù)名SQLselect name from v$database。for more details查看當(dāng)前用戶下的文件名,表空間,字節(jié)數(shù),用戶塊的信息SQLselect file_name,tablespace_name,bytes,user_blocks from dba_data_files。c:/oracle/product/39。11 drop a tablespace刪除一個(gè)半空間SQLdrop tablespace MyFirstSpace including contents。13 resize tablespace重新設(shè)置表空間的大小SQLalter database datafile 39。 resize 500M。for all users查看所有用戶下的所有的表SQLselect table_name from all_tables。16 update character set to needed修改數(shù)據(jù)庫(kù)字符集的例子SQLalter database character set ZHS16GBK。ddmonyyyy hh:mi:ss39。21 domain integrity operationSQLalter table tbname add constraint pk_tbname primary key(n1)22 referential integrity operation添加外鍵的語法SQLalter table emp add constraint constraint fk_tbname foreign key(n1)references tbname(n1) initially deferred deferrable23 Check operation添加check的語法SQLalter table emp add constraint ck_emp_agender check(agender=39。or agender=39。)24 Create a table through a subquery通過子查詢創(chuàng)建表的語法SQLcreate table emp_41 as select id, last_name, userid, sta
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1