oracleÐÞ¸ÄÓû§Ãû
--sqlplus
sqlplus;
sys /password as sysdba;
--²éÕÒÓû§ID£¨user#£©,Êý¾Ý¿âÀïÃæ´æ·ÅµÄÓû§¶¼ÊÇ´óд!
select user#,name,password from user$ where name ='FACT';
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D67
-¸ù¾ÝÓû§ID ¸üÐÂÓû§Ãû¡£
update user$ set name= FACT where user#=91;
--Ìá½»¡£
commit;
--È·ÈÏÓû§ÃûÊÇ·ñ¸üгɹ¦¡£
select user#,name,password from user$ where USER# = 91;
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D673
--ÐÞ¸ÄÓû§ÃÜÂë¡£
alter user fact identified by fact;
--ÊÖ¹¤Ö´Ðмì²éµã²Ù×÷£¬½«Database Buffer CacheÖеÄÊý¾ÝÇ¿ÖÆд³öµ½Íâ´æ¡£
alter system checkpoint;
--Ç¿ÖÆË¢ÐÂShared Pool£¡ÒòΪOracleµÄÊý¾Ý×ÖµäÐÅÏ¢ÊÇ»º´æÔÚShared PoolµÄDictionary CacheÖеġ£
alter system flush shared_pool;
--È·ÈÏÃÜÂëÊÇ·ñÐ޸ijɹ¦¡£
select user#,name,password from user$ where USER# = 91;
USER# NAME PASSWORD
91 FACT 7A0F2B316C212D67
--²âÊÔÓû§ÊÇ·ñ¿ÉÓá£
conn fact/fact
Connected.
show user
USER is "FACT"
--ÖØÆôORACLE·þÎñ
Ïà¹ØÎĵµ£º
ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......
PL/SQL
¿é½á¹¹
DECLARE
ÉùÃ÷²¿·Ö
BEGIN
¿ÉÖ´Ðв¿·Ö
EXCEPTION
Òì³£´¦Àí²¿·Ö
END;
Àý£º
Ê×ÏÈÎÒÃÇ¿´Ò»¸ö¼òµ¥Ö®Àý×Ó,ÏÂÃæÕâ¸öÀý×ÓÊÇͳ¼Æ´Ó1 ......
IP µØÖ·×öÈçÏÂÐ޸ģº
Public IP 10.85.10.119/121 -- > 10.85.10.219/221
Privite IP 192.168.1.119/121 -- > 192.168.1.219/221
Virtual IP 10.85.10.122/123 -- ......
in/not inÔÚÅжÏNULLʱÓõÄÓë=/<>Ò»ÑùµÄ·½Ê½£¬¼´±ØÐëÓÃis nullÀ´Åжϣ¬·ñÔòʼÖÕΪʧ°Ü¡£
Óï¾ä
select 'true' from dual where (1,2) not in ((2,3),(2,null));
³É¹¦µÄÔÒòÔÚÓÚÅж϶þÔªÖµÊ±Ê ......
Òì³£
Ô¤¶¨ÒåÒì³£
oracleΪ³£¼û´íÎóÔ¤¶¨Òå
ÔÚDBMS_STANDARD³ÌÐò°üÖÐÌṩÁËÕâЩ¶¨Òå
²»ÐèÒªÏÔʾÉùÃ÷
declare
sex student.stu_sex%type;
begin
select stu_sex into sex from student;
dbms_output.put_line('sex:'||sex);
exception
&nbs ......