oracle µÄÍêȫжÔØ
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾
Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
5¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\\SOFTWARE\\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
6¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services£¬¹ö¶¯
Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
7¡¢ ÔËÐÐrefedit£¬
HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\Eventlog\\Application£¬
ɾ³ýËùÓÐOracleÈë¿Ú¡£
8¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾ÏµÍ³££¾¸ß¼¶££¾»·¾³±äÁ¿
ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
9¡¢ ´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
10¡¢ ɾ³ý\\Program Files\\OracleĿ¼
11¡¢ ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
12¡¢ ɾ³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\\Oracle£¬É¾³ýÕâ¸öÈë
¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows 2000Ŀ¼£¨Ò»°ãΪC:\\WINNT£©ÏÂɾ³ýÒÔÏÂÎÄ
¼þORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ¡£
13¡¢ WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î
14¡¢ ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN
15¡¢ &
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Oracle 10.1 Statistics£º
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent ......
¸üжàÐеIJ½Ö裺
²½Öè¶à£¬µ«Ð§ÂʱȽϸߣº
1¡¢create table ÁÙʱ±í value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id)
2¡¢É¾³ýtable1ÖеļǼ£¬²»Òªdrop
3¡¢insert into table1 select ÄãÐèÒªµÄ×ֶΠfrom ÁÙʱ±í¡£
select * from tb_ai03
create table tb_ai031 as select * from tb ......
1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is: ......
²éѯijÁÐֵΪnullµÄ¼Ç¼£º
select *
from tablename
where col is null;
²éѯijÁÐÖµ²»ÎªnullµÄ¼Ç¼£º
select *
from tablename
where col is not null;
Õë¶ÔnullµÄ+-*/=!=µÈ²Ù×÷¶¼ÊÇnull£º
null±íʾ²»È·¶¨µÄÖµ£¬Á½¸önull±íʾÁ½¸ö²»È·¶¨µÄÖµ¡¢Î´ÖªµÄÖµ£¬Òò´Ë²»´æÔÚÁ½¸önullµÄÏàµÈ£¬Í ......