ÔÚWindows 7Ï°²×°Oracle ½â¾ö·½·¨
Ê×ÏÈÕÒµ½Â·¾¶£º
E:\Oracle Enterprise_Standard Edition_11.1.0.7\database\stage\prereq\db\refhost.xml
ÈçϽڵ㣺
<!--Microsoft Windows Vista-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.0"/>
</OPERATING_SYSTEM>
°ÑÉÏÊö½ÚµãÌ滻ΪÒÔϽڵ㣺
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
Ïà¹ØÎĵµ£º
ת×Ô£º http://blog.csdn.net/kongqz/archive/2009/05/15/4184415.aspx
¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º s ......
Ò»£®¼òµ¥SQL²éѯ£º
1£©:ͳ¼Æÿ¸ö²¿ÃÅÔ±¹¤µÄÊýÄ¿
select dept,count(*) from employee group by dept;
2£©:ͳ¼Æÿ¸ö²¿ÃÅÔ±¹¤µÄÊýÄ¿´óÓÚÒ»¸öµÄ¼Ç¼
select dept,count(*) from employee group by dept having count(*)>1;
3£©:ͳ¼Æ¹¤×ʳ¬¹ý1200µÄÔ±¹¤ËùÔÚ²¿ÃŵÄÃû³Æ
select e.first_name,salary,d.name
from s_emp ......
ÊÓͼµÄ¸ÅÄî
ÊÓͼÊÇ»ùÓÚÒ»Õűí»ò¶àÕűí»òÁíÍâÒ»¸öÊÓͼµÄÂß¼±í¡£ÊÓͼ²»Í¬ÓÚ±í£¬ÊÓͼ±¾Éí²»°üº¬ÈκÎÊý¾Ý¡£±íÊÇʵ¼Ê¶ÀÁ¢´æÔÚµÄʵÌ壬ÊÇÓÃÓÚ´æ´¢Êý¾ÝµÄ»ù±¾½á¹¹¡£¶øÊÓͼֻÊÇÒ»ÖÖ¶¨Ò壬¶ÔÓ¦Ò»¸ö²éѯÓï¾ä¡£ÊÓͼµÄÊý¾Ý¶¼À´×ÔÓÚijЩ±í£¬ÕâЩ±í±»³ÆΪ»ù±í¡£Í¨¹ýÊÓͼÀ´²é¿´±í£¬¾ÍÏñÊÇ´Ó²»Í¬µÄ½Ç¶ÈÀ´¹Û²ìÒ»¸ö(»ò¶à¸ö)±í¡£
Ê ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO ......
1.1.1 °²×°OracleÊý¾Ý¿â·þÎñ¶Ë
°´ÕÕ°²×°Ïòµ¼£¬ÕýÈ·°²×°Oracle 9i¡£
°´ÕÕĬÈÏÑ¡Ïµã»÷ÏÂÒ»²½£¬¼´¿É¡£
ͼ 2 2 Oracle °²×°Ïòµ¼ - »¶ÓʹÓÃ
ͼ 2 3 Oracle °²×°Ïòµ¼ - Îļþ¶¨Î»
ÕâÀÐè×¢ÒâOracleµÄ°²×°Îļþ·¾¶²»ÄÜ°üº¬¿Õ¸ñºÍÖÐÎÄÃû¡£Ä¬ÈÏ°²×°Â·¾¶ÊÇD:\oracle\ora92,ÕâÀィÒéʹÓÃÕâ¸ö°²×°Â·¾¶¡££¨°²×°£© ......