¡¾×ª¡¿ OracleÈ«¾ÖË÷ÒýºÍ±¾µØË÷Òý
OracleË÷Òý·ÖÇøÔÓ̸
<> OracleÊý¾Ý¿âÖУ¬ÓÐÁ½ÖÖÀàÐ͵ķÖÇøË÷Òý£¬È«¾ÖË÷ÒýºÍ±¾µØË÷Òý£¬ÆäÖб¾µØË÷ÒýÓÖ¿ÉÒÔ·ÖΪ±¾µØÇ°×ºË÷ÒýºÍ±¾µØ·Çǰ׺Ë÷Òý¡£ÏÂÃæ¾Í·Ö±ð¿´¿´Ã¿ÖÖÀàÐ͵ÄË÷Òý¸÷×ÔµÄÌØµã¡£
È«¾ÖË÷ÒýÒÔÕû¸ö±íµÄÊý¾ÝΪ¶ÔÏó½¨Á¢Ë÷Òý£¬Ë÷Òý·ÖÇøÖеÄË÷ÒýÌõÄ¿¼È¿ÉÄÜÊÇ»ùÓÚÏàͬµÄ¼üÖµµ«ÊÇÀ´×Ô²»Í¬µÄ·ÖÇø£¬Ò²¿ÉÄÜÊǶà¸ö²»Í¬¼üÖµµÄ×éºÏ¡£
È«¾ÖË÷Òý¼ÈÔÊÐíË÷Òý·ÖÇøµÄ¼üÖµºÍ±í·ÖÇø¼üÖµÏàͬ£¬Ò²¿ÉÒÔ²»Ïàͬ¡£È«¾ÖË÷ÒýºÍ±íÖ®¼äûÓÐÖ±½ÓµÄÁªÏµ£¬ÕâÒ»µãºÍ±¾µØË÷Òý²»Í¬¡£
SQL> create table orders (
order_no number,
part_no varchar2(40),
ord_date date
)
partition by range (ord_date)
(partition Q1 values less than (TO_DATE('01-APR-1999','DD-MON-YYYY')),
partition Q2 values less than (TO_DATE('01-JUL-1999','DD-MON-YYYY')),
partition Q3 values less than (TO_DATE('01-OCT-1999','DD-MON-YYYY')),
partition Q4 values less than (TO_DATE('01-JAN-2000','DD-MON-YYYY'))
)
;
Table created.
SQL> create index orders_global_1_idx
on orders(ord_date)
global partition by range (ord_date)
(partition GLOBAL1 values less than (TO_DATE('01-APR-1999','DD-MON-YYYY')),
partition GLOBAL2 values less than (TO_DATE('01-JUL-1999','DD-MON-YYYY')),
partition GLOBAL3 values less than (TO_DATE('01-OCT-1999','DD-MON-YYYY')),
partition GLOBAL4 values less than (MAXVALUE)
)
;
Index created.
SQL> create index orders_global_2_idx
&n
Ïà¹ØÎĵµ£º
oracle°²È«
Óû§¹ÜÀí
DBAÊÚÓ費ͬÓû§²»Í¬È¨Àû£¬Ã¿¸öÓû§¿ÉÒÔÔÚÊÚȨ·¶Î§Äڻ£¬Èκγ¬Ô½È¨ÏÞ·¶Î§µÄ²Ù×÷¶¼ÊÓΪ·Ç·¨¡£
sysÓû§ ÍøÂç¹ÜÀíÔ± ÓµÓÐ×î¸ßȨÏÞ
conn sys/¿ÚÁî as sysdba;
systemÓû§ ±¾µØ¹ÜÀíÔ±
scottÓû§ ʾÀýÊý¾Ý¿â
½¨Á¢Óû§£º£¨±ØÐëÓµÓÐdbaȨÏÞ£©
Create User Óû§Ãû Identified by ¿ÚÁî [E ......
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 ......
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ¡£
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡ ......
PL/SQL
¿é½á¹¹
DECLARE
ÉùÃ÷²¿·Ö
BEGIN
¿ÉÖ´Ðв¿·Ö
EXCEPTION
Òì³£´¦Àí²¿·Ö
END;
Àý£º
Ê×ÏÈÎÒÃÇ¿´Ò»¸ö¼òµ¥Ö®Àý×Ó,ÏÂÃæÕâ¸öÀý×ÓÊÇͳ¼Æ´Ó1 ......
1.ÔÚɾ³ýÒ»¸ö±íÖеÄÈ«²¿Êý¾Ýʱ£¬ÐëʹÓÃTRUNCATE TABLE ±íÃû;ÒòΪÓÃDROP TABLE£¬DELETE * from ±íÃûʱ£¬TABLESPACE±í¿Õ¼ä¸Ã±íµÄÕ¼Óÿռ䲢δÊÍ·Å£¬·´¸´¼¸´ÎDROP£¬DELETE²Ù×÷ºó£¬¸ÃTABLESPACEÉϰÙÕ׵Ŀռä¾Í±»ºÄ¹âÁË¡£
¡¡¡¡
¡¡¡¡2.having ×Ó¾äµÄÓ÷¨
¡¡¡¡
¡¡¡¡having ×Ó¾ä¶Ô group by ×Ó¾äËùÈ·¶¨µÄÐÐ×é½øÐпØÖÆ,having ×Ó ......