Oracleº¯ÊýÖ®substr
Oracle
º¯
ÊýÖ®substr
¹Ø¼ü×Ö: substr
substrº¯ÊýÓÐÈý¸ö²ÎÊý£¬ÔÊÐíÄ㽫Ŀ±ê×Ö·û´®µÄÒ»²¿·ÝÊä³ö£¬
µÚÒ»¸ö²ÎÊýΪĿ±ê×Ö·û´®£¬
µÚ¶þ¸ö×Ö·û´®Êǽ«ÒªÊä³öµÄ×Ó´®µÄÆðµã£¬
µÚÈý¸ö²ÎÊýÊǽ«ÒªÊä³öµÄ×Ó´®µÄ³¤¶È¡£
Àý×Ó1£º
substr('ABCDEFG', 2, 3) = 'BCD'
Èç¹ûµÚ¶þ¸ö²ÎÊýΪ¸ºÊý£¬ÄÇô½«»á´ÓÔ´´®µÄβ²¿¿ªÊ¼ÏòÇ°¶¨Î»ÖÁ¸ºÊýµÄ¾ø¶ÔÖµµÄλÖá£
Àý×Ó2£º
substr('ABCDEFG', -2) = 'FG'
substr('ABCDEFG', -4) = 'DEFG'
Ïà¹ØÎĵµ£º
Oracle
SQL
µÄÓÅ»¯¹æ
Ôò£º
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ
ÓÃINд³öÀ´µÄSQL
µÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬µ«ÊÇÓÃINµÄSQL
ÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓORACLE
Ö´
ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQL
Óë²»ÓÃINµÄSQL
ÓÐ
ÒÔÏÂÇø±ð£º
......
1£©´ÓʹÓÃÉÏÀ´Ëµ£¬oci±ØÐëÔÚ¿Í»§»úÉÏ°²×°oracle¿Í»§¶Ë»ò²ÅÄÜÁ¬½Ó£¬¶øthin¾Í²»ÐèÒª£¬Òò´Ë´ÓʹÓÃÉÏÀ´½²thin»¹ÊǸü¼Ó·½±ã£¬ÕâÒ²ÊÇthin±È½Ï³£¼ûµÄÔÒò¡£
2£©ÔÀíÉÏÀ´¿´£¬thinÊÇ´¿javaʵÏÖtcp/ipµÄc/sͨѶ£»¶øoci·½Ê½,¿Í»§¶Ëͨ¹ýnative java methodµ÷ÓÃc library·ÃÎÊ·þÎñ¶Ë£¬¶øÕâ¸öc library¾ÍÊÇoci(oracle called interface ......
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......
UpSert¹¦ÄÜ£º
MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
WHEN NOT MATCHED THEN <insert_clause>;
MultiTable Inserts¹¦ÄÜ£º
Multitable inserts allow a single INSERT INTO .. SELECT statement to ......
Oracle JDeveloper 10g Release Download
Oracle JDeveloper 10g (version 9.0.5.1, build 1605) for Windows NT/2000/X, Linux, Solaris, and HP-UX.
http://download.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-east.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-west ......