SQLÓïÑÔ»ù´¡£¨Ò»£©
SQL*PLUSµÄʹÓÃ
1¡¢Í˳öSQL*PLUS
EXIT£ºÖÕÖ¹SQL*PLUS£¬²¢½«¿ØÖÆȨ½»»¹¸øOS¡£
2¡¢±à¼ÃüÁî
1) List»òL£ºÏÔʾ»º³åÇøÖÐËùÓеÄÐС£
SQL> list
1 select
2 *
3* from dept --×¢£º*´ú±íµ±Ç°ÐС£
2) LIST*»òL*£ºÏÔʾ»º³åÇøÖеĵ±Ç°ÐС£
SQL> l*;
3* from dept
3) LIST n»òL n£º½«Ö¸¶¨ÐÐÉèΪµ±Ç°ÐС£
SQL> list 2;
2* *
4) LIST m n£ºÏÔʾָ¶¨·¶Î§ÄÚµÄÐС£
SQL> l 2 3
2 *
3* from dept
5) Append£º½«Ö¸¶¨µÄÎı¾Ôö¼Óµ½»º³åÇøÄÚµ±Ç°ÐÐĩβ¡£
SQL> append * from dept;
1* select* from dept
SQL> list 1
1* select* from dept
6) /£ºÖ´Ðлº³åÇøÄÚµÄSQLÃüÁî»òPL/SQLÃüÁî¡£
7) RUN£ºÏÔʾ²¢Ö´Ðлº³åÇøÄÚµÄSQLÃüÁî»òPL/SQLÃüÁî¡£
8) DELETE»òDEL£ºÉ¾³ý»º³åÇøÄڵĵ±Ç°ÐС£
9) Change£ºÐ޸Ļº³åÇøÄÚµ±Ç°ÐеÄÎı¾¡££¿
10) CLEAR SCREEN£ºÇå³ýÆÁÄ»¡£
11) CONNECT username/password£ºÓøø¶¨µÄÓû§Ãû¡¢ÃÜÂëÁ¬½Óµ½Ö¸¶¨Óû§¡£
12) DESCRIBE»òDESC£ºÏÔʾָ¶¨±í¡¢Í¬Òé´Ê¡¢ÊÓͼµÄÁж¨Ò壬»òÕßÖ¸¶¨º¯Êý»ò¹ý³ÌµÄ˵Ã÷¡£
13) SHOW£ºÏÔʾSQL*PLUSϵͳ±äÁ¿Öµ»òµ±Ç°µÄSQL*PLUS»·¾³¡£
exp1:show user£ºÏÔʾµ±Ç°Óû§¡£
exp2:show all£ºÏÔʾSQL*PLUSϵͳ±äÁ¿Öµ¡£
14) SET LINESIZE ÕûÊý£ºÉèÖòéѯ·µ»ØµÄ¼Ç¼ÿÐеĿí¶È£¬³¬¹ýÕâ¸ö¿í¶ÈÔò½Ø¶Ï·Åµ½ÏÂÒ»ÐУ¬²»¹»Õâ¸ö¿í¶ÈÔò²¹³ä¿Õ¸ñ¡£
15) SET PAGESIZE ÕûÊý£ºÖ¸¶¨¶àÉÙÐÐÏÔʾһ´ÎÁÐÍ·£¬Èç¹ûÖ¸¶¨0Ôò²»ÏÔʾÁÐÍ·¡£
16) @(Start)£ºÔËÐÐÖ¸¶¨µÄÃüÁîÎļþ£¨.txt£¬.sql£©Èç@a¡¢@ d:\a.txt¡¢@ d:\a.sq;
17) SAVE£ºÓ÷¨£º SAVE ÎļþĿ¼\ÎļþÃû(txt¡¢sql)
ORACLE³£ÓÃÊý¾ÝÀàÐÍ
1¡¢×Ö·ûÊý¾ÝÀàÐÍ
1) CHAR(n)£º¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬nµÄÈ¡Öµ·¶Î§Îª1~2000×Ö½Ú£¬Ä¬ÈÏֵΪ1×Ö½Ú¡£³¤¶È²»×ãnʱ£¬ÓÿոñÌî³ä¡£
2) VARCHAR2(n)£º±ä³¤×Ö·û´®£¬n×Ö½Ú³¤£¬nµÄÈ¡Öµ·¶Î§Îª1~4000×Ö½Ú£¬×Ô¶¯µ
Ïà¹ØÎĵµ£º
update t1 set t1.value=t2.value from t2 where t1.id=t2.id
update jbsite_class set topicnum = count
from (select t2.classid,count from (
select distinct classid,count(*) as count
from jbsite_product ......
createdb.batÎļþ
@echo off
echo ╬¡¡╱◥███◣╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬
echo ╬ ︱Ìï︱Ìï Ìï ︱¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ......
×î½üÐÞ¸ÄÊý¾Ý¿âÒѾ´æÔڵıí½á¹¹£¬·¢ÏÖÓÃSQLÓï¾äÄܺܺõÄÐ޸ıíµÄ½á¹¹¡£SQLÊý¾Ý¿â¼Ç¼Êý·Ç³£ÅÓ´ó£¬Èç¹ûÏëÐ޸ıíµÄ×Ö¶ÎÀàÐÍ£¬Ê¹ÓÃÆóÒµ¹ÜÀíÆ÷À´¸ü¸Ä×Ö¶ÎÀàÐÍ£¬ºÜ¶àʱºò»á³¬Ê±£¬¸ü¸Ä²»³É¹¦£¬Õâ¸öʱºò£¬¿ÉÒÔÓÃSQLÓï¾äÀ´¸ü¸Ä£¬ÒÔÏÂΪÏàÓ¦µÄ´úÂëʵÀý£º
1.¸ü¸Ä×Ö¶ÎÀàÐͳ¤¶È
alert table ±í alert column ×Ö¶ÎÃû ÀàÐ͵ij¤¶È
eg: ......
¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎÄ°æµÄ¡££¨windows ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì
......