Oracle Db10g ±í
±íÊÇOracleÊý¾Ý¿â×î»ù±¾¶ÔÏñÖ®Ò»£¬Ëü´æ´¢Êµ¼ÊÊý¾Ý£¬ÓÉÐкÍÁÐ×é³ÉÒ»¸ö¶þά±í¡£
±íºÍÁеÄÃüÃûÒªÇó:
1.³¤¶È±ØÐëÔÚ30¸ö×Ö½ÚÖ®ÄÚ£¬×î¶Ì³¤¶È²»ÄÜÉÙ1¸ö×Ö½Ú
2.±ØÐëÊÇ×Öĸ¿ªÍ·
3.ÄÜ°üÀ¨×Öĸ¡¢ÊýÖµ¡¢Ï»®Ïß¡¢»õ±Ò·ûºÅ¡£½¨Òé×îºÃ²»ÒªÓûõ±Ò·ûºÅ
4.²»ÄÜʹÓùؼü×Ö»ò±£Áô×Ö¡£ÈçTABLE»òNUMBER
5.ÈôÃû³ÆÔÚË«ÒýºÅÄÚ£¬³ýÁ˳¤¶ÈÒªÔÚ1ÖÁ30¸ö×Ö½ÚÍ⣬»¹ÒªÇó²»ÄÜǶÈëË«ÒýºÅ
6.ÿ¸öÁÐÃû±ØÐëÔÚͬһ¸ö±íÖÐÊÇΨһµÄ
7.ÔÚͬһ·½°¸ÖУ¬ËùÓÐ±í¡¢ÊÓͼ¡¢ÐòÁС¢×¨ÓÃͬÎÒ´Ê¡¢¹ý³Ì¡¢º¯Êý¡¢°ü¡¢ÎﻯÊÓͼºÍÓû§ÒåÀàÐͱØÐëÊÇΨһµÄ¡£
±íºÍÁÐÃû²»Çø·Ö´óСд£¬µ±Äã´´½¨±íʱ£¬Oracle»á×Ô¶¯°ÑÃû×Öת»»³É´óд£¬È»ºó´æ´¢ÔÚÊý¾Ý×ÖµäÖС£µ«ÊÇÒ²¿ÉÒÔСд£¬ÈôÃû³ÆÓÃË«ÒýºÅÀ¨ÆðÀ´µÄ£¬ËüÔò»áÔÚOracleÊý¾Ý×ÖµäÖÐÇø·Ö´óСд¡£
²»¹ý±¾È˽¨Ò飬×îºÃÊDz»ÒªÇø·Ö´óСд£¬ÕâÑù»á¸øÒÔºóʹÓôøÀ´Ò»¶¨µÄÂé·³£¬Ã¿´ÎʹÓÃʱ£¬ÎÒ¶¼ÒªÇø·Ö´óСд£¬Ò»²»Ð¡ÐÄÊǾͻáÌáʾ´íÎó¡£
×¢Òâ:ÔÚOEMÖУ¬Í¨¹ýSQL¿´¼ûµÄÔÚ´´½¨±íµÄSQLÓï¾äÖУ¬±íÃûºÍÁÐ±í¶¼Ê¹ÓÃÁËË«ÒýºÅ£¬µ«ÊDZíÃûºÍÁÐÃû¶¼»á×Ô¶¯×ª»»³É´óд
³£ÓÃÊý¾ÝÀàÐÍ£º
Oracle 9i°üÀ¨Oracle 9iÖ»ÓÐ×Ö·ûÊý¾Ý¿âÀàÐÍ¡¢Êý×ÖÊý¾ÝÀàÐÍ¡¢´ó¶ÔÏñÊý¾ÝÀàÐÍ¡¢ÈÕÆÚʱ¼äÊý¾ÝÀàÐÍ¡¢¶þ½øÐÐÊý¾ÝÀàÐͺÍÐÐÊý¾ÝÀàÐÍ¡£
µ«ÊÇ£¬ÔÚOracle 10iÒÔºóÓв¼¶ûÐÍÊý¾ÝÀàÐÍ¡£
Ìáʾ:
1.ÿ±íÖÐ×î¶àÖ»ÄÜÓÐÒ»ÁÐÊÇLong RowÁС£
2.´ó¶ÔÏñÊý¾ÝÀàÐÍÁв»ÄܳöÏÖÔÚWHERE,GROUP BY»òORDER BYÓï¾äÖС£
ÆäËüÀàÐÍÊý¾Ý²»¶à½²ÁË£¬ÏÂÃæ¾Í̸һ̸ÐÐÊý¾ÝÀàÐÍ
±íÖÐÿÐÐÊý¾ÝÔÚÊý¾Ý¿âÖеĴ洢λÖÿÉÒÔÓÉÆäÐеÄÎïÀíµØÖ·¡¢Âß¼µØÖ·±íʾ¡£ÕâЩµØÖ·´æ´¢ÔÚ±íµÄROWIDαÁÐÖС£µ±Ê¹ÓÃINSERTÓï¾ä²åÈë¼Ç¼ʱ£¬Oracle»á×Ô¶¯Éú³ÉROWID£¬²¢½«ÆäÖ±Óë±íÊý¾ÝÒ»Æð´æ·ÅÔÚ±íÖУ¬ÒÔ±ãΨһ±êʶ±íÖеĸ÷Ìõ¼Ç¼¡£OracleÌṩ¶þÖÖÊý¾ÝÀàÐÍ:ROWIDºÍUROWID¡£
* ROWID:¿ÉÒÔ´æ´¢Ò»ÐеÄÎïÀíµØÖ·¡£Êµ¼ÊµÄROWIDÔÚÆÕͨµÄ±íÖд洢¸÷ÐеĵØÖ·£¨²»°üÀ¨ÓÉË÷Òý×éÖ¯µÄ±í£©£¬»¹¿ÉÒÔÔÚ´Ø±í¡¢±í·ÖÇøºÍ×Ó·ÖÇø¡¢Ë÷Òý·ÖÇøºÍ×Ó·ÖÇøÖд洢¸÷ÐеĵØÖ·¡£Âß¼ROWIDÔÚË÷Òý×éÖ¯µÄ±íÖд洢ÕâЩµØÖ·¡£ÎïÀíROWIDÌṩÁËÒÔ¿ÉÄ
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âÖÐ,ÓÐЩÇé¿öÏÂ,¶ÔÊý¾Ý¼Ç¼ÐèÒª¼Ç¼ÈÕÖ¾,»ò±£´æ²Ù×÷ÀúÊ·µÈÇé¿ö.ÔÚ´ËÎÒÃÇ¿ÉÒÔ½èÖú“Êý¾Ý¿âTrigger”½øÐС£ÏÂÃæÒÔÒ»Àý½øÐÐ˵Ã÷£º
CREATE OR REPLACE TRIGGER aits_auth_group_auth_trga_diu
AFTER update OR DELETE OR INSERT on aits_authority_group_auth
for each row
......
OracleÖÐÐÞ¸ÄSequence·½·¨£º¾ÍÊǸıäËüµÄincrement µÝÔö´óС£¬Ëü¿ÉÒÔΪÕýÒ²¿ÉÒÔΪ¸º¡£ÈçÏ£º
SQL> select seq.nextval from dual;
NEXTVAL
----------
21
SQL> alter sequence seq increment by 79;
ÐòÁÐÒѸü¸Ä¡£
SQL> select seq.nextval from d ......
¹Ø¼ü×Ö: oracleÊý¾Ý¿â
OracleÊý¾Ý¿âÃüÁ
1¡¢sqlplusÆô¶¯·½Ê½£º
DosÏÂÔËÐÐsqlplus Óû§Ãû/ÃÜÂë as sysdba
ÀýÈ磺c:>sqlplus sys/password AS sydba(ϵͳÕÊ»§)
»òÕߣºc:>sqlplus scott/password
2¡¢Óû§Á¬½Ó(Çл»)²Ù×÷£º
sql>conn Scott/password(ĬÈÏΪtiger)
×¢£ºconnÓëconnectʹÓ÷½·¨Ò» ......
ÔÚoracleÖе±ÎÒÃÇн¨Á˶à¸öÊý¾Ý¿âºó£¬ÔٴεǼʱ£¬ÏµÍ³Ä¬ÈϵÄÊÇ×îºó´´½¨µÄÄǸöÊý¾Ý¿â¡£
ÈçºÎÉèÖÃÎÒÃÇ×Ô¼ºÏëÒªµÄĬÈÏÊý¾Ý¿âÄØ£¿
·½·¨ºÜ¼òµ¥£¬ÎÒÃÇÖ»ÐèÔÚÔËÐд°¿ÚÀïÊäÈëregedit£¬¼´¿É½øÈë×¢²á±í±à¼Æ÷£¬ÔÚHKEY_LOCAL_MACHI ......
SAPÓëORACLEµÄÇø±ð·ÖÎö¼°¶Ô±È[ת]
Ä¿Ç°ÔÚERPÒµ½çÖдæÔÚÁ½¸ö¾Þãµ——SAP µÄ ECC ¼° ORACLE µÄ EBS £¬ÕâÁ½¸ö´óÐÍERP½â¾ö·½°¸¼¸ºõÕ¼¾ÝÁËÊÀ½çÉϸ÷¸ö²»Í¬ÐÐÒµµÄ´óÐÍÆóÒµµÄÐÅϢϵͳÊг¡£¬ËùÒÔÕÆÎÕÁ½ÕßÆäÒ»µÄÈ˱ã¿É»ñµÃ´óÐ͹ÜÀíÐÅϢϵͳҵ½çÖеİë±Ú½É½¶ø²»¶¯£¬ÎÞÂÛÄãÊÇ´ÓÊÂSAP»òORACLE £¬Á˽âÁ½ÕßµÄÇø±ðÊǷdz£ÓбØÒª ......