oracle»ù´¡ÖªÊ¶1
1¡¢Ä¬ÈÏÊÂÀý£º
Óû§Ãû£ºscottÃÜÂ룺tiger Ö÷»ú×Ö·û´®£º±¾»ú¿ÉÒÔΪ¿Õ
2¡¢Æô¶¯·½·¨£º
ÔËÐУºsqlplus scott/tiger@lhd
3¡¢SQLPLUS»ù±¾ÃüÁ
Desc£ºÏÔʾ±í¡¢ÊÓͼ½á¹¹ desc ±íÃû£¬ÊÓͼ
List£ºÁгöSQL»º³åÇøÇøÖеÄÒ»Ðлò¶àÐÐÃüÁîÓï¾ä
Exit£ºÍ˳ö
4¡¢³£ÓõÄÊý¾Ý×Öµä(ÈýÖÖǰ׺£ºUSER£¬ALL£¬DBA)
USER_TABLES£ºÓû§ËùÓбíÐÅÏ¢
USER_VIEWS£ºÓû§ËùÓÐÊÓͼ
USER_CONSTRAINTS£º¼Ç¼´´½¨±í½á¹¹µÄÔ¼Êø
USER_DEPENDENCIES£º¼Ç¼Óû§±íÖ®¼äµÄ¹Øϵ¼°×Ô¶¨ÒåÀàÐÍÖ®¼äµÄ¹Øϵ
USER_TAB_COLUMNS£ºÓйظ÷±íµÄÁÐÐÅÏ¢
USER_TRIGGERS£ºÓû§´¥·¢Æ÷µÄÐÅÏ¢
5¡¢ÏÔʾ¿ØÖÆ£º
set linesize 500
set pagesize 100
"/"Óë"run"Ö´ÐиղÅÖ´ÐеÄÓï¾ä¡¢Ò²¿ÉÒÔÓÓr”
"·ÖºÅ"´ú±íÓï¾ä½áÊøÌá½»µ½ºǫִ́ÐÐ
6¡¢ÉèÖÃʱ¼äÊä³ö¸ñʽ£º
alter session set NLS_date_format='YYYY-MM-DD'
7¡¢ÇåÆÁ:clear screen
8¡¢²éѯijÓû§ÏµıíÃû£º
SELECT * from dba_tables WHERE owner='HSA6'
9¡¢²éѯÓм¸¸öÓû§
select * from dba_users
10¡¢µ¼ÈëDMP¸ñʽÊý¾Ý£º
1).н¨³É±í¿Õ¼äºÍÓû§Ãû
2).imp system/123456@orcl file='d:\data\test.dmp' log='d:\data\test.log' fromuser='hsa6' touser='hsa7'
fromuserÊÇÖ¸dmp¸ñʽ°üÖеÄij±í¿Õ¼äµÄÓû§£¬TOUSER ÊÇÖ¸Òªµ¼ÈëµÄ±í¿Õ¼äµÄÓû§
11¡¢¸ü¸Äijֵ£º
sqlserver:
update ca_company set dwmc=substring(dwmc,1,2)+'B'+substring(dwmc,4,10)
oracle:
UPDATE ca_company SET c4='b'|| substr(c4,2,LENGTH(c4)) WHERE c4 LIKE 'a%'
²éѯϵͳËùÓÐÓû§£ºselect distince owner from dba_segments;
²é¿´Óë¶àÉÙ¸ö±í¿Õ¼ä£ºselect tablespace_name from dba_tablespaces;
²é¿´±í¿Õ¼äÓжàÉÙ¸ö±í£ºselect tablespace_name,bytes/1024/1024 file_size_mb file_name from dba_data_files;
1.Á¬½Ó£ºsqlplus scott/tiger@oracle »òÕß sqlplus / as sysdba;
2.Í˳ö£ºquit»òexit;
3.²é¿´µ±Ç°Óû§£ºshow user;
4.ÖØÐÂÁ¬½Ó£º/ as sysdba;
5.´´½¨±í¿Õ¼ä£ºcreate tablespace sales datafile 'd:/hello.dbf' size 4m;
6.²é¿´µ±Ç°Ê±¼ä£ºselect sysdata from daul(ÓÐselect ±ØÓÐfrom)£»
7.²é¿´±í½á¹¹£ºdesc dual (Ðé±í)£»
8.´´½¨Óû§ÃûºÍÃÜÂ룺create user rose identified by rose;
9.ÊÚȨ( ʹÓÃoracleµÄ×ÊÔ´): grant dba,connect,resource to rose;
10.Óû§µÇ½
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âÊÇÒ»ÖÖ´óÐ͹ØϵÐ͵ÄÊý¾Ý¿â£¬ÎÒÃÇÖªµÀµ±Ê¹ÓÃÒ»¸öÊý¾Ý¿âʱ£¬½ö½öÄܹ»¿ØÖÆÄÄЩÈË¿ÉÒÔ·ÃÎÊÊý¾Ý¿â£¬ÄÄЩÈ˲»ÄÜ·ÃÎÊÊý¾Ý¿âÊÇÎÞ·¨Âú×ãÊý¾Ý¿â·ÃÎÊ¿ØÖƵġ£DBAÐèҪͨ¹ýÒ»ÖÖ»úÖÆÀ´ÏÞÖÆÓû§¿ÉÒÔ×öʲô£¬²»ÄÜ×öʲô£¬ÕâÔÚOracleÖпÉÒÔͨ¹ýΪÓû§ÉèÖÃȨÏÞÀ´ÊµÏÖ¡£È¨ÏÞ¾ÍÊÇÓû§¿ÉÒÔÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£¶ø½ÇÉ«ÊÇΪÁË·½±ãDBA¹Ü ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà ÕâÑù£º
SELECT tmp#_seq.NEXTVAL
INTO id_temp
from DUAL; È»ºó¿ÉÒ ......
ÉÏ節學習開µÚÒ»個Form£¬這個節ÔÚÌí¼ÓÒ»個彈³öÏÂÀ¿ò
µÚÒ»²½£ºÌí¼Ó記錄組
1.1 選ÖÐRecord Groups
1.2 單擊Create
1.3 輸Èë²é詢SQL
1.4 單擊OK
1.5 ÐÞ¸Ä ......
Ò».B-TreeË÷Òý(b-tree index)
1. Ñ¡ÏîÔñË÷Òý×ֶεÄÔÔò:
ÔÚWHERE×Ó¾äÖÐ×îƵ·±Ê¹ÓõÄ×Ö¶Î
Áª½ÓÓï¾äÖеÄÁª½Ó×Ö¶Î
Ñ¡Ôñ¸ßÑ¡ÔñÐÔµÄ×Ö¶Î(Èç¹ûºÜÉÙµÄ×Ö¶ÎÓµÓÐÏàֵͬ,¼´Óкܶà¶ÀÌØÖµ,ÔòÑ¡ÔñÐԺܺÃ)
ORACLEÔÚUNIQUEºÍÖ÷¼ü×Ö¶ÎÉÏ×Ô¶¯½¨Á¢Ë÷Òý
ÔÚÑ¡ÔñÐԺܲîµÄ×Ö¶ÎÉϽ¨Ë÷ÒýÖ»ÓÐÔÚÕâ¸ö×Ö¶ÎµÄ ......