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

ѧϰoracle sql loader µÄʹÓÃ

Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
 ±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµã£¬±ÈÈçÔÚ²»Í¬°æ±¾Êý¾Ý¿âÖ®¼äµÄµ¼³ö¡¢µ¼ÈëµÄ¹ý³ÌÖ®ÖУ¬×Ü»á³öÏÖÕâÑù»òÕßÄÇÑùµÄÎÊÌ⣬Õâ¸öÒ²ÐíÊÇoracle¹«Ë¾×Ô¼º²úÆ·µÄ¼æÈÝÐÔµÄÎÊÌâ°É¡£
 sql loader ¹¤¾ßȴûÓÐÕâ·½ÃæµÄÎÊÌ⣬Ëü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾Ý¾ÍÓеãÂé·³ÁË¡£
 
¶þ£ºsql loader µÄ°ïÖú
c:\>sqlldr
sql*loader: release 9.2.0.1.0 - production on ÐÇÆÚÁù 10ÔÂ 9 14:48:12 2004
copyright (c) 1982, 2002, oracle corporation.  all rights reserved.
Ó÷¨: sqlldr keyword=value [,keyword=value,...]
ÓÐЧµÄ¹Ø¼ü×Ö:
    userid -- oracle username/password
   control -- control file name
       log -- log file name
       bad -- bad file name
      data -- data file name
   discard -- discard file name
discardmax -- number of discards to allow        (È«²¿Ä¬ÈÏ)
      skip -- number of logical records to skip  (ĬÈÏ0)
      load -- number of logical records to load  (È«²¿Ä¬ÈÏ)
    errors -- number of errors to allow          (ĬÈÏ50)
      rows -- number of rows in conventional path bind array or between direct p
ath data saves
£¨Ä¬ÈÏ: ³£¹æÂ·¾¶ 64, ËùÓÐÖ±½Ó·¾¶£©
  bindsize -- size of conventional path bind array in bytes(ĬÈÏ256000)
    silent -- suppress messages during run (header,feedback,errors,discards,part
itions)
    direct -- use direct p


Ïà¹ØÎĵµ£º

SQL ×óÍâÁ¬½Ó£¬ÓÒÍâÁ¬½Ó£¬È«Á¬½Ó£¬ÄÚÁ¬½Ó

 Áª½ÓÌõ¼þ¿ÉÔÚ   from   »ò   WHERE   ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ   from   ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE   ºÍ   HAVING   ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£   
   
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ      ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......

ʹÓÃOracleµÄDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä

 ÔÚijЩ³¡ºÏÏ£¬´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÀïµÄSQLÓï¾äÐèÒª¶¯Ì¬Éú³É¡£OracleµÄDBMS_SQL°ü¿ÉÒÔÓÃÀ´Ö´Ðж¯Ì¬SQLÓï¾ä¡£±¾ÎÄͨ¹ýÒ»¸ö¼òµ¥µÄÀý×ÓÀ´Õ¹Ê¾ÈçºÎÀûÓÃDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä£º
DECLARE
       v_cursor NUMBER;
       v_stat NUMBER;
  & ......

SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3

General Overview
FeatureSQL Server 2008 (RC0)MySQL 5.1/6PostgreSQL 8.3/PostGIS 1.3/1.4
OS
Windows XP, Windows Vista, Windows 2003, Windows 2008
Windows XP, Windows Vista, (haven't tested on 2008), Linux, Unix, Mac
Windows 2000+ (including Vista and 2003, haven't tested on 2008), Linux, Unix, Ma ......

Sql serverÖÐʱ¼äº¯ÊýÓ÷¨Ïê½â

SQLÖеÄʱ¼äº¯Êý·Ç³£ÓÐÓã¬ÌرðÊÇÔÚÎÒÃǽøÐгõʼ¸³Öµ¡¢¸´ÔÓ²éѯµÄʱºò£¬¾ÍÏÔµÃÌØ±ð·½±ã¡£
1¡¢»ñµÃϵͳµ±Ç°Ê±¼ä
select getdate() 
2¡¢DateName ( datepart , date )·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£
--½ñÌìÊÇ2009-2-24--ÐÇÆÚ¶þ
SELECT DATENAME(year, getdate()) AS 'Year&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ