Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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)


Ïà¹ØÎĵµ£º

WEBLOGICÁ¬½ÓOracle RAC µÄ¸ºÔؾùºâ²âÊÔ


Òª½øÐÐѹÁ¦²âÊÔ£¬Öмä¼þʹÓÃWEBLOGIC 816
£¬Êý¾Ý¿â°æ±¾Îª11.1.0.6 RAC
£¬Ñ¹Á¦²âÊÔ¹¤¾ßΪLOADRUNNER 8.0
¡£²âÊÔµ¥ÊµÀýÓëRAC
»·¾³¸÷¸ö½ÚµãµÄ¸ºÔØÇé¿ö¡£
 
 
ÔÚWEBLOGIC
ÉÏÅäÖÃÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGIC
ÌṩµÄ¸ºÔؾùºâ²ßÂÔ£¬½«²¢·¢¾ùºâµÄ·Ö±ðµ½Á½¸ö½ÚµãÉÏ¡£
µ«ÊDzâÊÔ·¢ÏÖ£¬Ò»µ©ÔËÐÐ
ÁËÒ»¶Îʱ¼ä£¬ËùÓе ......

oracle mutex

An introduction to Mutexes in 10gR2
By Connie Green, Kumar Rajamani
from meetings with: Kumar Rajamani, Russell Green, Saureen Shah, Cecilia Gervasio and Connie Green
Introduction
This paper is intended as an introduction to mutexes.  It describes new concepts associated with mutexes, when ......

JDBCÁ¬²»ÉÏOracleÊý¾Ý¿âµÄ½â¾ö·½·¨

 ½â¾ö·½·¨£º
    1.  ÏÈ¿´¼¸¸öÅäÖÃÎļþ£ºlistener.ora   tnsnames.ora   sqlnet.ora
    sqlnet.ora-----×÷ÓÃÀàËÆÓÚlinux»òÕ߯äËûunixµÄnsswitch.confÎļþ£¬Í¨¹ýÕâ¸öÎļþÀ´¾ö¶¨ÔõôÑùÕÒÒ»¸öÁ¬½ÓÖгöÏÖµÄÁ¬½Ó×Ö·û´®.¼ÙÈçÎÒµÄsqlnet.oraÊÇÏ ......

oracle SQL·ÖÀà

ORACLE ÖÐSQL Óï¾ä´óÖ¿ÉÒÔ·ÖΪ4´óÀà
1.DQL£¨data quary language Êý¾Ý²éѯÓïÑÔ£©
Êý¾Ý²éѯÓïÑÔDQL»ù±¾½á¹¹ÊÇÓÉSELECT×Ӿ䣬from×Ӿ䣬WHERE×Ó¾ä×é³É
2.DDL£¨data definition language Êý¾Ý¶¨ÒåÓïÑÔ£©
CREATE
ALTER
DROP
RENAME
TRUNCATE
3.DML£¨data manipulation language Êý¾Ý²Ù×ÝÓïÑÔ£©
INSERT
UPDATE ......

oracle JOB

ÿÌì1µãÖ´ÐеÄoracle JOBÑùÀý
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X,
what => 'ETL_RUN_D_Date;',
next_date => to_date('2009-08-26 01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/24',
no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ