Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÓÅ»¯ÎÊÌâ

ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ê¹ÓÃÓαê¶ÔÊý¾Ý½øÐвåÈë²Ù×÷£¬Éæ¼°µ½ºÜ¶à±í£¬ÆäÖÐһЩÊÇÖ÷´Ó±í¹ØÏµ£¬°´Ë³ÐòÏÂÀ´£¬Ö÷±íÉú³ÉÊý¾Ý£¬ÔÙÉú³É×Ó±íµÄ¡£
  ×î½üÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÓеÄÊý¾ÝÁ¿¹ý´ó£¬Ôì³ÉËٶȺÜÂý£¬ÔÚ10¼¸ÍòÌõÒÔÉÏ¡£ÏëÇë½ÌϸßÊÖ£¬ÓÐûÓкõķ½·¨½øÐÐÓÅ»¯£¬Ìá¸ßÏÂËÙ¶È£¡
ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£


Ìù³öSQL¡£

¶¥£¬¹Ø×¢´ËÀàÎÊÌâ¡£~~~~

ÒýÓÃ
ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£


Ìù³öSQL¡£

10Íòʲ»¶à°¡,±í¶à,¹ØÁª¶à,Õâ²ÅÊÇÎÊÌâ

ÒýÓÃ
ÒýÓà 1 Â¥ suiziguo µÄ»Ø¸´:ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£ Ìù³öSQL¡£
10Íòʲ»¶à°¡,±í¶à,¹ØÁª¶à,Õâ²ÅÊÇÎÊÌâ

Êǰ¡£¬¾ÍÊÇÒòΪ²Ù×÷µÄ±í±È½Ï¶à£¬ºÜ¶à±íÓÖÓÐÖ÷´Ó¹ØÏµ£¬ÕâÑùÑ­»·ÏÂÀ´±È½ÏÂý£¡

ÎÊÌâÌ«·ºÁË,Ö»ÄÜ˵10¼¸ÍòÌõÊý¾Ý²»Ëã¶à

Ö÷´Ó±íµÄ¸üÐÂʹÓô¥·¢Æ÷ÊÔÊÔÄØ¡£

Äܲ»Äܲ»ÓÃÑ­»·,ÓÃÅúÀï²åÈë,ÏÈÅúÁ¿²åÈëÖ÷±í,ÔÙÅúÁ¿²åÈë×Ó±í,»òÕßÏñ6¥˵µÄÓô¥·¢Æ÷¿´ÏÂ.

×Ö±íÌ«¶àµÄÎÊÌâ°É

Äã¹ØÐÄϱíÓë±íÖ®¼äµÄ¹ØÁª·½Ê½~ÒªÈÃSQL¾¡Á¿×îÓÅ£¬Èç¹ûËÙ¶È»¹²»ÐУ¬Äã¾ÍÒª¿¼ÊÔÊý¾Ý¿â½á¹¹ÁË·

ºÇºÇ£¬ÎÊÌâÌ«·º·ºÁË

¸øÄãЩÒâ¼û°É£¬¶à¿´¿´ÅúÁ¿²åÈë insert into a select * from b;

ÔÚÓоÍÊÇ×¢Òâ±íÓë±íÖ®¼äµÄ¹ØÁªÁË¡£

Äã¿ÉÒ԰ɾßÌåµÄ±í½á¹¹ºÍÐèÇóÄóöÀ´£¬ÎÒÃÇ´ó¼Ò¸øÄã·ÖÎöһϰ¡


FOR rbl_survey_bound in cbl_survey_bound(aFlowSN(i)) loop

  --»ñÈ¡¾É¿±²âID
  oldSB_ID := rbl_sur


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ