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

ÓÐûÓÐwindowsÏÂÃæµÄoracle 10g¿Í»§¶Ë£¿

ÏÖÔÚÔÚÎҵijÌÐòÀïÃæÍ¨¹ý ocilibÀ´·ÃÎÊÁËÁíһ̨·þÎñÆ÷ÉϵÄoracleÊý¾Ý¿â¡£

ÄÇÔÚÎÒ»ú×ÓÉÏÒª±àÒë²âÊÔÕâ¸ö³ÌÐòµÄ»°£¬ÎÒÖÁÉÙҪװЩʲô£¿

ÎÒ²»Ïë×°ÄǸö600¶àMµÄ¶«Î÷£¬Ì«´óÁË£¬¶øÇÒ¶ÔÎÒÀ´ËµºÃ¶à¶«Î÷¶¼Ã»Óã¬ÒòΪÎÒ²¢²»ÔÚ±¾µØ´´½¨Êý¾Ý¿â¡­¡­


ÓÐûÓбȽÏСµÄһЩ¶«Î÷£¬¶øÇÒÓÃocilib¿â¿ÉÒÔ·ÃÎÊ

ÎÒÔõô²ÅÄÜÔÚ±¾µØ×°×îÉٵĶ«Î÷À´·ÃÎÊÔ¶µØµÄoracleÊý¾Ý¿â£º£¿£¿

лл£¡£¡£¡£¡
ÄǸöÖÁÉÙҪװsql net;
Èç¹ûÓÃdelphiд´úÂ룬¿ÉÒÔʹÓÃodac¿Ø¼þ£¬²»ÐèÒª°²×°¿Í»§¶Ë

Ö»ÐèÒªÌáÈ¡oralceÊý¾Ý¿âµÄ¼¸¸ö¶¯Ì¬¿â¾ÍÐÐÁË

¿Í»§¶Ë²»ÐèÒª°²×°oracleµÄ

Ŷ£¿

ÍøÉÏÓÐûÓÐÒѾ­´òºÃµÄ°üÌṩµÄ£¿

лл£¡

Ö±½Óplsqldevelop²»¾ÍÐÐÁË£¿


pl/sql¾ÍokÁË



Ŷ£¬Ð»Ð»~~~

Ã÷ÌìÈ¥¹«Ë¾ÊÔÒ»ÏÂ

:-) ÎÒÊdzõѧÕß

ÒýÓÃ
Ö±½Óplsqldevelop²»¾ÍÐÐÁË£¿



Õâ¸ö¾ÍºÜOKÁË

ÒýÓÃ
Ö±½Óplsqldevelop²»¾ÍÐÐÁË£¿


ÄܺÍ10g¼æÈݵÄÓÃ8°æ±¾ÒÔÉϵÄplsqldevelop

Èç¹û²»×°oracle¿Í»§¶ËµÄ»°£¬ÓÃpl/sqlû·¨Á¬½ÓÊý¾Ý¿âµÄѽ

ÌáʾûÓÐ×°¿Í»§¶Ë£¬囧

×°ÁËinstant clientºÍpl sql develop

µ«ÏÖÔÚÓÃpl sqlÁ¬½ÓµÄʱºò×ÜÊÇÌáʾÎÞ·¨Ê¶±ðÃèÊö·ûÖеÄÇëÇó

ÔÚÍøÉÏËÑÁËһϣ¬ËµÊÇtnsnames.oraµÄÎÊÌâ

µ«ÓÖ²»ÖªµÀÓ¦¸ÃÔõô¸Ä¡­¡­

лл´ó¼ÒÁË£¬ÒѾ­³É¹¦ÁË~~~

µ«ÎÒÔÚ³ÌÐòÀïÃæÓÃOCI_InitializeÀ´³õʼ»¯ocilib¿âµÄʱºò³ö´íÁË¡­¡­

ÕâÊÇΪʲô£¿

лл£¡


Ïà¹ØÎÊ´ð£º

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ