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

´Óoracle±íÖÐËæ»úÈ¡¼Ç¼£¬²úÉúËæ»úÊýºÍËæ»ú×Ö·û´®


1¡¢´Ó±íÖÐËæ»úÈ¡¼Ç¼
    select * from (select * from staff order by dbms_random.random)
    where rownum < 4
    ±íʾ´ÓSTAFF±íÖÐËæ»úÈ¡3Ìõ¼Ç¼
2¡¢²úÉúËæ»úÊý
        SELECT DBMS_RANDOM.RANDOM from DUAL;
        ²úÉúÒ»¸öÈÎÒâ´óСµÄËæ»úÊý
        SELECT ABS(MOD(DBMS_RANDOM.RANDOM,100)) from DUAL;
        ²úÉúÒ»¸ö100ÒÔÄÚµÄËæ»úÊý
        SELECT TRUNC(100+900*dbms_random.value) from dual;
        ²úÉúÒ»¸ö100¡«1000Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.value from dual;
        ²úÉúÒ»¸ö0¡«1Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.value(10,20) from dual;
        ²úÉúÒ»¸ö10¡«20Ö®¼äµÄËæ»úÊý
        SELECT dbms_random.normal from dual;
        NORMALº¯Êý·µ»Ø·þ´ÓÕý̬·Ö²¼µÄÒ»×éÊý¡£´ËÕý̬·Ö²¼±ê׼ƫ²îΪ1£¬ÆÚÍûֵΪ0¡£Õâ¸öº¯Êý·µ»ØµÄÊýÖµÖÐÓÐ68%ÊǽéÓÚ-1Óë+1Ö®¼ä£¬95%½éÓÚ-2Óë+2Ö®¼ä£¬99%½éÓÚ-3Óë+3Ö®¼ä¡£
3¡¢²úÉúËæ»ú×Ö·û´®
        SELECT dbms_random.string from dual;
        ·µ»ØÒ»¸ö³¤¶È´ï60¸ö×Ö·ûµÄËæ»ú×Ö·û´®¡£    £¨Î´ÊÔÑé³É¹¦£©
        select dbms_random.string('P',20) from dual;
        µÚÒ»¸ö²ÎÊý P ±íʾ printable£¬¼´×Ö·û´®ÓÉÈÎÒâ¿É´òÓ¡×Ö·û¹¹³É 
        µÚ¶þ¸ö²ÎÊý±íʾ·µ»Ø×Ö·û´®³¤¶È


Ïà¹ØÎĵµ£º

Linux(Centos5.4)Éϰ²×°oracle10gR2(10.2.1)

http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......

Oracle 11g SECUREFILES


Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB 
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£ 
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ 
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......

oracle ÎïÀíÊý¾Ý¿â½á¹¹

ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
   1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
   2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......

oracleÊý¾Ý¿âÖв鿴ËùÓбíSQL

select   table_name   from   user_tables;     //µ±Ç°Óû§µÄ±í  
   
  select   table_name   from   all_tables;     //ËùÓÐÓû§µÄ±í  
   
  select   table_name   from   dba_tables;   &n ......

SybaseÊý¾Ý¿âºÍoracleÊý¾Ý¿âÓ÷¨


1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
    exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
    exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ