Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¿âµÄʱºò³ö´íÁË¡­¡­

ÕâÊÇΪʲô£¿

лл£¡


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ