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

ORACLE ÓαêµÄʹÓÃ

declare cursor myCursor is select * from ±íÃû;
myRow myCursor%rowtype;
begin
open myCursor;
loop
fetch myCursor into myRow;
exit when myCursor%notfound;
--ÒªÖ´ÐеÄSQLÓï¾ä
end loop;
end;


Ïà¹ØÎĵµ£º

[Oracle]TNSListener ÎÞ·¨Æô¶¯ÎÊÌâ

OracleµÄ¼àÌýÆ÷TNSListenerÓÐʱÎÞ·¨Æô¶¯£¬ÓÐʱÆô¶¯ÍêÒÔºó»á×Ô¶¯¹Ø±Õ£¬ÕâÀï¸ø³öÒ»ÖÖ¿ÉÄܵÄÔ­Òò¾ÍÊǼÆËã»úÃû³ÆµÄÐ޸쬽â¾öµÄ·½·¨ÊÇ´ò¿ª<ORALE_HOME>\network\admin\listener.ora£¬ÐÞ¸Ä(HOST = [compute_name])(PORT = 1521)£¬ÖØÐÂÐ޸ľͿÉÒÔÕý³£Æô¶¯¡££¨×¢ÒâOracleÆóÒµ¹ÜÀíÆ÷ÖÐĬÈϵÄÊý¾Ý¿âÁ¬½ÓÒ²ÐèÒª¸Ä±ä£¬·ñÔòÈÔÈ»»á ......

oracle±Ê¼Ç1


      ´´½¨ÐµÄÓû§Ê±£¬ÒªÖ¸¶¨default   tablespace£¬·ñÔòËü»á°Ñsystem±í¿Õ¼äµ±³É×Ô¼ºµÄȱʡ±í¿Õ¼ä¡£ÕâÑù×öÊDz»ÌᳫµÄ¡£¹À¼ÆÔ­À´´´½¨Ä³¸öÓû§µÄʱºòûÓÐÖ¸¶¨È±Ê¡±í¿Õ¼ä£¬¶øÏÖÔÚËüʹÓÃϵͳ±í¿Õ¼äµÄȨÏÞ±»DBA¸øÊÕ»ØÁË¡£  
  ÏÈÓõļòµ¥µÄ°ì·¨ÊÔÊÔ£¬Ò»°ãȱʡµÄORACLE°²× ......

Oracle SQLÓëANSI SQLÇø±ð


Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......

Oracle SQL Loader

Ò»£ºSQL Loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµ ......

´ÓOracle¡¢SQLServerÖÐÈ¡µÃ×¢ÊÍ

¸ù¾Ý±í½á¹¹Éú³ÉJavaÎļþµÄ¹¤¾ß£¬ÔÚÈ¡µÃ±íµÄ×Ö¶ÎʱÈçºÎÈ¡µÃ±íµÄ¸÷ÖÖÐÅÏ¢ºÍ×¢ÊÍ£¬¾­¶à·½ËÑѰÕÒµ½ÈçÏÂ×ÊÁϱ¸Ó㺠oracle£º
        user_tab_comments;±í×¢ÊÍ
        user_col_comments;±í×Ö¶Î×¢ÊÍ
        Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ