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

PL/SQL DeveloperʹÓü¼ÇÉ

 1¡¢PL/SQL
Developer¼ÇסµÇ½ÃÜÂë
   ÔÚʹÓÃPL/SQL
Developerʱ£¬ÎªÁ˹¤×÷·½±ãÏ£ÍûPL/SQL
Developer¼ÇסµÇ¼OracleµÄÓû§ÃûºÍÃÜÂ룻
ÉèÖ÷½·¨£ºPL/SQL
Developer 7.1.2 
->tools->Preferences->Oracle->Logon History £¬ “Store
history”ÊÇĬÈϹ´Ñ¡µÄ£¬¹´ÉÏ“Store with password” ¼´¿É£¬ÖØеǼÔÚÊäÈëÒ»´ÎÃÜÂëÔò¼ÇסÁË¡£

2¡¢Ö´Ðе¥ÌõSQLÓï¾ä
   ÔÚʹÓÃPL/SQL
DeveloperµÄSQL Windowʱ£¬°´F8¼ü£¬PL/SQL
DeveloperĬÈÏÊÇÖ´Ðиô°¿ÚµÄËùÓÐSQLÓï¾ä£¬ÐèÒªÉèÖÃΪÊó±êËùÔÚµÄÄÇÌõSQLÓï¾ä£¬¼´Ö´Ðе±Ç°SQLÓï¾ä£»
ÉèÖ÷½·¨£ºPL/SQL
Developer 7.1.2 -->tools->Preferences-->Window types £¬¹´ÉÏ“AutoSelect Statement” ¼´¿É¡£

3¡¢¸ñʽ»¯SQLÓï¾ä
   ÔÚʹÓÃPL/SQL
DeveloperµÄSQL Windowʱ£¬ÓÐʱºòÊäÈëµÄSQLÓï¾äÌ«³¤»òÌ«ÂÒ£¬Ï£ÍûÄÜÓñȽÏͨÓõÄд·¨¸ñʽ»°Ò»Ï£¬ÕâÑù¿´ÆðÀ´»áºÃ¿´Ð©£¬Ò²ºÃ·ÖÎö£»
ʹÓ÷½·¨£ºÑ¡ÖÐÐèÒª¸ñʽ»¯µÄSQLÓï¾ä£¬È»ºóµã»÷¹¤¾ßÀ¸µÄPL/SQL
beautifier°´Å¥¼´¿É.

4¡¢²é¿´Ö´Ðмƻ®
   ÔÚʹÓÃPL/SQL
DeveloperµÄSQL Windowʱ£¬ÓÐʱºòÊäÈëµÄSQLÓï¾äÖ´ÐеÄЧÂÊ£¬·ÖÎöϱí½á¹¹£¬ÈçºÎ¿ÉÒÔÌá¸ß²éѯµÄЧÂÊ£¬¿ÉÒÔͨ¹ý²é¿´OracleÌṩµÄÖ´Ðмƻ®£»
ʹÓ÷½·¨£ºÑ¡ÖÐÐèÒª·ÖÎöµÄSQLÓï¾ä£¬È»ºóµã»÷¹¤¾ßÀ¸µÄExplain plan°´Å¥£¨¼´Ö´Ðмƻ®£©£¬»òÕßÖ±½Ó°´F5¼´¿É¡£
 
5¡¢µ÷ÊÔ´æ´¢¹ý³Ì
   ÔÚʹÓÃPL/SQL
Developer²Ù×÷Oracleʱ£¬ÓÐʱºòµ÷ÓÃijЩ´æ´¢¹ý³Ì£¬»òÕßµ÷ÊÔ´æ´¢¹ý³Ì£»
µ÷Óô洢¹ý³ÌµÄ·½·¨£ºÊ×ÏÈ£¬ÔÚPL/SQL
Developer×ó±ßµÄBrowserÖÐÑ¡ÔñProcedures£¬²éÕÒÐèÒªµ÷ÓõĴ洢¹ý³Ì£»È»ºó£¬Ñ¡Öе÷ÊԵĴ洢¹ý³Ì£¬µã»÷ÓÒ¼ü£¬Ñ¡ÔñTest£¬ÔÚµ¯
³öÀ´µÄTest scrīpt´°¿ÚÖУ¬¶ÔÓÚ¶¨ÒåΪinÀàÐ͵IJÎÊý£¬ÐèÒª¸ø¸Ã²ÎÊýµÄValueÊäÈëÖµ£»×îºóµã»÷ÉÏÃæµÄÌõÊý°´Å¥£ºStart
debugger »òÕß°´F9£»×îºóµã»÷£ºRUN »òÕßCtrl+R
PL/SQL DEVELOPER »ù±¾Ó÷¨Ïê½â£¨×ª£©
ת×ÔCSDN
  
PL/SQL DEVELOPER »ù±¾Ó÷¨Ïê½â(½¨Òéд¹ýµÚÒ»¸ö´æ´¢¹ý³ÌºóµÄ³õÊֱضÁ)
  
ÓùýoracleµÄ¶¼±§Ô¹£¬ÎªÁËÎȶ¨ ËüÌṩµÄͼÐλ¯²Ù×÷ ËÙ¶ÈÂýµÄÈÃÈËÉËÐÄѽ£¬p4+128MµÄ»úÆ÷Ö»ÒªÆô¶¯Ò»¸ö
  
oracle·þÎñ¾Í¹»ÈÃÈËÉËÐĵģ¬ÔÙÔÚdba studioÀïÃæ²Ù×÷ÕæÄÜÈÃÈË¿Þ¡£
  pl/sql developerÕýÊÇ


Ïà¹ØÎĵµ£º

SQL Server

Êý¾ÝÀàÐÍ
ÔÚ Microsoft SQL ServerÖУ¬Ã¿¸öÁС¢¾Ö²¿±äÁ¿¡¢±í´ïʽºÍ²ÎÊý¶¼ÓÐÒ»¸öÏà¹ØµÄÊý¾ÝÀàÐÍ£¬ÕâÊÇÖ¸¶¨¶ÔÏó¿É³ÖÓеÄÊý¾ÝÀàÐÍ£¨ÕûÐÍ¡¢×Ö·û¡¢money µÈµÈ£©µÄÌØÐÔ¡£SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌá ......

SQLÁ¬½ÓÀà

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Runtime.InteropServices;
using System.Windows.Forms;
namespace DAL
{ ......

sql ¾­µäÒ»

1.½¨±í
create table temp(rq varchar(10),shengfu nchar(1))
2.²åÈëÊý¾Ý
insert into temp values('2005-05-09','ʤ')
insert into temp values('2005-05-09','ʤ')
insert into temp values('2005-05-09','¸º')
insert into temp values('2005-05-09','¸º')
insert into temp values('2005-05-10','ʤ')
insert i ......

SQL SERVERµÄROWCOUNT¹Ø¼ü×Ö

 
ÒòΪÑöÍûORACLE£¬ËùÒÔÒ»Ö±¶¼ÒÔΪSQL SERVERºÜ±¿¡£
¾Ý´«SQL 2005ÓÐÁËRowIDµÄ¶«Î÷£¬¿ÉÒÔ½â¾öTOPÅÅÐòµÄÎÊÌâ¡£¿Éϧ»¹Ã»Óлú»áÌåÑé¡£ÔÚSQL 2000ÖÐд´æ´¢¹ý³Ì£¬×Ü»áÓöµ½ÐèÒªTOPµÄµØ·½£¬¶øÒ»µ©Óöµ½TOP£¬ÒòΪû°ì·¨°ÑTOPºóÃæµÄÊý×Ö×÷Ϊ±äÁ¿Ð´µ½Ô¤±àÒëµÄÓï¾äÖÐÈ¥£¬ËùÒÔÖ»Äܹ»Ê¹Óù¹Ôì SQL£¬Ê¹ÓÃExecÀ´Ö´ÐС£²»ËµÐ§ÂʵÄÎÊÌ⣠......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ