SQL_Plus²Ù×÷ÃüÁî ¸½Â¼B SQL*PLUS
SQL_Plus²Ù×÷ÃüÁî ¸½Â¼B SQL*PLUS
SQL*PLUS ÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚ²âÊÔ£¬ÔËÐÐSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒ»¹¿ÉÒÔÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â
1.Æô¶¯sql*plus
ΪÁËʹÓÃsql*plus£¬±ØÐëÊ×ÏÈÒªÆô¶¯sql*plus¡£Oracle²»½öÌṩÁËÃüÁîÐкÍͼÐνçÃæµÄsql*plus£¬¶øÇÒ»¹¿ÉÒÔÔÚwebä¯ÀÀÆ÷ÖÐÔËÐÐ.
(1)ÔÚÃüÁîÔËÐÐsql*plus
ÔÚÃüÁîÐÐÔËÐÐsql*plusÊÇʹÓÃsqlplusÃüÁîÀ´Íê³ÉµÄ£¬¸ÃÃüÁîÊÊÓÃÓÚÈκβÙ×÷ϵͳƽ̨£¬
Óï·¨ÈçÏÂ:
sqlplus [username]/[password][@server]
ÈçÉÏËùʾ:usernameÓÃÓÚÖ¸¶¨Êý¾Ý¿âÓû§Ãû£¬passwordÓÃÓÚÖ¸¶¨Óû§¿ÚÁserverÔòÓÃÓÚÖ¸¶¨Ö÷»ú×Ö·û´®(ÍøÂç·þÎñÃû).µ±Á¬½Óµ½±¾µØÊý¾Ýʱ£¬²»ÐèÒªÌṩÍøÂç·þÎñÃû,Èç¹ûÒªÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿â£¬Ôò±ØÐëҪʹÓÃÍøÂç·þÎñÃû.
(2)ÔÚwindows»·¾³ÖÐÔËÐÐsql*plus
Èç¹ûÔÚwindows»·¾³Öа²×°ÁËoralceÊý¾Ý¿â²úÆ·£¬ÄÇô¿ÉÒÔÔÚ´°¿Ú»·¾³ÖÐÔËÐÐsql*plus
¾ßÌå·½·¨: "¿ªÊ¼->³ÌÐò->oracle-oradb10g_home1->application development->sql*plus"
2.Á¬½ÓÃüÁî
(1)conn[ect]
¸ÃÃüÁîÓÃÓÚÁ¬½Óµ½Êý¾Ý¿â¡£×¢Ò⣬ʹÓøÃÃüÁÁ¢Ð»Ựʱ£¬»á×Ô¶¯¶Ï¿ªÏÈÇ°»á»°£¬Ê¾ÀýÈçÏÂ:
sql>conn scott/yhai1981@demo
(2)disc[onnect]
¸ÃÃüÁîÓÃÓڶϿªÒѾ´æÔÚµÄÊý¾Ý¿âÁ¬½Ó¡£×¢£º¸ÃÃüÁîÖ»ÊǶϿªÁ¬½Ó»á»°£¬¶ø²»»áÍ˳ösql*plus£¬Ê¾ÀýÈçÏÂ:
sql>disc
(3)passw[ord]
¸ÃÃüÁîÓÃÓÚÐÞ¸ÄÓû§µÄ¿ÚÁî¡£×¢£¬ÈκÎÓû§¶¼¿ÉÒÔʹÓøÃÃüÁîÐÞ¸ÄÆä×ÔÉí¿ÚÁµ«Èç¹ûÒªÐÞ¸ÄÆäËûÓû§µÄ¿ÚÁîʱ£¬Ôò±ØÐëÒÔDBAÉí·Ý(sysºÍsystem)µÇ¼£¬ÔÚsql*plusÖУ¬µ±ÐÞ¸ÄÓû§¿ÚÁîʱ£¬¿ÉÒÔʹÓøÃÃüÁîÈ¡´úsqlÃüÁîalter user,
ʾÀýÈçÏÂ:
sql>passw
¸ü¸ÄscottµÄ¿ÚÁî
¾É¿ÚÁî:******
пÚÁî:******
ÖØмüÈëпÚÁî:******
¿ÚÁîÒѸü¸Ä
sql>
(4)exit
¸ÃÃüÁîÓÃÓÚÍ˳ö sql*plus,ÁíÍâÄãÒ²¿ÉÒÔʹÓÃquitÃüÁîÍ˳ösql*plus.ʹÓøÃÃüÁî²»½ö»á¶Ï¿ªÁ¬½Ó£¬¶øÇÒÒ²»áÍ˳ösql*plus
×¢:ĬÈÏÇé¿öÏ£¬µ±Ö´ÐиÃÃüÁîʱ»á×Ô¶¯Ìá½»ÊÂÎñ¡£
3£¬±à¼ÃüÁî
(1)l[ist]
¸ÃÃüÁîÓÃÓÚÁгösql»º³åÇøµÄÄÚÈÝ£¬Ê¹ÓøÃÃüÁî¿ÉÒÔÁгösql»º³åijÐУ¬Ä³¼¸ÐлòËùÓÐÐеÄÄÚÈÝ¡£ÔÚÏÔʾ½á¹ûÖÐ,Êý¾Ý×ÖΪ¾ßÌ
Ïà¹ØÎĵµ£º
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º ......
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
Ò²¿ÉÒÔʹÓÃÁªºÏÖ÷¼ü id+id2+id3+……
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP 10 *
from TestTable
WHERE (ID NOT IN
(SELECT TOP 20 id
&nb ......
Ïò±íÖÐÌí¼ÓÒ»¸öмǼ£¬ÄãҪʹÓÃSQL INSERT Óï¾ä¡£
ÕâÀïÓÐÒ»¸öÈçºÎʹÓÃÕâÖÖÓï¾äµÄÀý×Ó£º
INSERT mytable (mycolumn) VALUES (‘some data’)
Õâ¸öÓï¾ä°Ñ×Ö·û´®’some data’²åÈë±ímytableµÄmycolumn×Ö¶ÎÖС£½«Òª±»²åÈëÊý¾ÝµÄ×ֶεÄÃû×ÖÔÚµÚÒ»¸öÀ¨ºÅÖÐÖ¸¶¨£¬Êµ¼ÊµÄÊý¾ÝÔÚµÚ¶þ¸öÀ¨ºÅÖиø³ö¡£
I ......
1.
select top m * from tablename where id not in (select top n id from tablename)
2.
select top & ......
select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used", round((f.free/a.total)*100) "% Free"
from
(select tablespace_name, sum(bytes/(1024*1024)) total
from dba_data_files group by tablespace_name) a,
(select tabl ......