ÏëʵÏÖÒ»¸ö´¥·¢Æ÷,ÔÚ±íLGT_RY_NB²åÈëÒ»ÌõÊý¾Ýǰ£¬ÅжÏÕâÌõÊý¾ÝµÄSFZHÊÇ·ñlike'%111111%' Èç¹ûÊǵϰ£¬°ÑÕâÌõÊý¾Ý²åÈëµ½LGT_RY_NB_BackUp±íÖУ¬È»ºó´ÓLGT_RY_NBÖиù¾ÝZJHMÕâ¸öÖ÷¼üɾ³ýÕâÌõ¼Ç¼£¨»òÕß½ûÖ¹Ö´ÐвåÈë²Ù×÷£©£¬·ñÔòµÄ»°²»×öÈκβÙ×÷¡£
¾ÍÊÇÅжÏÒ»ÌõÊý¾ÝµÄSFZH×Ö¶ÎÊÇ·ñlike 111111 Êǵϰ²»ÈÃÆä²åÈë ......
rt
¾«Í¨ORACLE 10G PL/SQL ±à³Ì
9i10g±à³ÌÒÕÊõ
»¹ÓбðµÄÂð
ORACLE 9i&10g±à³ÌÒÕÊõ
¡¶Oracle Database 10g PL/SQL³ÌÐòÉè¼Æ¡·
Oracle Database 10g PL/SQL Programming
ÃÀ£ºScott Urman/Ron Hardman/Michael McLaughlin Öø
Åíçõ Òë¡£
Ç廪´óѧ³ö°æÉç¡£¶¨¼Û85£¬»¹´øÀý×ÓÔ´Âë¹âÅÌ~~~~
¡¶¾« ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
¹þ¹þ ¿ñÀÇÐÖÔÚʲôµØ·½¿´µ½ORACLE½¨ÒéʹÓÃcon ......
±¾È˳õѧoracleÊý¾Ý¿â£¬Ï£Íû¸÷λÓоÑéµÄ´óÏÀÃǽéÉÜһϸÃÈçºÎȥѧϰ²ÅÄÜÈ¡µÃ¸üºÃµÄЧ¹û¡£
ÄÜ·ñÍÆ¼öÒ»¿î½²µÃ±È½ÏºÃÓÖÄܹ»ÏÂÔØµ½µÄÊÓÆµ½Ì³Ìѽ
Èç¹ûʵÔÚûÓÐÊÓÆµ½Ì³Ì£¬µç×ÓÊéµÈÒ²¿ÉÒÔ£¬Ö÷ÒªÊǽ²µÄ±È½ÏºÃµÄ¡£
ллÁË¡£
http://www.verycd.com/search/folders/oracle
Ëæ±ãÏ¡£¡£¡£
¸öÈËÍÆ¼ö£º¡¶MLDNħÀ ......
Á¬½Ó·½°¸£º
public class Conn {
public static String DRIVER="oracle.jdbc.driver.OracleDriver";
public static String URL="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
public static String NAME="system";
public static String PWD="ly";
publi ......
OracleµÄÈý²ã½á¹¹µ½µ×ÊÇʲôÒâ˼ѽ£¿
×¢Ò⣬ÎÒÎʵÄÊÇOracleµÄÈý²ã½á¹¹£¬²»ÊÇÆóÒµ¼¶Ó¦ÓóÌÐò¿ª·¢ÀïµÄÈý²ã½á¹¹¡£
ËÄÜÓüòµ¥Ò×¶®µÄÓïÑÔÃèÊöһϣ¿Ð»Ð»ÁËÏÈ£¡
Â¥Ö÷´ÓÄÄÀï¿´µ½OracleµÄÈý²ã½á¹¹µÄ°¡¡£¡£¡£¡£
Ö»ÖªµÀoracleÓÐÈý²ãÈÏÖ¤£ºOCA¡¢OCP¡¢OCM
Õ¼×ù¿´¸ßÊÖ·¢ÑÔ¡£
²¹³äһϣ¬ÎÒÖ¸µÄÊÇOracle9iÀïµÄÈý²ã½á¹¹¡£
ÄѵÀ ......