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

oracle_°Ù·Ö±È¼ÆËã

select round(sum(case when o.close_date is null then 1 else 0 end)/count(*),3)*100||'%'  SCALE from order o
˵Ã÷£ºÊ¹ÓÃsum¶ÔÒ»¶¨Ìõ¼þµÄÊý¾ÝÇóºÍºó£¬Óë×ÜÊý½øÐбȽϡ£
         ||'%' ÎªÒԵİٷֺÅÐÎʽÊä³ö½á¹û(Àý£º2%)


Ïà¹ØÎĵµ£º

oracle ²Ù×÷±íʾÀý

1.´´½¨±í£º
       a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
           Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
       b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracle ×Ô¶¯½¨¿â

Ê×ÏÈдºÃ½¨¿â½Å±¾c.sql
¡¡¡¡
¡¡¡¡create database mydb
¡¡¡¡controlfile reuse
¡¡¡¡maxinstances 1
¡¡¡¡maxloghistory 1
¡¡¡¡maxlogfiles 5
¡¡¡¡maxlogmembers 5
¡¡¡¡maxdatafiles 100
¡¡¡¡datafile '$ORACLE_HOME/oradata/system01.dbf'size 325M reuse
¡¡¡¡autoextend on next 10240K maxsize unlimited
¡¡¡¡u ......

OracleÖÐSQL PLUSµÄ³£ÓÃÖ¸Áî

½øÈësql*plusÐèÒªÊäÈëÓû§Ãû¡¢¿ÚÁîºÍÖ÷»ú±êÖ¾·û
system/manager
sys/change_on_intall
scott/tiger
internal/oracle
ÒÔÉÏΪ³õʼÃÜÂë
Ö÷»ú×Ö·û´®¿Õ»òÕßÊÇ@+ÄãµÄ·þÎñÃû,ÔÚ±¾µØµÇ½²»ÐèÒª±¾µØ·þÎñÃû¡£
ÏÂÃæ¾Í½éÉÜÒ»ÏÂһЩ³£ÓõÄsql*plusÃüÁ
Ê×ÏȲ鿴µ±Ç°Ê¹ÓõÄÊý¾Ý¿âʵÀý:
select name from V$database;
Çл»Á½¸ö ......

ת:ORACLE ¶à±í¹ØÁª UPDATE Óï¾ä


ת:ORACLE
¶à±í¹ØÁª UPDATE Óï¾ä
Ô­Ìû£ºhttp://www.cnblogs.com/miley/archive/2010/04/15/1712617.html
  ΪÁË
·½±ãÆð¼û
,½¨Á¢ÁËÒÔϼòµ¥Ä£ÐÍ
,ºÍ¹¹ÔìÁ˲¿·Ö²âÊÔÊý¾Ý
:
   ÔÚij¸öÒµ
ÎñÊÜÀí×Óϵͳ
BSSÖУ¬
  --¿Í»§×Ê
Áϱí
  create table customers
   (
 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ