ÓÐûÓÐ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¿âµÄʱºò³ö´íÁË¡¡ ÕâÊÇΪʲô£¿ лл£¡
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......