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

oracleÖÐʹÓú¯ÊýË÷ÒýFBI

×÷Õß:ÂÞ´ú¾ù http://hi.baidu.com/luodaijun/
ʹÓûùÓÚº¯ÊýµÄË÷Òý(FBI)ʱ£¬ÐèÒªÏÈÉèÖóõʼ»¯²ÎÊýquery_rewrite_enabled=TRUE(ĬÈÏΪfalse)
¸Ã²ÎÊýÔÚinit.oraÀïÉèÖã¬ÒÔoracle 9i2ΪÀý£¬init.oraÎļþ·¾¶ÎªD:\oracle\admin\mydb\pfile,ÎÒÕâÀï°Ñoracle×°ÔÚDÅÌ£¬mydbÊÇÎÒµÄÊý¾Ý¿â.
--˳±ã˵˵£¬´´½¨º¯ÊýË÷ÒýµÄ·½·¨
Óбíemployee,°üº¬3¸ö×Ö¶Î id, op-date, qty    , ÕâÀïÎÒÃÇÐèÒª»ã×Üop_dateÿ¸öÔµÄÊý¾Ý
select to-char(op_date,'YYYY-MM') mon,sum(qty)
from employee
group by to-char(op_date,'YYYY-MM')
ÓÉÓÚÔÚop_dateÉÏʹÓÃÁËto_charº¯Êý£¬ËùÒÔ²»ÄÜʹÓÃË÷Òý
ÏÂÃæ´´½¨FBI»ùÓÚº¯ÊýµÄË÷Òý
create index idx_employee_opdate on employee(to_char(op_date,'YYYY-MM'))
ok,ÏÖÔھͿÉÒÔʹÓÃË÷Òý
˳±ã˵¾ä£¬Ê¹ÓÃË÷Òý£¬ÔںܶàÇé¿öϲ»ÊDzéѯÊý¾Ý×î¿ìµÄ·½·¨£¬
Ë÷Òý²éÕÒ£¬Ã¿´Î¶ÁÒ»¸öÊý¾Ý¿é£¬¶øÈ«±íɨÃ裬ÿ´Î¶Á¶à¸öÊý¾Ý¿é£¬ÕâÑù¿ÉÒÔ¼õÉÙ´ÅÅÌi/o
ÏàÐÅCBO,É÷ÓÃË÷Òý


Ïà¹ØÎĵµ£º

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
......

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü

ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES ......

´î½¨Oracle 10g Proc+VS2008¿ª·¢»·¾³

1¡¢ÏÂÔØ°²×°Microsoft Visual Studio 2008£º
     ÏÂÔØµØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyId=83C3A1EC-ED72-4A79-8961-25635DB0192B&displaylang=zh-cn£¬Õâ¸öÊÇ“Visual Studio 2008 רҵ°æ£¨90 ÌìÊÔÓð棩”¡£
     °²×°²½ÖèÂÔ¡£
2¡ ......

oracle union

select t.lot_number
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_item_id
where mi.segment1 like '101%' and mi.organization_id = 102
group by t.lot_number having count(*)=1 union
select t.lot_number||'x'
......

OracleÖÐΪʲôwhere rownum > 3 ²éÕÒ²»µ½Êý¾Ý£¿

²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1         ?   1
2         ?   2
3         ?   3
4&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ