ORACLE ÈçºÎ²úÉúÒ»¸öËæ»úÊý
ORACLE ÈçºÎ²úÉúÒ»¸öËæ»úÊý:DBMS_RANDOM
--1¡¢Ð¡Êý( 0 ~ 1)
select dbms_random.value from dual ;
--2¡¢Ö¸¶¨·¶Î§ÄÚµÄСÊý ( 0 ~ 100 )
select dbms_random.value(0,100) from dual ;
--3¡¢Ö¸¶¨·¶Î§ÄÚµÄÕûÊý ( 0 ~ 100 )
select trunc(dbms_random.value(0,100)) from dual ;
--4¡¢³¤¶ÈΪ20µÄËæ»úÊý×Ö´®
select substr(cast(dbms_random.value as varchar2(38)),0,10) from dual ;
--5¡¢Õý̬·Ö²¼µÄËæ»úÊý
select dbms_random.normal from dual ;
--6¡¢Ëæ»ú×Ö·û´®
select dbms_random.string('x', 3) from dual ;
/* opt¿ÉȡֵÈçÏ£º
'u','U' : ´óд×Öĸ
'l','L' : Сд×Öĸ
'a','A' : ´ó¡¢Ð¡Ð´×Öĸ
'x','X' : Êý×Ö¡¢´óд×Öĸ
'p','P' : ¿É´òÓ¡×Ö·û*/
--7¡¢Ëæ»úÈÕÆÚ
select to_date(2454084+TRUNC(DBMS_RANDOM.VALUE(0,365)),'J') from dual ;
/* ͨ¹ýÏÂÃæµÄÓï¾ä»ñµÃÖ¸¶¨ÈÕÆÚµÄ»ùÊý*/
select to_char(sysdate,'J') from dual ;
--8¡¢Éú³ÉGUID
select sys_guid() from dual ;
--Éú³É´ø·Ö¸ô·û(-)µÄGUIDµÄ×Ô¶¨Ò庯Êý
--create or replace function my_guid
return varchar2
is
guid varchar(36);
temp varchar(32);
begin
temp:=sys_guid();
guid:= substr(temp,1,8) || '-'
||substr(temp,9,4) || '-'
||substr(temp,13,4)|| '-'
||substr(temp,17,4)|| '-'
||substr(temp,21,12)
Ïà¹ØÎĵµ£º
1¡¢±¸·ÝÖ¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµçÄÔÉÏÓÐexp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐб¸·Ý¹¤×÷¡£
ÎÒÏëÒª±¸·ÝµÄÊÇÓû§ÃûΪcyyµÄ±í¿Õ¼ä£¬±¸·ÝÎļþ´òËã·ÅÔÚDÅÌ£¬²¢ÒÔbackup_oracle.dmpÃüÃû£¬Ë³±ã°ÑÈÕÖ¾ÎļþÒ²±¸·ÝһϺÃÁË¡£
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>exp cyy/cyy@bsrs file=D:\backup_oracle.dmp ......
Òª½øÐÐѹÁ¦²âÊÔ£¬Öмä¼þʹÓÃWEBLOGIC 816
£¬Êý¾Ý¿â°æ±¾Îª11.1.0.6 RAC
£¬Ñ¹Á¦²âÊÔ¹¤¾ßΪLOADRUNNER 8.0
¡£²âÊÔµ¥ÊµÀýÓëRAC
»·¾³¸÷¸ö½ÚµãµÄ¸ºÔØÇé¿ö¡£
ÔÚWEBLOGIC
ÉÏÅäÖÃÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGIC
ÌṩµÄ¸ºÔؾùºâ²ßÂÔ£¬½«²¢·¢¾ùºâµÄ·Ö±ðµ½Á½¸ö½ÚµãÉÏ¡£
µ«ÊDzâÊÔ·¢ÏÖ£¬Ò»µ©ÔËÐÐ
ÁËÒ»¶Îʱ¼ä£¬ËùÓе ......
¸ºÔؾùºâÊÇÖ¸Á¬½ÓµÄ¸ºÔؾùºâ¡£RAC
µÄ¸ºÔؾùºâÖ÷ÒªÊÇָлỰÁ¬½Óµ½RACÊý¾Ý¿âʱ£¬ÈçºÎÅж¨
Õâ¸öеÄÁ¬½ÓÒªÁ¬µ½Äĸö½Úµã½øÐй¤×÷¡£ÔÚRACÖУ¬¸ºÔؾùºâ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊÇ»ùÓÚ¿Í»§¶ËÁ¬½ÓµÄ£¬ÁíÍâÒ»ÖÖÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ¡£
Ò»¡¢¿Í»§¶Ë¸ºÔؾùºâµÄÅä
ÖÃ
1
¡¢µ±Ç°·þÎñÆ÷ÖеÄÊý¾Ý¿â°æ±¾ÈçÏ£º
SQL> select * from v$version
; ......
Oracle
ÖеÄÈÕÆÚÀàÐͼ°ÆäÏà¹ØµÄº¯Êý
Oracle
ÌṩÁ˺ܶàµÄÄÚÖõÄÈÕÆÚÀàÐÍ£¬°üÀ¨Èçϼ¸ÖÖ£º
Date
Timestamp
Timestamp With Time Zone
Timestamp With Local Time Zone
Interval Year To Month
Interval Day To Second
DateÀàÐÍÓÃÓÚ´æ´¢ÈÕÆÚ£¬¾«È·µ½Ã룬¿ÉÄÜͨ¹ýÉèÖÃNLS_DATE_FORMAT»òÕßTO_CHAR·½·¨À´¸ñʽ»¯ÈÕÆÚµÄÊ ......