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ÕýÊÇ
Ïà¹ØÎĵµ£º
Êý¾ÝÀàÐÍ
ÔÚ Microsoft SQL ServerÖУ¬Ã¿¸öÁС¢¾Ö²¿±äÁ¿¡¢±í´ïʽºÍ²ÎÊý¶¼ÓÐÒ»¸öÏà¹ØµÄÊý¾ÝÀàÐÍ£¬ÕâÊÇÖ¸¶¨¶ÔÏó¿É³ÖÓеÄÊý¾ÝÀàÐÍ£¨ÕûÐÍ¡¢×Ö·û¡¢money µÈµÈ£©µÄÌØÐÔ¡£SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌá ......
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
{
......
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 ......
ÒòΪÑöÍûORACLE£¬ËùÒÔÒ»Ö±¶¼ÒÔΪSQL SERVERºÜ±¿¡£
¾Ý´«SQL 2005ÓÐÁËRowIDµÄ¶«Î÷£¬¿ÉÒÔ½â¾öTOPÅÅÐòµÄÎÊÌâ¡£¿Éϧ»¹Ã»Óлú»áÌåÑé¡£ÔÚSQL 2000ÖÐд´æ´¢¹ý³Ì£¬×Ü»áÓöµ½ÐèÒªTOPµÄµØ·½£¬¶øÒ»µ©Óöµ½TOP£¬ÒòΪû°ì·¨°ÑTOPºóÃæµÄÊý×Ö×÷Ϊ±äÁ¿Ð´µ½Ô¤±àÒëµÄÓï¾äÖÐÈ¥£¬ËùÒÔÖ»Äܹ»Ê¹Óù¹Ôì SQL£¬Ê¹ÓÃExecÀ´Ö´ÐС£²»ËµÐ§ÂʵÄÎÊÌ⣠......