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
Ïà¹ØÎĵµ£º
ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......
<!--
@Name£º·ÖÀàͳ¼ÆÃ÷ϸ
@Time£º2010.01.05
@author JZP
--->
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page language="java" import="wfc.service.database.DB"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Resul ......
For win:
1¡¢Ð½¨Ò»¸öÅú´¦ÀíÎļþb.bat£¬¸ÃÎļþĿ¼ÏÂÒªÓÐexp.exeÎļþ
Åú´¦ÀíÎļþÄÚÈÝ£º
exp userid=user/passfile=i:\db%date:~0,10%.dmp log=i:\db%date:~0,10%.log
2¡¢Ð½¨ÈÎÎñ¹ØÁªb.batÎļþ¼´¿É¡£
For linux:
1¡¢Çе½oracleÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçb.sh £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ c ......
ʵ¼ùµÚÒ»½²£º
Ãû´Ê½âÊÍ£º
dataguard£ººÇºÇ ORACLE¸ß¿ÉÓÃÌåϵÖÐÈý¼ÜÂí³µÖ®Ò»£¨RAC¡¢STREAM£©¡£¸ÉÂïÓã¿£¿£¿¾ÍÊÇÒìµØ±¸·Ý¡¢ÈÝÔÖʲôµÄ¡£Ê²Ã´ÔÀí£¿£¿==ÁĹþ¡£
primary:Êý¾ÝĸÌå
standby:Êý¾ÝĸÌåµÄ¿½±´»ò±¸·Ý»ò¿Ë¡£¨Ö»ÄÜ¿Ë9¸ö Ϊʲô ÒªÎÊORACLE Ϊʲô log_archive_dest_n Õâ¸öÄãNµÄÉÏÏÞÊÇ10à¶£©
ʵ¼ùµÚ¶þ¼þ£º
ʵ¼ù¼ì ......
SunÖÕÓÚµ¹ÏÂÁË£¬Ò»¸ö²»µ«´´Ôì¼¼ÊõÉñ»°£¬¸øÊÀ½çIT¼¼Êõ´øÀ´¸ïÃüÐÔÓ°ÏìµÄ¹«Ë¾µ¹ÏÂÁË£¬ÎÒ»³ÄîËü¡£
ÎÒ¸öÈËÈÏΪORACLEºÍSUNµÄºÏ²¢£¬ÊÇÁ½¼Ò
¹«Ë¾µÄÐÒÊ£¬ORACLE½øÒ»²½ÍêÉÆÁ˲úÆ·Ïߣ¬²¢ÇÒ·ûºÏÁËĿǰSaaSºÍÔÆ¼ÆËãµÄÇ÷ÊÆ£¬³ÉΪһ¸öÔÚ²úÆ·ÏߺͷþÎñÉÏ¿ÉÒÔºÍIBM½øÐоºÕùµÄ¹«Ë¾£¬¶øSUNµÄ
¼¼Êõ¿ÉÄܻᱻORACLE¹«Ë¾µÄÓªÏúÄÜÁ¦·½·¨£¬Ê¹SUNµ ......