OracleËæ»úº¯Êý—dbms_random
1.»ù´¡ÈÏʶ
DBMS_RANDOM°üµÄÏêϸÐÅÏ¢£º
select text from all_source
where name = 'DBMS_RANDOM'
and type = 'PACKAGE' order by line;
¡ô TYPE num_array
2.Ó¦ÓþÙÀý
SELECT DBMS_RANDOM.RANDOM from DUAL;
ÔÙ½øÒ»²½µÄÒªÇ󣬱ÈÈ磬²úÉúÒ»¸ö0£100µÄËæ»úÊý£¬ÉÔ΢±äͨһϾͿÉÒÔÁË£º
select abs(mod(dbms_random.random,100)) from dual
3.½ø½×˵Ã÷
dbms_randomÓÖÓÐк¯ÊýÁË¿ÉÒÔʵÏÖÕâЩ¹¦ÄÜ
FUNCTION value RETURN NUMBER;
FUNCTION value (low IN NUMBER, high IN NUMBER) RETURN NUMBER;
FUNCTION normal RETURN NUMBER;
FUNCTION string (opt char, len NUMBER) RETURN VARCHAR2;
²úÉúNµ½MÖ®¼äµÄËæ»úÊý
SELECT DBMS_RANDOM.VALUE(N,M) from DUAL;
ȱʡDBMS_RANDOM.VALUE·µ»Ø0µ½1Ö®¼äµÄËæ»úÊý
SQL> select dbms_random.value, dbms_random.value(55,100) from dual;
VALUE DBMS_RANDOM.VALUE(55,100)
--------------- -----------------------------
0.714469037747011 68.5593418279622
&n
Ïà¹ØÎĵµ£º
oracleÊý¾Ý¿âͬ²½
ÔÚÁ½Ì¨oracleÊý¾Ý¿âÖ®¼ä²âÊԳɹ¦£¬ÏÂÃæ¾Í×ܽáһϰɣº
ÐèÇó£º
ÏÖÓÐÁ½Ì¨oracleÊý¾Ý¿â·þÎñÆ÷AºÍB(A,B¿ÉÒÔÊÇÔÚͬһÄÚÍø£¬Ò²¿ÉÒÔÊÇÔÚ»¥ÁªÍøÉϵÄÁ½Ì¨¶ÀÁ¢»úÆ÷)¡£AºÍBÀïÓж¼ÓÐtestable±í£¬½á¹¹Ò»Ñù£¬ÏÖÐèÒªµ±A¿âÖеÄtestable±í±ä»¯Ê±£¬B¿âÀïµÄtestableÒ²ÏàÓ¦±ä»¯Êý¾Ý
ÎҵĽâ¾ö·½°¸£º
ÔÚAÖн¨Á¢µ½B¿âµÄ ......
[oracle@liwei admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:18 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
[oracle@liwei admin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10 ......
ÔÚµ±½ñÍøÂçʱ´ú£¬ÎÒÃǶÔÊý¾ÝµÄ´æ´¢ÊÇÔ½À´Ô½¸ß£¬½ö½ö´æ´¢Ð¡ÐÍÎı¾Êý¾ÝÒѾԶԶ²»¹»ÁË£¬ÏÖÔÚÊý¾Ý¿âÐèÒª´æ´¢Í¼Æ¬¡¢ÊÓƵµÈµÈһЩ¶àýÌåµÄÄÚÈÝ£¬Òò´Ëoracle¸øÎÒÃÇÌṩÁËÒ»ÖÖ´óÀàÐÍÊý¾Ý¿â¶ÔÏóLOB(Large Object),¿ÉÒÔÓÃÓÚ´æ´¢´óÐÍÊý¾Ý¡£
Ò»¡¢´ó¶ÔÏóµÄ4ÖÐÊý¾ÝÀàÐÍ
CLOB ×Ö·ûLOBÊý¾ÝÀàÐÍ£¬ÓÃÓ ......
µÚÒ»¿Î£º¿Í»§¶Ë
1. Sql Plus(¿Í»§¶Ë£©£¬ÃüÁîÐÐÖ±½ÓÊäÈ룺sqlplus£¬È»ºó°´ÌáʾÊäÈëÓû§Ãû£¬ÃÜÂë¡£
2. ´Ó¿ªÊ¼³ÌÐòÔËÐÐ:sqlplus£¬ÊÇͼÐΰæµÄsqlplus.
3. http://localhost:5560/isqlplus
Toad£º¹ÜÀí£¬ PlSql Developer:
µÚ¶þ¿Î£º¸ü¸ÄÓû§
1. sqlplus sys/bjsxt as sysdba
2. alter user scott account unlock;(½âËø)
......