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

Oracle ·ÖÒ³´æ´¢¹ý³Ì ¼¸Ê®ÍòÌõ¼Ç¼

ºÃ³¤Ê±¼äûд¶«¶«ÁË£¬½ñÌìдÁËÒ»¸öoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬Ìù³öÀ´Óë´ó¼Ò·ÖÏí¡£
ÓÉÓÚ¡£net¿ò¼ÜÖеÄgridviewµÈ¿Ø¼þµÄ·ÖÒ³¹¦ÄÜÌ«Èõ£¬ËùÒԴ󲿷ֳÌÐòÔ±¶¼»á×Ô¼ºÐ´·ÖÒ³¹¦ÄÜ£¬¶øµ÷Ó÷ÖÒ³´æ´¢¹ý³ÌÊDZØÐëµÄ¡£
ǰ̨aspxÒ³Ãæ²»¹ÜÊÇÓÃÏÂÔØµÄdll»¹ÊÇÓÃ×Ô¼ºÐ´µÄÓû§¿Ø¼þ£¬¶¼ÄÜʵÏÖ×Ô¼ºµÄ¹¦ÄÜ£¬È»¶ø·ÖÒ³µÄ´æ´¢¹ý³Ì¾ÍÐèÒªºÃºÃµÄ¿¼ÂÇÁË£¬Ï±ßÊÇÎÒдµÄoracleµÄ´æ´¢¹ý³Ì£¨²Î¿¼sql serverÊý¾Ý¿âµÄ´æ´¢¹ý³Ìд³ÉµÄ£©£¬Ð§ÂÊ»¹¿ÉÒÔ£¬²¢¸½Éϵ÷ÊԵĹý³Ì£¨µ÷ÊÔ»·¾³£ºwin2003¡¢oracle 9i£¬µ÷ÊÔ¹¤¾ß£ºpl/sql£©£º
--I/OÏûºÄ1071
select id,orgid,dj_date,khid,khcode,khname,feeid from fee_ysfy;
--493408
select count(id) from fee_ysfy;
--22.391Ö´ÐÐÍê³É£¨ÄÚÍâ¶¼ÓÐorder by£©
select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         order by id desc)
 where rn <= 45
   and rn >= 30
 order by id desc
 --22.437£¨Ö»ÓÐ×Ó²éѯÓÐorder by£©
 select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         order by id desc)
 where rn <= 45
   and rn >= 30
--ÓÅ»¯È¥µôorder by0.891£¨È¥µôËùÓеÄorder by£©
select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         )
 where rn <= 45
   and rn >= 30
--½«order by·Åµ½Íâ±ß0.828Ã루°Ñorder by·Åµ½Íâ±ß£©
select id, orgid, dj_date, khid, khcode, khname, fee


Ïà¹ØÎĵµ£º

Red Hat Cluster Suite¼¯Èº OracleÊý¾Ý¿â


Ŀ¼
Ò»¡¢¸ÅÊö
¶þ¡¢Ó²¼þƽ̨´î½¨
Èý¡¢Redhat As4 update2°²×°ÅäÖÃ
ËÄ¡¢Oracle 10g°²×°ÅäÖÃ
Îå¡¢Red Hat Cluster Suite°²×°ÅäÖÃ
Áù¡¢ÏµÍ³Çл»²âÊÔ
Æß¡¢³£ÓÃÃüÁî
Ò»¡¢¸ÅÊö
»ÆµºÊпª·¢Çø²ÆÕþ¾Ö±¾´Î²ÉÓÃÁ½Ì¨IBM X3850£­8664·þÎñ
Æ÷¡¢
һ̨DS4300ÅÌÕ󣬯½Ì¨²ÉÓÃRedhat As4 update2 ½áºÏcluster suite£¬²¿ÊðOracle ......

oracleÖÐÈ¥ÖØ¸´¼Ç¼,²»ÓÃdistinct

ÓÃdistinct¹Ø¼ü×ÖÖ»ÄܹýÂ˲éѯ×Ö¶ÎÖÐËùÓмǼÏàͬµÄ£¨¼Ç¼¼¯Ïàͬ£©£¬¶øÈç¹ûÒªÖ¸¶¨Ò»¸ö×Ö¶ÎȴûÓÐЧ¹û£¬ÁíÍâdistinct¹Ø¼ü×Ö»áÅÅÐò£¬Ð§Âʺܵ͡£
select distinct name from t1 ÄÜÏû³ýÖØ¸´¼Ç¼£¬µ«Ö»ÄÜȡһ¸ö×ֶΣ¬ÏÖÔÚҪͬʱȡid,nameÕâ2¸ö×ֶεÄÖµ¡£
select distinct id,name from t1 ¿ÉÒÔÈ¡¶à¸ö×ֶΣ¬µ«Ö»ÄÜÏû³ýÕâ2¸ö×Ö¶ ......

oracleÆô¶¯·ÖÎö

oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read ......

³ÌÐò¿ª·¢: Oracle¸÷ÖÖÈÕÆÚ¼ÆËã·½·¨(ÊÕ²Ø)

Ò»¸öÔµĵÚÒ»Ìì
´úÂë (Ë«»÷´úÂë¸´ÖÆµ½Õ³Ìù°å)
SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')
from dual

sysdate ΪÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°ÏµÍ³Ê±¼ä¡£
to_char Êǽ«ÈÕÆÚÐÍתΪ×Ö·ûÐ͵ĺ¯Êý¡£
to_date Êǽ«×Ö·ûÐÍתΪÈÕÆÚÐ͵ĺ¯Êý£¬Ò»°ãʹÓà yyyy-mm-dd hh24:mi:ss¸ñʽ£¬µ±Ã»ÓÐÖ¸¶¨Ê±¼ä²¿·Öʱ£¬ÔòÄ ......

oracleÖØ½¨Ë÷Òý

Ö£ÖØËµÃ÷£º´ËÎÄÀ´×ÔÓÚÍøÂ磬ÈçÓÐÇÖȨÇë¸æÖ®£¡
µ¼¶Á£º
¡¡¡¡Öؽ¨Ë÷ÒýÓжàÖÖ·½Ê½£¬Èçdrop and re-create¡¢rebuild¡¢rebuild onlineµÈ¡£ÏÂÃæ¼òµ¥±È½ÏÕ⼸ÖÖ·½Ê½ÒìͬÒÔ¼°ÓÅȱµã£º
¡¡¡¡Ê×ÏȽ¨Á¢²âÊÔ±í¼°Êý¾Ý£º
¡¡¡¡SQL> CREATE TABLE TEST AS SELECT CITYCODE C1 from CITIZENINFO2;
¡¡¡¡Table created
¡¡¡¡SQL> ALTE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ