Oracle±£Áô×Ö
²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬ÈçºÎ±ÜÃâÕâ¸öÎÊÌâÄØ£¿
ÓÐЩÏîÄ¿×éÓÃÃüÃû¹æÔòÀ´±ÜÃâÕâ¸öÎÊÌâ¡£ÈçÓÃT_USER±íʾÓû§£¬C_ID±íʾid¡£
ÓÐЩÓÃÏîÄ¿Ãû×÷ǰ׺£¬È磺JBMP_PROCESS£¬ÕâÑù×ö¶ÔÓÚÒ»¸öÊý¾Ý¿âÖдæ·Å²»Í¬Ó¦ÓóÌÐòµÄÊÇÓкô¦µÄ¡£ÎªÏîÄ¿½¨Á¢Ò»¸ö2-4¸ö×ÖĸµÄ¼ò³Æ¾ÍºÜÓбØÒªÁË¡£ÕâÊÇÎÒÍÆ¼öµÄ·½·¨¡£
Ïà¹ØÎĵµ£º
ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_N ......
ASM:Automatic Storage Management, ÊÇOracle Ö÷ÍÆµÄÒ»ÖÖÃæÏòOracleµÄ´æ´¢½â¾ö·½°¸£¬ ASM ºÍ RDBMS ·Ç³£ÏàËÆ£¬ASM Ò²ÊÇÓÉʵÀýºÍÎļþ×é³É£¬ Ò²¿ÉÒÔͨ¹ýsqlplus ¹¤¾ßÀ´Î¬»¤¡£
1. ASM ʵÀýÓÉSGA ºÍºǫ́½ø³Ì×é³É¡£
1.1 SGA  ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ......
ȨÏÞ¹ÜÀí
Oracle 9i
3¸öĬÈÏÓû§
sys(³¬¼¶¹ÜÀíÔ±) ĬÈÏÃÜÂ룺change_on_install
system£¨ÆÕͨ¹ÜÀíÔ±£©
ĬÈÏÃÜÂ룺manager
scott£¨ÆÕͨÓû§£© ĬÈÏÃÜÂ룺tiger
Oracle 10g
sys£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
system£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
scott(ĬÈÏËø¶¨£¬ÏëÓõýâËø)
Æô¶¯Windo ......
°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍÆ¼öʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃæ£¨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉϰ²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«ÐÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......