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

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 ÖеÄUnion¡¢Union All¡¢Intersect¡¢Minus

ÖÚËùÖÜÖªµÄ¼¸¸ö½á¹û¼¯¼¯ºÏ²Ù×÷ÃüÁ½ñÌìÏêϸµØ²âÊÔÁËһϣ¬·¢ÏÖһЩÎÊÌ⣬¼Ç¼±¸¿¼¡£ ¼ÙÉèÎÒÃÇÓÐÒ»¸ö±íStudent£¬°üÀ¨ÒÔÏÂ×Ö¶ÎÓëÊý¾Ý£º drop table student;
create table student
(
id int primary key,
name nvarchar2(50) not null,
score number not null
);
insert into student values(1,'Aaron',78);
inse ......

DB2ºÍORACLEµÄÓ¡Ïó±È½Ï

Ò»¸öÏîÄ¿ÐèÒªDB2£¬ÒÔǰûÓùý£¬ÓÃÁËWINDOWS 2008ϵÄDB29.7 ºÃ¼¸ÖÜ£¬ËãÈëÃÅÁ˰ɣ¬ÏÂÃæÕâÎÄÕ¾͵±Ò»¸öORACLEʹÓÃÕßÑÛÀïµÄDB2µÄÓ¡Ïó°É£¬Ò²ÐíÓÐЩ¶«Î÷¿ÉÄÜÓÐÆ«²î£¬µ«ÊǾÍÊÇÎÒ×Ô¼ºµÄÓ¡Ïó£º
1¡¢Ìåϵ½á¹¹£¬DB2µÄʵÀýºÍÊý¾Ý¿â·Ö¿ªµÄ×ö·¨£¬ÎÒ¸öÈË»¹ÊDZȽÏϲ»¶µÄ£¬ÒòΪʵÀý¿ÉÒÔ´´½¨¶à¸ö£¬Êý¾Ý¿âµÄ»Ö¸´Ö±½Ó»Ö¸´µ½ÊµÀýϾͿÉÒÔÁË£¬Ïà¶ ......

ORACLEÊý¾Ý¿â×Ô¶¯±¸·ÝÈÎÎñ

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 ......

oracleµÇ¼ÈÏ֤֪ʶ

ÀûÓÃosÉóºË
µÇ¼oracleʱÔÚWinÖÐʵÏÖ¶ÔosµÄÉóºËÓÐÈçϼ¸²½£º
1¡¢  create  os user id
2¡¢  create  os group   ora_dba(Õâ¸ö×éÖÐÓû§¾ßÓйÜÀíËùÓÐoracle database µÄȨÏÞ),
             ora_sid_dba£¨Ö»ÄܶÔÓ¦µ½ÏàÓ¦sidµ ......

oracle±Ê¼Ç


sqlplus sys/password  as sysdba;ϵͳ¹ÜÀíÔ±µÇ¼
alter user scott account unlock; ¸ü¸ÄÓû§
desc £¨±íÃû£©
select * from (table name);
select distinct ename from emp;
select ename,sal from emp;
select ename,sal*12 'annual_sal' from emp;
select ename,sal from emp where sal>1000;
select ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ