Oracle±£Áô×Ö
²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬ÈçºÎ±ÜÃâÕâ¸öÎÊÌâÄØ£¿
ÓÐЩÏîÄ¿×éÓÃÃüÃû¹æÔòÀ´±ÜÃâÕâ¸öÎÊÌâ¡£ÈçÓÃT_USER±íʾÓû§£¬C_ID±íʾid¡£
ÓÐЩÓÃÏîÄ¿Ãû×÷ǰ׺£¬È磺JBMP_PROCESS£¬ÕâÑù×ö¶ÔÓÚÒ»¸öÊý¾Ý¿âÖдæ·Å²»Í¬Ó¦ÓóÌÐòµÄÊÇÓкô¦µÄ¡£ÎªÏîÄ¿½¨Á¢Ò»¸ö2-4¸ö×ÖĸµÄ¼ò³Æ¾ÍºÜÓбØÒªÁË¡£ÕâÊÇÎÒÍÆ¼öµÄ·½·¨¡£
Ïà¹ØÎĵµ£º
º¯Êý£º
1.ʹÓÃCreate Function Óï¾ä´´½¨
2.Óï
·¨£º
Create or replace Function º¯ÊýÃû[²ÎÊýÁбí]
Return Êý¾ÝÀàÐÍ
IS|AS
¾Ö²¿±äÁ¿
Be ......
×î½üÒ»¸öÏîÄ¿µÄʵʩÐèÒªÓõ½
RedHatAs5.0
²Ù×÷ϵͳϵÄ
Oracle
Ë«»úÈȱ¸ÅäÖã¬ÔÒÔΪÓÐÉ豸³§ÉÌÒÔ¼°¹«Ë¾ÏµÍ³ÍøÂ粿µÄ¼¼ÊõÖ§³Ö£¬Ë«»úÈȱ¸¾ÍÊÇСÒâ˼£¬Ã»Ï뵽ʵʩ¹ý³ÌÖÐÅöµ½ÁËÐí¶àÆæ¹ÖµÄÎÊÌâ¡£¾¹ý¶àÌìµÄ¹¥¹Ø£¬ÖÕÓÚÅäÖóɹ¦ÁË£¬¸Ð¾õÐÄÇéÌØ±ðÇáËÉ¡£¾¹ýÁ½ÖܵÄʵʩ£¬ÎÒÒÔÒ»¸ö
Linux
²ËÄñµÄÉí·Ý£¬³õ²½Á ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ......
°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍÆ¼öʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃæ£¨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉϰ²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«ÐÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......
ÒÔÏÂÊÇOracle JDBC¹Ù·½ÎĵµµÄ˵·¨£º
Ò²¾ÍÊÇËæ±ã·ÒëһϾÍÀí½âÁË¡£
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
Ôڵͼ¶JDK°æ±¾1.2Óë1.3ÖÐʹÓõÄÇý¶¯£¬ËäȻʵ¼ÊÉÏÔÚ1.4£¬1.5ÖÐʹÓô󲿷ÖÇé¿öÒ²ÊÇOKµÄ
classes12_g.jar (2,044,594 bytes) - same as classes12.j ......