Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleµÄÊý¾Ý·ÖÇø

Êý¾Ý·ÖÇøÊÇÕë¶Ô±íµÄ¡£
ΪʲôҪ½«±í·ÖÇø£¿
·ÖÇø±íͨ³£´æ´¢ÔÚ½ÏСµÄÎļþ£¨<2GB£©ÖУ¬Ò×ÓÚ±¸·Ý¡£
Ó²¼þ¹ÊÕÏʱ£¬Ö»ÓÐÊý¾Ý¿âµÄһС²¿·Ö»áÊܵ½Ó°Ïì¡£
Ò×ÓÚÊý¾Ý·ÖÎö¡£
¿ÉÒÔÔÚÆäËû·ÖÇø¼ÌÐøÌṩ·þÎñµÄͬʱά»¤ÐèÒª½øÐÐά»¤µÄ±íµÄ·ÖÇø¡£alter table sale drop partition q1_1999;
»ùÓÚÁ¿³ÌµÄ·ÖÇø
¹Ø¼üÊÇÑ¡Ôñ·ÖÇø¼ü£¬ËüÓ¦¸Ã¿¼Âǵ½3¸öÒòËØ¡£
µ±Êý¾Ý´Ó·ÖÇø±íÖзµ»ØÊ±£¬¸ÃÁбØÐëÊÇSQLÓï¾äν´ÊµÄÒ»²¿·Ö¡£
ÁÐÖбØÐëÓÐ×ã¹»µÄ²»Í¬Öµ£¬¿ÉÒÔÓÃÀ´ÔÚ·ÖÇøÖ®¼ä²ð·ÖÐС£
Èç¹ûÈ·¶¨ÒѾ­ÓÐ×ã¹»µÄÖµ£¬ÄÇôÕâЩֵÖеÄÐзֲ¼±ØÐëÓÐÖúÓÚÆ½¾ùÐзֲ¼¡££¨Ê¹·ÖÇøµÄÊý¾ÝÁ¿ÒªÇ÷ͬ£©
create table miling (
    originator    varchar2(40),
    recipient      varchar2(40),
    message     varchar2(4000),
    created       date,
    delivered     varchar2(1),
    read            varchar2(1))
storage (initial 120m next 120m pctincrease 0)
partition by range(created)
(partition mailing_p01 values less than
                (to_date('01-JAN-2001', 'DD-MON-YYYY'))
                tablespace mailing_ts1,
  partition mailing_p02 values less than
                (to_date('01-JUL-2001', 'DD-MON-YYYY'))
                tablespace mailing_ts2,
  partition mailing_p03 values less than
                (to_date('01-JAN-2002', 'DD-MON-YYYY'))
                tablespace mailing_ts3,
  partition mailin


Ïà¹ØÎĵµ£º

²é¿´¡¢ÐÞ¸Äoracle×Ö·û¼¯£¬²é¿´oracle°æ±¾

1¡¢²é¿´Êý¾Ý¿â×Ö·û¼¯
Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯select * from nls_database_parameters£¬ÆäÀ´Ô´ÓÚprops$£¬ÊDZíʾÊý¾Ý¿âµÄ×Ö·û¼¯¡£
¡¡¡¡
¡¡¡¡¿Í»§¶Ë×Ö·û¼¯»·¾³select * from nls_instance_parameters,ÆäÀ´Ô´ÓÚv$parameter£¬
¡¡¡¡
¡¡¡¡±íʾ¿Í»§¶ËµÄ×Ö·û¼¯µÄÉèÖ㬿ÉÄÜÊDzÎÊýÎļþ£¬»·¾³±äÁ¿»òÕßÊÇ×¢²á±í
¡¡¡¡
¡¡¡¡»á»°×Ö·û¼¯» ......

Oracle ÖеÄUnion¡¢Union All¡¢Intersect¡¢Minus

ÖÚËùÖÜÖªµÄ¼¸¸ö½á¹û¼¯¼¯ºÏ²Ù×÷ÃüÁ½ñÌìÏêϸµØ²âÊÔÁËһϣ¬·¢ÏÖһЩÎÊÌ⣬¼Ç¼±¸¿¼¡£ ¼ÙÉèÎÒÃÇÓÐÒ»¸ö±íStudent£¬°üÀ¨ÒÔÏÂ×Ö¶ÎÓëÊý¾Ý£º drop table student;
create table student
(
id int primary key,
name nvarchar2(50) not null,
score number not null
);
insert into student values(1,'Aaron',78);
inse ......

Oracle È¡µÃµ±Ìì0ʱ0·Ö0ÃëºÍ23ʱ59·Ö59Ãë

--È¡µÃµ±Ìì0ʱ0·Ö0Ãë
select TRUNC(SYSDATE) from dual;
--È¡µÃµ±Ìì23ʱ59·Ö59Ãë(ÔÚµ±Ìì0ʱ0·Ö0ÃëµÄ»ù´¡ÉϼÓ1ÌìºóÔÙ¼õ1Ãë)
SELECT TRUNC(SYSDATE)+1-1/86400 from dual;
--È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢Ò⣺ÐÇÆÚÈÕÊǵÚÒ»Ìì
select to_char(sysdate,'D'),to_char(sysdate,'DAY') from dual;
--ÔÚoracleÖÐÈçºÎµÃ ......

ÓÃperl²éѯoracleÊý¾Ý¿âÖдæÔÚµÄlock

Ô­ÎĵØÖ·oracle lock
1ÓÃPerl TKÄ£¿é ²éѯDBÖеÄLOCK
use DBI;
use Tkx;
use DBD::Oracle qw(:ora_session_modes);
$mw = Tkx::widget->new(”.”);
$mw->g_wm_title(”Oracle Lock”);
$content = $mw->new_ttk__frame(-padding => “5 5 12 0″);
$content->g_grid ......

oracle´ó¶ÔÏó

ÔÚµ±½ñÍøÂçʱ´ú£¬ÎÒÃǶÔÊý¾ÝµÄ´æ´¢ÊÇÔ½À´Ô½¸ß£¬½ö½ö´æ´¢Ð¡ÐÍÎı¾Êý¾ÝÒѾ­Ô¶Ô¶²»¹»ÁË£¬ÏÖÔÚÊý¾Ý¿âÐèÒª´æ´¢Í¼Æ¬¡¢ÊÓÆµµÈµÈһЩ¶àýÌåµÄÄÚÈÝ£¬Òò´Ëoracle¸øÎÒÃÇÌṩÁËÒ»ÖÖ´óÀàÐÍÊý¾Ý¿â¶ÔÏóLOB(Large Object),¿ÉÒÔÓÃÓÚ´æ´¢´óÐÍÊý¾Ý¡£
Ò»¡¢´ó¶ÔÏóµÄ4ÖÐÊý¾ÝÀàÐÍ
CLOB       ×Ö·ûLOBÊý¾ÝÀàÐÍ£¬ÓÃÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ