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

Çë½ÌÓйØOracleÍⲿ±íµÄ²Ù×÷ÎÊÌâ

ÎÊÌâÃèÊö£º
ÓÐÒ»¸öÎļþ£¬ÎÒͨ¹ýÍⲿ±í·ÃÎÊËü£¬Í¨¹ý¹Ø¼ü×ÖÕÒµ½ÆäÖÐÎÒÐèÒªµÄÊý¾Ý¡£
ÀýÈçͨ¹ý¹Ø¼ü×ÖÎÒÕÒµ½ÁË3ÌõÊý¾Ý£¬·Ö±ðÔÚÎļþµÄµÚ10¡¢15¡¢20ÐУ¬µ«ÊÇÎÒ²»µ«ÐèÒªÕâ3ÌõÊý¾Ý£¬»¹ÐèÒªÕâ3ÌõÊý¾ÝµÄÉÏÒ»ÌõÊý¾Ý£¬¼´ÎÒ×îÖÕÐèÒªµÚ9¡¢10£¬14¡¢15£¬19¡¢20Õâ6ÌõÊý¾Ý¡£

Ïëͨ¹ý¸øÍⲿ±íÔö¼ÓÒ»¸ö×ÔÔö³¤µÄID×ֶΣ¬À´¶¨Î»Ã¿ÌõÊý¾ÝµÄÐкţ¬µ«ÊÇûÑо¿³öÀ´Ôõô¸øÍⲿ±íÔö¼Ó×ÔÔö³¤ÁУ¬²»ÖªµÀÊÇ·ñÖ§³Ö£¿

´ó¼ÒÓÐûÓÐÆäËüºÃ·½·¨°¡£¿Ð»Ð»£¡



ÒýÓÃ


ÄãºÃ£¬ÎÒÔÙ²¹³äһϣ¬ÎÒµÄÍⲿ±íÖ»ÓÐÒ»ÁУ¬¶ÔÓ¦¾ÍÊÇÎļþµÄÿһÐУ¬²»ÄܽøÐзÖ×éºÍÅÅÐò¡£

ÄãµÄ·½·¨ºÃÏñ²»ÊÊÓùþ¡£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ