Oracle SQL PLUS µÇ¼ Æô¶¯ ¹Ø±Õ
Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba" ÒÔsysdbaÉí·ÝµÇ¼
c:\>sqlplus/nolog ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
Æô¶¯
SQL> startup
Õý³£Æô¶¯ £¨1Æô¶¯ÊµÀý£¬2´ò¿ª¿ØÖÆÎļþ£¬3´ò¿ªÊý¾ÝÎļþ£©
SQL> startup mount
(1Æô¶¯ÊµÀý£¬2´ò¿ª¿ØÖÆÎļþ) ²»Æô¶¯Êý¾ÝÎļþ
ÀýÈç½øÐÐÈȱ¸·ÝµÄʱºò£¬ÔÚ²»¹éµµ·½Ê½£¨No Archive Mode£©Ï²»ÄܽøÐС£ËùÒÔÒª¸ü¸Äģʽ£¬µ«¸ü¸Äģʽ²»ÔÊÐíÆô¶¯Êý¾ÝÎļþ£¬Õâʱºò¾ÍÒªÓõ½mount²ÎÊýÀ´Æô¶¯¡£ÔÚmountģʽÏ£¬ÊäÈëalter database archivelog È»ºóд alter database open´ò¿ªÊý¾ÝÎļþ¡£
SQL> startup nomount
Æô¶¯ÊµÀý£¬Á¬¿ØÖÆÎļþÒ²²»´ò¿ª£¬ÀýÈç¿ØÖÆÎļþË𻵣¬¸ù±¾´ò²»¿ªµÄÇé¿ö£¬ÔÚÆô¶¯ÊµÀýÖ®ºó£¬ÖØÐ´´½¨¿ØÖÆÎļþ¡£
¹Ø±Õ
SQL> shutdown immediate
´ó¶àÊýÇé¿öÏÂʹÓá£ÆÈʹÿ¸öÓû§Ö´ÐÐÍ굱ǰSQLÓï¾äºó¶Ï¿ªÁ¬½Ó¡£
SQL> shutdown
ÓÐÓû§Á¬½Ó¾Í²»¹Ø±Õ£¬Ö±µ½ËùÓÐÓû§¶Ï¿ªÁ¬½Ó¡£
SQL> shutdown transactional
Ö´ÐÐÍ굱ǰ²Ù×÷¶Ï¿ªÁ¬½Ó£¬»Ö¸´µÄÊý¾Ý¿âÎļþ²»ÄÜÓëÆäËûÊý¾Ý¿âÎļþ±£³ÖÒ»Ö¡£
SQL> shutdown abort
×îǿӲÊֶΡ£Ç¿Öƹرյ±Ç°Êý¾Ý¿â¡£ºÜ¿ÉÄÜÔì³ÉÊý¾ÝË𻵡£Ö»Óе±·¢Éú²»¿É¿¹¾Üʼþ²ÅʹÓã¨ÀýÈçµØÕð£¬À´²»¼°¹Ø±Õµ±Ç°Êý¾Ý¿â£¬Ö´ÐÐÇ¿ÖÆ¹Ø±Õ£©
Ïà¹ØÎĵµ£º
ÔÚSQL ServerÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪidentityÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers (
id int identity(1,1) primary key not null,
name varchar(15)
);
insert into customers(name) values("name1"),("name2");
select id from customers;
²éѯ½á¹ûΪ£º
id
---
1
2
ÓÉ´Ë¿ ......
ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
q Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q ¼õÉÙ´ÅÅÌI/O
q ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q &n ......
ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
Óαê
¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐǰ¹ØÁª
&nb ......
´¥·¢Æ÷
q ´¥·¢Æ÷Êǵ±Ìض¨Ê¼þ³öÏÖʱ×Ô¶¯Ö´ÐеĴ洢¹ý³Ì
q ÌØ¶¨Ê¼þ¿ÉÒÔÊÇÖ´ÐиüеÄDMLÓï¾äºÍDDLÓï¾ä
q ´¥·¢Æ÷²»Äܱ»ÏÔʽµ÷ÓÃ
q ´¥·¢Æ÷µÄ¹¦ÄÜ£º
q ......