Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¡¢  &


Ïà¹ØÎĵµ£º

Oracle 10.1 Statistics

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 ......

oracleÖÐÖØÃüÃûÁÐÃûºÍ±íÃû

ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
   ALTER TABLE ±íÃû rename   column  ÁÐÃû to ÐÂÁÐÃû     ×¢ÒâcolumnÊǹؼü×Ö   /*ÖØÃüÃûÁÐÃû*/
  ALTE ......

Oracle¸üжàÐÐ

¸üжàÐе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 ......

Oracle´´½¨´¥·¢Æ÷

½ñÌìÔÚ°Ù¶ÈÉÏËÑË÷ÁËÏÂoracleдµÄ´¥·¢Æ÷£¬¸Ð¾õ»¹¿ÉÒÔ¡£
¾ÍÊղؿ©¡£
Óû§±í£º´´½¨´¥·¢Æ÷֮ǰÊ×ÏÈÒª´´½¨ÐòÁÐ
Óû§±íÐòÁУº
create sequence users_seq;
Óû§±í´¥·¢Æ÷£º
create or replace trigger bifer_users_userid_pk
before insert
on users
for each row
begin
select users_seq.nextval into:new.userid from ......

oracleÖ§³ÖµÄÊý¾ÝÀàÐÍ

³£ÓõÄÊý¾Ý¿â×Ö¶ÎÀàÐÍÈçÏ£º
×Ö¶ÎÀàÐÍ ÖÐÎÄ˵Ã÷ ÏÞÖÆÌõ¼þ ÆäËü˵Ã÷
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ