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

Oracle SQL DeveloperÓëPL/SQL Developer±È½Ï¡¾×ª¡¿

¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
      ֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆÆ½â°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»ÔÚÓÐÌõ¼þµÄÇé¿öϱÈSQL*PLUS¸ü·½±ãµÄ¹¤¾ßȴʵÔÚ²»ÊÇÒ»¼þ¼òµ¥µÄÊÂÇ飬ÒÔǰÆÚ´ýtora±»QuestÊÕ¹ºÒÔºó»áÓг¤×ã·¢Õ¹£¬¿Éϧ£¬²¢Ã»Óп´µ½×îÖյĽá¹û¡£
Ö®Ç°Ôø¾­Ëµ¹ý£¬PL/SQL Developer¶ÔÓÚÎÒ×îÄÑÒÔ¸îÉáµÄÊÇcompletion insight¹¦ÄÜ£¬µ±Äã¼Ç²»×¡±í¡¢ÐÔÄÜÊÓͼ»òÕß´æ´¢¹ý³Ì¡¢º¯ÊýµÄÈ«Ãû£¬PL/SQL Developer½«»áÔÚÄãÊäÈëÁ˼¸¸ö×Öĸ֮ºó×Ô¶¯Ìáʾ¡£TOAD·¢Õ¹ÁËÄÇô¶àÄ꣬ȴһֱûÓÐÌṩÏàÀàËÆµÄ¹¦ÄÜ¡£
µ«ÊÇÏÖÔÚÍêÈ«Ãâ·ÑµÄÌæ´ú²úÆ·³öÏÖÁË£¬Õâ¾ÍÊÇOracle SQL Developer£¬Oracle¹Ù·½³öÆ·µÄ¿ª·¢¹¤¾ß£¬µ±È»Õâ¸ö¹¤¾ß²¢²»ÊǽñÄê²ÅÍÆ³öµÄ£¬ÏÖÔÚ×îа汾ÒѾ­ÊÇ1.5.1.54.40£¬µ«ÊÇ£¬×îÔçµÄ1.0°æ±¾²¢²»ÊÇÄÇôºÃÓ㬶øÏÖÔÚ£¬ÎÒ¿ÉÒÔÖ£ÖØµØÍƼöËüÁË¡£
Çë×¢Ò⣬Õâ¸ö¹¤¾ßÊÇÍêÈ«Ãâ·ÑµÄ£¬¿ÉÒÔͨ¹ýÕâ¸öÁ´½ÓÏÂÔØ¡£
ÒÔÒ»¸öÆÕͨʹÓÃÕߣ¨ÉõÖÁ˵ÊÇÒ»¸ö²¢²»ÊÇ×ÅÖØÔÚ¿ª·¢ÉϵÄÊý¾Ý¿â¹ÜÀíÔ±£©µÄÉí·Ý±È½ÏÒ»ÏÂOracle SQL DeveloperºÍPL/SQL Developer¡£
1. ¸ñʽ»¯µÄ½á¹ûÊä³ö¡£
ÕâÒ»µãÈκÎÒ»¸öµÚÈý·½¹¤¾ß¶¼×öµÃ²»´í£¬ÊÇÒ»¸ö»ù±¾¹¦ÄÜ¡£
2. ×Ô¶¯Ìáʾ¡£
Ò²¾ÍÊÇÉÏÃæÌáµ½µÄCompletion Insight¹¦ÄÜ£¬¿ÉÒÔ˵£¬Oracle SQL DeveloperÓµÓеŦÄÜÒÔ¼°ËٶȾø¶Ô²»ÑÇÓÚPL/SQL Developer£¬ÉõÖÁÓиüÈËÐÔ»¯µÄ±íÏÖ¡£±ÈÈçµ±Äã¼üÈëselect * from£¬¿Õ¸ñÖ®ºó£¬Oracle SQL Developer»áÁ¢¿Ì¸ø³öÒ»¸öµ±Ç°Óû§ÏµÄËùÓÐTableµÄÁÐ±í£¬Èç¹û¼ÌÐø¼üÈë±ÈÈçDBAÈý¸ö×Öĸ£¬ÄÇôÁÐ±í½«×ª»»ÎªDBA´òÍ·µÄËùÓÐÊý¾Ý×ֵ䡣¶øÈç ¹ûÄã´ÓÒ»ÐеĿªÍ·¼üÈëexecËĸö×Öĸ£¬ÄÇôµ±»Ø³µÒÔºó£¬Oracle SQL Developer»áÁ¢¿Ì¸ø³öÒ»·ÝËùÓпÉÒÔÖ´ÐеĴ洢¹ý³ÌµÄÁÐ±í¡£
×îа汾ÖжÔÓÚV$ÊÓͼµÄÌáʾÓÐbug£¬ÏàÐźܿì¾Í¿ÉÒÔÐ޸ġ£
3. ´úÂëÃÀ»¯¹¦ÄÜ¡£
ËùÓÐʹÓùýPL/SQL DeveloperµÄÅóÓÑÃÇÓ¦¸Ã¶¼ÖªµÀÔÚ×î½üÕ⼸°æÖж¼ÓÐÒ»¸öPL/SQL BeautifierµÄ¹¦ÄÜ£¬¿ÉÒÔ½«Ò»´ó´®SQLÓï¾ä¸ñʽ»¯¸üÈÝÒ×ÔĶÁµÄÑùʽ¡£Í¬ÑùOracle SQL DeveloperÒ²ÌṩÁËÕâÑùµÄ¹¦ÄÜ£¬³ÆÖ®ÎªFormat£¬¿ì½Ý¼üÊÇCtrl+F7¡£
4. ÏÔʾSQLµÄÖ´Ðмƻ®¡£
ÔÚOracle SQL DeveloperÖпì½Ý¼üÊÇF6£¬Í¬Ê±Ò²ÌṩÁËÏÔʾAutotraceµÄ½á¹û£¬¿ì½Ý¼üÊÇF10£¨×îа汾ÖÐËÆºõÓеã¶ùСbug£¬ÓÐʱºòÐèÒª°´Á½´


Ïà¹ØÎĵµ£º

MS SQL SERVER º£Á¿Êý¾ÝµÄ²éѯÓÅ»¯¼°·ÖÒ³Ëã·¨


̽ÌÖÈçºÎÔÚÓÐ×Å1000ÍòÌõÊý¾ÝµÄMS SQL SERVERÊý¾Ý¿âÖÐʵÏÖ¿ìËÙµÄÊý¾ÝÌáÈ¡ºÍÊý¾Ý·ÖÒ³¡£ÒÔÏ´úÂë˵Ã÷ÁËÎÒÃÇʵÀýÖÐÊý¾Ý¿âµÄ“ºìÍ·Îļþ”Ò»±íµÄ²¿·ÖÊý¾Ý½á¹¹£º
CREATE TABLE [dbo].[TGongwen] (    --TGongwenÊǺìÍ·Îļþ±íÃû
   [Gid] [int]&nb ......

LINQ to SQL ѧϰreference

http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far. ......

Oracle SQL LoaderµÄÏêϸÓï·¨

Oracle
SQL
Loader
µÄÏêϸÓï·¨
Oracle
   SQL
   Loader
µÄÏêϸÓï·¨
  
  SQL
*LOADER
ÊÇ
ORACLE
µÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½
ORACLE
Êý¾Ý¿âÖС£
SQL
*LOADER
ÊÇ´óÐÍÊý¾Ý
  
 
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨£¬ÒòΪËüÌṩÁË×î¿ì ......

SQLÐÐתÁÐ ÁÐתÐÐ


--ÐÐÁл¥×ª
/****************************************************************************************************************************************************** 
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶® ÕûÀíÈË£ºÖйú·ç
(Roy) 
ÈÕÆÚ
:2008.06.06 *************************************** ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ