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×Ö½Ú£¬×Ô¶¯µ
Ïà¹ØÎĵµ£º
1¡¢µÚÒ»²½£¬Ñ¡ÖÐÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â——ÓÒ¼ü——ÊôÐÔ¡£
2¡¢µÚ¶þ²½£ºÔÚÑ¡ÏîҳѡÖГѡÏ¬»Ö¸´Ä£Ê½Ñ¡Ôñ“¼òµ¥”£¬µã»÷×îϱßÈ·¶¨°´Å¥¡£
3¡¢µÚÈý²½£¬ÔÙÑ¡ÖÐÊý¾Ý¿âÓÒ¼ü——ÈÎÎñ——ÊÕËõ——Êý¾Ý¿â¡£
4¡¢µÚËIJ½£¬µã»÷&ldq ......
D:\projects\openi\misc\xxxx_data_20090828>bcp [xxxxolap].[dbo].[wdb_cxbz] in wdb_xxx.txt -c -T
SQLState = 37000, NativeError = 4060
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "xxxolap" requested by the login. The login failed.
S ......
ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì(תÌù)
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓ ......
×î¼Ñ´ð°¸·½·¨1£º
ÔÚ²éѯ·ÖÎöÒÇÀïÃæÔËÐÐÏÂÃæ´úÂ룺
backup log dbname with NO_LOG
backup log dbname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbname)
·½·¨2£º
½øÈëÆóÒµ¹ÜÀíÆ÷£¬Ñ¡ÖÐÊý¾Ý¿â
ËùÓÐÈÎÎñ->·ÖÀëÊý¾Ý¿â
µ½Êý¾Ý¿âÎļþµÄ´æ·ÅĿ¼£¬½«dbname_log.LDFÎļþɾ³ý£¬ÅÂSµÄ»° ......
1¡¢ ÓóÌÐòÖУ¬±£Ö¤ÔÚʵÏÖ¹¦ÄܵĻù´¡ÉÏ£¬¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿âµÄ·ÃÎÊ´ÎÊý£»Í¨¹ýËÑË÷²ÎÊý£¬¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý,×îС»¯½á¹û¼¯£¬´Ó¶ø¼õÇáÍøÂ縺µ££»Äܹ»·Ö¿ªµÄ ²Ù×÷¾¡Á¿·Ö¿ª´¦Àí£¬Ìá¸ßÿ´ÎµÄÏìÓ¦Ëٶȣ»ÔÚÊý¾Ý´°¿ÚʹÓÃSQLʱ£¬¾¡Á¿°ÑʹÓõÄË÷Òý·ÅÔÚÑ¡ÔñµÄÊ×ÁУ»Ëã·¨µÄ½á¹¹¾¡Á¿¼òµ¥£»ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØʹÓÃͨÅä·û ÈçSELE ......