OracleÊý¾Ý¿âSQL*plus³£ÓõÄÃüÁîºÍº¯Êý
OracleÖг£ÓõÄÃüÁîºÍº¯Êý£¬×ö¸öÕûÀí£¬ÒÔ±¸ÒÔºóÓõ½£¬·½±ã²éÔÄ¡£
³£ÓÃÃüÁ
Á¬½Ósqlplus
ÃüÁîÐÐÏÂÔËÐÐcmd½øÈ룬ÈçÒÔsysģʽµÇ½£¬ÃüÁîÈçÏ£º
(1).sqlplus "sys/zhb126 as sysdba"
(2).sqlplus/nolog connect sys/zhb126 as sysdba
(3).sqlplus scott/tiger
Æô¶¯Êý¾Ý¿âʵÀý
startup --Æô¶¯Êý¾Ý¿âµÄͬʱÆô¶¯¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ
startup mount --Æô¶¯Êý¾Ý¿âµÄͬʱÆô¶¯¿ØÖÆÎļþ¡¢²»Æô¶¯Êý¾ÝÎļþ
startup nomount --½öÆô¶¯Êý¾Ý¿âʵÀý£¬ÓÃÓÚ¿ØÖÆÎļþ¶ªÊ§Çé¿ö£¬´Ëʱ¿ØÖÆÎļþÎÞ·¨Æô¶¯
¹Ø±ÕÊý¾Ý¿âʵÀý
shutdown --Õý³£¹Ø±Õ£¨µÈ´ýËùÓÐÓû§¶Ï¿ªÁ¬½Óºó²ÅÄܹرգ©
shutdown immediate--½¨ÒéʹÓã¨ÆÈʹÓû§Ö´Ðе±Ç°SQLºóÁ¢¼´¶Ï¿ªÁ¬½Ó£©
shutdown transactional--£¨ÆÈʹÔÚµ±Ç°Óû§Ö´ÐÐÍêºóÁ¢¼´¶Ï¿ªÁ¬½Ó£©
shutdown abort--Ç¿Öƹرգ¨Ààdb2µÄdb2 stop force£©
²é¿´ÈÕÖ¾¹éµµ·½Ê½--ÓÃstartup mountÆô¶¯Êý¾Ý¿â
archive log list
ALTER DATABASE archivelog
ALTER DATABASE OPEN
²é¿´sqlplusÖ§³ÖµÄÃüÁî
help INDEX
½â³ýÓû§Ëø
ÒÔ°²×°oracleʱµÚÒ»²½ÉèÖõÄÓû§¿ÚÁîµÇ½£¨È磺sqlplus "sys/zhb126 as sysdba"£©ºóÖ´ÐÐ
alter user scott account unlock;
È»ºóÖ´ÐÐsqlplus scott/tiger£¬´Ëʱ»áÒªÇóÄãÐÞ¸ÄscottµÄпÚÁî¡£
ÉèÖÃÃüÁîÐÐÖ§³Ö¿Õ¸ñ
set sqlblanklines on
±äÁ¿Ìæ´ú--±äÁ¿Ìæ»»£¬Õâ¸ö¹ý³ÌÖ»°²ÅÅÒ»¸öÖ´Ðмƻ®£¬¿ÉÌá¸ßÖ´ÐÐЧÂÊ
SQL> select * from dept where deptno = &t;
ÊäÈë t µÄÖµ: 10
ÔÖµ 1: select * from dept where deptno = &t
ÐÂÖµ 1: select * from dept where deptno = 10
²é¿´»º³åÆ÷Ö´ÐйýµÄÃüÁî (list/l)
SQL> l
1* select * from dept where deptno = &t
SQL> l1
1* select * from dept where deptno = &t
»º³åÇøÎļþµÄ±£³Ö¡¢Ö´ÐÐ
SQL> save d:\test.sql --±£´æ»º³åÇøÎļþµ½Ö¸¶¨ÎļþÖÐ
ÒÑ´´½¨ file d:\test.sql
SQL> @d:\test.sql --Ö´Ðб£´æÎļþµÄSQL
²é¿´±í½
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
1.ϵͳ±äÁ¿º¯Êý
£¨1£©SYSDATE
¸Ãº¯Êý·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£·µ»ØµÄÊÇOracle·þÎñÆ÷µÄµ±Ç°ÈÕÆÚºÍʱ¼ä¡£
select sysdate from dual;
insert into purchase values
(‘Small Widget’,’SH’,sysdate, 10);
insert into purchase values
(‘Meduem Wodget’,’SH’, ......
1.ÔÚ±íÖ®¼ä´«ÊäÊý¾Ý
1£©ÀûÓÃINSERT´«ÊäÊý¾Ý
insert into test1 (select name2,age2 from test2);
´ÓÉÏÃæµÄ²Ù×÷¿ÉÒÔ¿´³ö£¬¿Éͨ¹ýSELECTÏòÒ»¸ö±íÖгÉÅúµØÌí¼ÓÊý¾Ý£¬µ«Ó¦×¢Ò⣺Êý¾ÝÀàÐÍÒªÒ»Ö£¬ËùÑ¡ÔñµÄÁÐÊýÓ¦Ò»Ö¡£´ËÓï¾äµÄÓï·¨¸ñʽÈçÏ£º
INSERT INTO table_name (
SELECT statement
) ;
2£©»ùÓÚÒÑÓÐµÄ±í½¨Á¢Ð ......
oracle ͬÒå´Ê synonym ΪÊý¾Ý¿â¶ÔÏó½¨Á¢Í¬Òå´Êºó,µ±dba¶ÔÊý¾Ý¿â¶ÔÏó(table,view,ÐòÁÐ)×öÁËÒ»¸ö¼òµ¥¸Ä¶¯Ö®ºó,ÈçÃû×Ö»òÕ߽ṹ¸Ä±ä,Ôò²»ÐèÒªÖØиü¸Ä²¢±àÒëÓ¦ÓÃ.ÔÚÊý¾Ý¿â×ÖµäÖÐÓж¨Òå,²»ÐèÒª½øÐÐÈκδ洢.
oracle±ðÃûalias,With as¡¡Éú³ÉÒ»¸öÁÙʱ±í£¬¶ÔÓÚ¸´ÔÓµÄÊý¾Ý²éѯ£¬¿ÉÒÔ¼õÉÙ×ÊÔ´ÏûºÄ¡¢Ìá¸ßÐÔÄÜ¡£9iÒýÈë¡£
with alias ......