³£ÓõÄORACLE PLSQL¹ÜÀíÃüÁî
³£ÓõÄORACLE PL/SQL¹ÜÀíÃüÁî
ÊìϤORACLE¹ÜÀíµÄÒ»¶¨¶ÔÕâЩÃüÁî²»»áÄ°Éú£¬²»¹ý¶ÔÓÚÎÒÕâ¸ö¸Õ½Ó´¥ORACLE¹ÜÀíµÄÀ´Ëµ£¬»¹ÊÇÓбØÒª×öϼǼ£¬ÒÔ±ãËæʱ²é¿´¡£
Ò» µÇ¼SQLPLUS
sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
Èç:Óû§sys(ÃÜÂëΪ123)ÒÔsysdbaµÄ½ÇÉ«µÇ¼Êý¾Ý¿âORACL£¬ÎÒÃÇ¿ÉÒÔÊäÈ룺sqlplus sys/123@oracl as sysdba;
ÕâÖֵǼ·½Ê½»áÖ±½Ó±©Â¶ÃÜÂ룬Èç¹ûÏëÒþ²ØÃÜÂ룬¿ÉÒÔÔÚ´ËÊ¡ÂÔÃÜÂëµÄÊäÈ룬È磺sqlplus sys@oracl as sysdba;»Ø³µÒÔºóORACLE»á¸ø³öÊäÈëÃÜÂëµÄÌáʾ·û¡£
µÇ¼ÒÔºóÈç¹ûÏëÇл»ÆäËûµÄÓû§£¬¿ÉÒÔÖ±½ÓʹÓÃconnect ÃüÁî,È磺connect user2/password@oracl as sysdba,ͬÉÏÒ»Ñù£¬¿ÉÒÔ½«ÃÜÂë·Ö¿ªÊäÈë¡£
¶þ Í˳öSQLPLUS
quit£»
Èý ´´½¨Óû§
create userÓû§Ãûidentified byÃÜÂë;
È磺´´½¨Óû§CKSP£¬ÃÜÂëΪ123: create user cksp identified by 123;
ËÄ ¸øÓû§·ÖÅä½ÇÉ«»òȨÏÞ
grant *** to ***;
È磺¸ø¸Õ²ÅµÄÓû§·ÖÅä½ÇÉ«DBA:grant dba to cksp;
·ÖÅäcreate tableȨÏÞ£ºgrant
Îå ɾ³ýÓû§
drop userÓû§[cascade];
ÆäÖÐcascadeÊÇ¿ÉÑ¡µÄ£¬Èç¹ûÊäÈëÁË£¬Ôò±íʾɾ³ý¸ÃÓû§¼°ËùÓÐÊý¾Ý¡£
È磺ɾ³ýÉÏÃæ´´½¨µÄÓû§CKSP¼°ËûµÄËùÓÐÊý¾Ý£ºdrop user cksp cascade;
Ïà¹ØÎĵµ£º
oracleÊý¾Ý¿âµÄÓŵãÒ»£º
ORACLE7.XÒÔÀ´ÒýÈëÁ˹²ÏíSQLºÍ¶àÏßË÷·þÎñÆ÷Ìåϵ½á¹¹¡£Õâ¼õÉÙÁËORACLEµÄ×ÊÔ´Õ¼Ó㬲¢ÔöÇ¿ÁËORACLEµÄÄÜÁ¦£¬Ê¹Ö®Ôڵ͵µÈíÓ²¼þƽ̨ÉÏÓýÏÉÙµÄ×ÊÔ´¾Í¿ÉÒÔÖ§³Ö¸ü¶àµÄÓû§£¬¶øÔڸߵµÆ½Ì¨ÉÏ¿ÉÒÔÖ§³Ö³É°ÙÉÏǧ¸öÓû§¡£
oracleÊý¾Ý¿âµÄÓŵã¶þ£º
ÌṩÁË»ùÓÚ½ÇÉ«(ROLE)·Ö¹¤µÄ°²È«±£ÃܹÜÀí¡£ÔÚÊý¾Ý¿â¹ÜÀí¹¦ÄÜ ......
LoadBalance ¾ÍÊǰѸºÔØƽ¾ùµÄ·ÖÅäµ½¼¯ÈºÖеĸ÷¸ö½Úµã£¬´Ó¶øÌá¸ßÕûÌåµÄÍÌÍÂÄÜÁ¦¡£ Oracle 10g RAC ÌṩÁËÁ½ÖÖ²»Í¬µÄ·½·¨À´·ÖÉ¢¸ºÔØ£º
1. ͨ¹ýConnection Balancing£¬°´ÕÕijÖÖËã·¨°ÑÓû§·ÖÅäµ½²»Í¬µÄ½Úµã¡£Ò²¿ÉÈÏΪÊÇ´¿¼¼ÊõµÄ·ÖÉ¢¸ºÔØ¡£
2. ͨ¹ýService£¬ÔÚÓ¦ÓòãÉϽøÐзÖÉ¢£¬Ò ......
Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
֮ǰÏîÄ¿ÓÐÓõ½µÄһЩµ¼ÈëºÍµ¼³ö£¬Ê±ÖÁÒѾÃÕûÀíһϣ¬×ö¸ö¼ÇºÅ
µ¼ÈëÎļþ£º
1. ÔÚij·¾¶ÏÂд¿ØÖÆÎļþ e:\testRegionControl.ctl £º
load data
infile e:\region.txt
truncate into table region
fields terminated by X'09'
TRAILING NULLCOLS
(
PPCC_ID&nbs ......