Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬¼´×Ö·û´®ÓÉÈÎÒâ¿É´òÓ¡×Ö·û¹¹³É 
        µÚ¶þ¸ö²ÎÊý±íʾ·µ»Ø×Ö·û´®³¤¶È


Ïà¹ØÎĵµ£º

oracleѧϰ±Ê¼Ç2

ʹÓÃunrecoverable´´½¨±í
create table new_emp as select * from emp unrecoverable;
create table new_emp as select * from emp nologging; 
ÍÆ¼öʹÓÃlogging»òÕßnologging.
½«±íÒÆ¶¯µ½ÐµÄÊý¾Ý¶Î»òеıí¿Õ¼ä
ͨ¹ýÒÆ¶¯À´ÊµÏÖ´æ´¢²ÎÊýµÄÐÞ¸Ä
alter table emp move storage(initial 1m next 512k mimexte ......

Oracle expÏê½â

 µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼­ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼­¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......

ÉÐѧÌÃOracle¾­Ñé

×¢: ÕâÊǸöÈË¿´OracleÊÓÆµÊ±Ð´ÏµıʼÇ, ¶àÓдíÎó, Íû¸÷λÇÐÎðÁßϧ´Í½Ì.
 
1. Dos
ϵǽ³¬¼¶¹ÜÀíÔ±
£º
 

sqlplus sys/
ÃÜÂë
as sysdba
 
2.
¸ü¸Ä¹ÜÀíÔ±
£º
alter user scott account unlock;
 
3.
Êý¾ÝµÄ±¸·Ý
.
 
A
µ¼³ö
:
Cmd
ÏÂ
:       ......

SQLProgress 1.01.34 for Oracle Only

SQLProgressÊÇÒ»¸öСÇɵIJÙ×÷Êý¾Ý¿âµÄ¹¤¾ß£¬ËùÓеİ汾¶¼²»³¬¹ý3M£¬°üÀ¨ÏÖÔÚ×îеÄ34°æ±¾¡£33ÒÔ¼°ÒÔǰµÄ°æ±¾ÐèÒª°²×°BDE²ÅÄÜÔËÐУ¬´Ó34¿ªÊ¼£¬Ö»Ö§³ÖOracleÊý¾Ý¿â£¬²ÉÓÃODAC×÷ΪÊý¾Ý¿â·ÃÎʵĽӿڣ¬Ö»ÐèÒªÒ»¸ö²»µ½3MµÄ¿ÉÖ´ÐÐÎļþ¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÆäËûʲô¶¼Óð²×°¡£¸Ã°æ±¾ÊÇÔÚSQLProgress1.01.33»ù´¡ÉÏÐ޸ĵģ¬33ÊÇBD ......

Oracle ÖÐÈçºÎɾ³ýÖØ¸´Êý¾Ý

ÎÒÃÇ¿ÉÄÜ»á³öÏÖÕâÖÖÇé¿ö£¬Ä³¸ö±íÔ­À´Éè¼Æ²»ÖÜÈ«£¬µ¼Ö±íÀïÃæµÄÊý¾ÝÊý¾ÝÖØ¸´£¬ÄÇô£¬ÈçºÎ¶ÔÖØ¸´µÄÊý¾Ý½øÐÐɾ³ýÄØ£¿
ÖØ¸´µÄÊý¾Ý¿ÉÄÜÓÐÕâÑùÁ½ÖÖÇé¿ö£¬µÚÒ»ÖÖʱ±íÖÐÖ»ÓÐijЩ×Ö¶ÎÒ»Ñù£¬µÚ¶þÖÖÊÇÁ½ÐмǼÍêȫһÑù¡£
Ò»¡¢¶ÔÓÚ²¿·Ö×Ö¶ÎÖØ¸´Êý¾ÝµÄɾ³ý
ÏÈÀ´Ì¸Ì¸ÈçºÎ²éÑ¯ÖØ¸´µÄÊý¾Ý°É¡£
ÏÂÃæÓï¾ä¿ÉÒÔ²éѯ³öÄÇЩÊý¾ÝÊÇÖØ¸´µÄ£º
se ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ