´Ó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£¬¼´×Ö·û´®ÓÉÈÎÒâ¿É´òÓ¡×Ö·û¹¹³É
µÚ¶þ¸ö²ÎÊý±íʾ·µ»Ø×Ö·û´®³¤¶È
Ïà¹ØÎĵµ£º
http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......
µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......
SQLProgressÊÇÒ»¸öСÇɵIJÙ×÷Êý¾Ý¿âµÄ¹¤¾ß£¬ËùÓеİ汾¶¼²»³¬¹ý3M£¬°üÀ¨ÏÖÔÚ×îеÄ34°æ±¾¡£33ÒÔ¼°ÒÔǰµÄ°æ±¾ÐèÒª°²×°BDE²ÅÄÜÔËÐУ¬´Ó34¿ªÊ¼£¬Ö»Ö§³ÖOracleÊý¾Ý¿â£¬²ÉÓÃODAC×÷ΪÊý¾Ý¿â·ÃÎʵĽӿڣ¬Ö»ÐèÒªÒ»¸ö²»µ½3MµÄ¿ÉÖ´ÐÐÎļþ¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÆäËûʲô¶¼Óð²×°¡£¸Ã°æ±¾ÊÇÔÚSQLProgress1.01.33»ù´¡ÉÏÐ޸ĵģ¬33ÊÇBD ......
max_commit_propagation_delayĬÈÏֵΪ700£¬¼´7Ã루µ¥Î»0.01s£¬http://www.orafaq.com/parms/parm1217.htm£©¡£
Õâ¸ö²ÎÊýÓ¦¸ÃÅäÖõÄÊÇRAC£¨Real Application Cluster£©Ö®¼äͬ²½Êý¾ÝµÄƵÂÊ¡£ÐÞ¸ÄÕâ¸ö²ÎÊýµÄºÃ´¦¾Í²»ÓÃ˵ÁË£¨
±¾ÈËÉîÊÜÆä¿à°¡
£©£¬µ«ÊÇÈç¹û×ßÁíÒ»¸ö¼«¶Ë£¬¿ÉÄÜ»á¸øÊý¾Ý¿âÔì³É¸ü´óµÄѹÁ¦
²ÎÊýÖ¸¶¨Ò»¸öinstance ......
select table_name from user_tables; //µ±Ç°Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§µÄ±í
select table_name from dba_tables; &n ......