SQL PLUS ÃüÁî´óÈ«(ת)
OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆΪsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È»ºóÔÙ´ÎÖ´ÐУ¬sql*plusÒ»°ã¶¼ÓëÊý¾Ý¿â´ò½»µÀ¡£
³ýÁËsql*plusÓï¾ä£¬ÔÚsql*plusÖÐÖ´ÐеÄÆäËüÓï¾äÎÒÃdzÆ֮Ϊsql*plusÃüÁî¡£ËüÃÇÖ´ÐÐÍêºó£¬²»±£´æÔÚsql bufferµÄÄÚ´æÇøÓòÖУ¬ËüÃÇÒ»°ãÓÃÀ´¶ÔÊä³öµÄ½á¹û½øÐиñʽ»¯ÏÔʾ£¬ÒÔ±ãÓÚÖÆ×÷±¨±í¡£
ÏÂÃæ¾Í½éÉÜÒ»ÏÂһЩ³£ÓõÄsql*plusÃüÁ
1. Ö´ÐÐÒ»¸öSQL½Å±¾Îļþ
SQL>start file_name
SQL>@ file_name
ÎÒÃÇ¿ÉÒÔ½«¶àÌõsqlÓï¾ä±£´æÔÚÒ»¸öÎı¾ÎļþÖУ¬ÕâÑùµ±ÒªÖ´ÐÐÕâ¸öÎļþÖеÄËùÓеÄsqlÓï¾äʱ£¬ÓÃÉÏÃæµÄÈÎÒ»ÃüÁî¼´¿É£¬ÕâÀàËÆÓÚdosÖеÄÅú´¦Àí¡£
@Óë@@µÄÇø±ðÊÇʲô£¿
@µÈÓÚstartÃüÁÓÃÀ´ÔËÐÐÒ»¸ösql½Å±¾Îļþ¡£
@ÃüÁîµ÷Óõ±Ç°Ä¿Â¼Ïµģ¬»òÖ¸¶¨È«Â·¾¶£¬»ò¿ÉÒÔͨ¹ýSQLPATH»·¾³±äÁ¿ËÑÑ°µ½µÄ½Å±¾Îļþ¡£¸ÃÃüÁîʹÓÃÊÇÒ»°ãÒªÖ¸¶¨ÒªÖ´ÐеÄÎļþµÄȫ·¾¶£¬·ñÔò´Óȱʡ·¾¶(¿ÉÓÃSQLPATH±äÁ¿Ö¸¶¨)϶ÁÈ¡Ö¸¶¨µÄÎļþ¡£
@@ÓÃÔÚsql½Å±¾ÎļþÖУ¬ÓÃÀ´ËµÃ÷ÓÃ@@Ö´ÐеÄsql½Å±¾ÎļþÓë@@ËùÔÚµÄÎļþÔÚͬһĿ¼Ï£¬¶ø²»ÓÃÖ¸¶¨ÒªÖ´ÐÐsql½Å±¾ÎļþµÄȫ·¾¶£¬Ò²²»ÊÇ´ÓSQLPATH»·¾³±äÁ¿Ö¸¶¨µÄ·¾¶ÖÐÑ°ÕÒsql½Å±¾Îļþ£¬¸ÃÃüÁîÒ»°ãÓÃÔڽű¾ÎļþÖС£
È磺ÔÚc:\tempĿ¼ÏÂÓÐÎļþstart.sqlºÍnest_start.sql£¬start.sql½Å±¾ÎļþµÄÄÚÈÝΪ£º
@@nest_start.sql - - Ï൱ÓÚ@ c:\temp\nest_start.sql
ÔòÎÒÃÇÔÚsql*plusÖУ¬ÕâÑùÖ´ÐУº
SQL> @ c:\temp\start.sql
2. ¶Ôµ±Ç°µÄÊäÈë½øÐбà¼
SQL>edit
3. ÖØÐÂÔËÐÐÉÏÒ»´ÎÔËÐеÄsqlÓï¾ä
SQL>/
4. ½«ÏÔʾµÄÄÚÈÝÊä³öµ½Ö¸¶¨Îļþ
SQL> SPOOL file_name
ÔÚÆÁÄ»ÉϵÄËùÓÐÄÚÈݶ¼°üº¬ÔÚ¸ÃÎļþÖУ¬°üÀ¨ÄãÊäÈëµÄsqlÓï¾ä¡£
5. ¹Ø±ÕspoolÊä³ö
SQL> SPOOL OFF
Ö»ÓйرÕspoolÊä³ö£¬²Å»áÔÚÊä³öÎļþÖп´µ½Êä³öµÄÄÚÈÝ¡£
6£®ÏÔʾһ¸ö±íµÄ½á¹¹
SQL> desc table_name
7. COLÃüÁ
Ö÷Òª¸ñʽ»¯ÁеÄÏÔʾÐÎʽ¡£
¸ÃÃüÁîÓÐÐí¶àÑ¡Ï¾ßÌåÈçÏ£º
COL[UMN] [{ column|expr} [ option ...]]
O
Ïà¹ØÎĵµ£º
½ñÌìÔÚÉÏCSDN¿Õ¼äµÄʱºò£¬Êý¾Ý¿â³ö´íÖ±½ÓÅ׳öSQLÎÄÁË£¬ÏûÏ¢ÈçÏ£º
MySQL Error
Message
: MySQL Query Error
SQL
: SELECT main.*, field.* from uchome_space main, uchome_spacefield field
WHERE field.sex='1' AND field.uid=main.uid
ORDER BY main.viewnum DESC LIMIT 0,100
Error
: Inco ......
Distinct
SELECT DISTINCT "À¸Î»"
from "±í¸ñÃû"
Where
SELECT "À¸Î»"
from "±í¸ñÃû"
WHERE "condition"
And/Or
SELECT "À¸Î»"
from "±í¸ñÃû"
WHERE "¼òµ¥Ìõ¼þ"
{[AND|OR] "¼òµ¥Ìõ¼þ"}+
In
SELECT "À ......
ÒªÔÚSQL ServerÊý¾Ý¿âÖд洢m³²¢´òÓ¡³öÀ´, ·½·¨ÈçÏ£º
1£©½«Êý¾Ý¿âÖÐÏàÓ¦×ֶεÄÊý¾ÝÀàÐÍÉèΪnchar»ònvarcharÀàÐÍ¡£
2£©´ÓExcelÖеõ½m³£¬¸´ÖÆÕ³Ìùµ½½ÓÊÕÊý¾ÝµÄ¿Ø¼þÖУ¨TextBox¡¢DataGridViewµÈ£©¡£±£´æ¼´¿É¡£
×¢£º1£©nchar,nvarcharÓëchar,varcharµ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
ΪÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u r ......