ÖØ°õÍÆ³ö£ºOracle¿Í»§¶Ë¾«¼òÂÌÉ«°æ
´óÐÍÏîÄ¿¿ª·¢ÖУ¬³£ÓõÄÊý¾Ý¿â£¬µ±ÊôOracle¡£µ«Oracle
¿Í»§¶Ë°²×°¾ÍÒªÒ»ÕŹâÅÌ£¬Ìå»ýºÜ´ó¡£¶øÇÒ°²×°ºó£¬»ù±¾ÉϾÍÓÃ2¸ö¹¦ÄÜ£ºTNSÅäÖ÷þÎñÃû£¬SqlPlus¡£ÔÚ¿ª·¢¹ý³ÌÖУ¬´óÁ¿Ê¹ÓÃToadºÍPL/SQL
Developer¡£Òò´Ë£¬Oracle¿Í»§¶Ë°²×°ÅÌ£¬½ö½öÊDZ»×÷Ϊһ¸öÇý¶¯¶øÐèÒª£¬¸ù±¾Ã»±ØÒª×°ÄÇô´óµÄ¿Õ¼ä¡£Òò´Ë£¬±¾Îĸø³öÁËÈçºÎʹÓþ«¼òµÄ
Oracle¿Í»§¶Ë¡£
ÎÒʹÓÃÁ½ÖÖ¾«¼òµÄOracle¿Í»§¶Ë£¬´ó¼Ò¿ÉÒÔÈÎÑ¡ÆäÒ»£º
Ò»¡¢Oracle 9i (°æ±¾: 9.0.1.0.1)¾«¼ò¿Í»§¶Ë ÂÌÉ«°æ
Õ¼ÓÃ35M¿Õ¼ä, ´øSqlPlus¹¤¾ß¡£ÂÌÉ«°æ£¬³¬¼¶ÍƼö£¡£¡£¡
ʹÓ÷½·¨£º
1. È·¶¨OracleHomeĿ¼£º±ÈÈçÎÒ×¼±¸°ÑOracle ¿Í»§¶Ë·ÅÔÚ d:\program files\Oracle ÏÂ
2. °Ñora90Ŀ¼¸´ÖƵ½d:\program files\Oracle Ŀ¼ÏÂ
3. Èç¹ûÄãµÄOracleHomeĿ¼ÓëÎҵIJ»Í¬£¬ÇëÓüÆÊ±¾´ò¿ªinstall_oracle9i.reg Îļþ£¬Ìæ»»d:\\progra~1\\Oracle£¬±£´æ¡£
4. Ë«»÷install_oracle9i.reg, µ¼Èë×¢²á±í¡£
5.
ÓüÆÊ±¾´ò¿ªD:\Program Files\Oracle\ora90\network\ADMIN\tnsnames.ora
Îļþ£¬Ôö¼ÓÒ»¸ö×Ô¼ºµÄÊý¾Ý¿â±ðÃûÅäÖÃ,±£´æ¡£ ¿ÉÒÔ¸´ÖÆÆäÖеÄÒ»¸ö£¬È»ºó½øÐÐÐ޸ģ¬Ö÷Òª¸Ä=Ç°ÃæµÄ±ðÃû£¬HostΪIPµØÖ·,
SERVICE_NAMEΪÊý¾Ý¿â·þÎñÆ÷µÄʵÀýÃû¡£
6. È»ºóÔËÐÐD:\Program Files\Oracle\ora90\BIN\sqlplusw.exe,ÊäÈëÓû§Ãû/ÃÜÂë@±ðÃû£¬¼´¿É¡£
Ð¶ÔØ·½·¨£º
1. Ë«»÷uninstall_oracle9i.reg, µ¼Èë×¢²á±í¡£
2. ɾ³ýd:\program files\Oracle Ŀ¼¡£
ÏÂÔØµØÖ·£º
[url]http://www.fs2you.com/zh-cn/files/fda64a07-0705-11dd-85d4-00142218fc6e/[/url]
¶þ¡¢Oracle 10g Instant Client
Oracle Instant Client ÊÇOracle ¹«Ë¾ÍƳöµÄ¾«¼ò°æ¿Í»§¶Ë£¬²»ÐèÒª°²×°£¬µ«ÐèÒª¼òµ¥ÅäÖÃһϡ£
ÏÂÔØµØÖ·£º
[url]http://www.oracle.com/technology/software/tech/oci/instantclient/index.html[/url]
ÎÒÏÂÔØµÄÊÇWin32ƽ̨ϵÄ10.2.0.3 Basic°æ±¾¡£Instant client ÓÐ2¸ö°æ±¾£ºBasicºÍBasic Lite¡£
Basic°æ±¾°üÀ¨ÁËËùÓеÄÖ§³ÖÔËÐÐOCI¡¢OCCI¡¢JDBC¡¢JDBC-OCIµÄÎļþ£¬Ö§³Ö¶àÖÖÓïÑÔ¡£
Basic LiteÊÇBasic°æ±¾µÄ¾«¼ò°æ£¬Ö»°üÀ¨ÁËÓ¢ÎĵĴíÎóÃèÊö£¬Ò²Ö»Ö§³ÖUnicode¡¢ASCIIºÍÅ·ÖÞ×Ö·û¼¯¡£
Òò´Ë£¬Èç¹ûÊý¾Ý¿â·þÎñÆ÷ÊÇÖÐÎÄ×Ö·û¼¯(Èç SIMPLIFIED CHINESE_CHINA.ZHS16GBK),Ôò±ØÐëÏÂÔØBasic°æ±¾¡£
Basic Lite Õ¼ÓÃ25M¿Õ¼ä£¬Basic Õ¼ÓÃ93M¿Õ¼ä¡
Ïà¹ØÎĵµ£º
LONEFOXÌâ¼Ç£º
×î½ü¸ãORACLE£¬ ת¹ýÀ´¹©²Î¿¼¡£
=================================
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û
ÓÃ;
Àý×Ó
+ -
±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿Éʡȥ +
-1234.56
+
½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó
A=c+b ......
ORACLEµ¼Èëµ¼³ö
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó£¨Í¨¹ýnet8 assistantÖб¾µØ-->·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû ÆäʵÄã¿É ......
1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......
ÓÃhibernate²éѯ·Öҳʱ£¬·Ò³ÏÔʾÖÐÓÐÉÙÁ¿¼Ç¼ÊÇÖØ¸´µÄ¡£ÒѾȷÈÏsqlд·¨Ã»´íÎó¡£
select savebillin0_.*,entityacct2_.*
from save_bill_info savebillin0_,
CUST_INFO custinfo1_,
entity_acct_bill entityacct2_
where savebillin0_.cust_id = custinfo1_.ID
and entityacct2_.ACCOU ......
ÎÒдµÄ½Å±¾£¬ÓеãÂý£¬½«¾Í×ÅÓðÉ
--kill sessionÓï¾ä
alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;
SELECT * from v$locked_object;
SELECT * from all_ ......