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

oracle²úÉúËæ»úÊý»ò×Ö·û´®

1 ´ÓÏÖÓеıíÖÐËæ»úÈ¡¼Ç¼
select * from (select st_base_id from t_base order by dbms_random.random) where rownum<=100; --Õâ¸öÊÇËæ»úÈ¡³ö100¸ö¼Ç¼¡£
2 ²úÉúËæ»ú×Ö·û´®
select dbms_random.string('u',100) from dual; --²úÉú´óд×Öĸ×é³ÉµÄ×Ö·û´®£¬'u'Ò²¿ÉÒÔд³É'U'
select dbms_random.string('l',100) from dual; --²úÉúСд×Öĸ×é³ÉµÄ×Ö·û´®£¬'l'Ò²¿ÉÒÔд³É'L'
select dbms_random.string('a',100) from dual; --²úÉú´óСд×Öĸ»ìºÏ×é³ÉµÄ×Ö·û´®£¬'a'Ò²¿ÉÒÔд³É'A'
select dbms_random.string('x',100) from dual; --²úÉú´óд×ÖĸºÍÊý×Ö»ìºÏ×é³ÉµÄ×Ö·û´®£¬'x'Ò²¿ÉÒÔд³É'X'
select dbms_random.string('p',100) from dual; --²úÉúÈκοɴòÓ¡³öÀ´µÄ×Ö·û×é³ÉµÄ×Ö·û´®£¬'p'Ò²¿ÉÒÔд³É'P'
3 ²úÉúËæ»úÊý
1£©ÕûÊý
select dbms_random.random from dual; --²úÉúÈÎÒâ´óСµÄËæ»úÕûÊý£¬·µ»ØÖµ·¶Î§Çø¼äÊÇ[-2^31,2^31)
select abs(mod(dbms_random.random,100)) from dual; --²úÉú·¶Î§Çø¼äΪ[0,100)µÄËæ»úÕûÊý
select abs(mod(dbms_random.random,1000)) from dual; --²úÉú·¶Î§Çø¼äΪ[0,1000)µÄËæ»úÕûÊý
select trunc(dbms_random.value(100,1000)) from dual; --²úÉú·¶Î§Çø¼äΪ[100,1000)µÄËæ»úÕûÊý
2£©·ÇÕûÊý
select dbms_random.normal from dual; --°´±ê×¼Õý̬·Ö²¼²úÉúËæ»úÊý£¬¸ÃÕý̬·Ö²¼±ê׼ƫ²îΪ1£¬ÆÚÍûֵΪ0¡£Õâ¸öº¯Êý·µ»ØµÄÊýÖµÖÐÓÐ68%ÊǽéÓÚ-1Óë+1Ö®¼ä£¬95%½éÓÚ-2Óë+2Ö®¼ä£¬99%½éÓÚ-3Óë+3Ö®¼ä¡£
select dbms_random.value from dual; --²úÉú·¶Î§Çø¼äΪ[0,1)µÄËæ»úÊý£¬ÓÐЧÊý×ÖΪ38λ
select dbms_random.value(100,1000) from dual; --²úÉú·¶Î§Çø¼äΪ[100,1000)µÄËæ»úÊý
 ×ª×ÔÆäËûÍøÕ¾


Ïà¹ØÎĵµ£º

Oracle lpad º¯Êý

Oracle lpad º¯Êý£º
°æÈ¨ÉùÃ÷£º×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://soysky.blogbus.com/logs/43623642.html
Oracle lpadº¯Êý½«×ó±ßµÄ×Ö·û´®Ìî³äÒ»Ð©ÌØ¶¨µÄ×Ö·û£¬ÆäÓï·¨¸ñʽÈçÏ£º
lpad( string1, padded_length [, pad_string ] )
ÆäÖУº
string1ÊÇÐèÒªÕ³Ìù×Ö·ûµÄ×Ö·û´®£»
padde ......

oracle°´Ê±¼ä²éѯ·­Ò³Ê±³öÏÖÓëÇ°ÃæÒ»Ò³ÖØ¸´Êý¾Ý

ÓÃhibernate²éѯ·Öҳʱ£¬·­Ò³ÏÔʾÖÐÓÐÉÙÁ¿¼Ç¼ÊÇÖØ¸´µÄ¡£ÒѾ­È·ÈÏsqlд·¨Ã»´íÎó¡£
select savebillin0_.*,entityacct2_.*
from save_bill_info savebillin0_,
CUST_INFO custinfo1_,
entity_acct_bill entityacct2_
where savebillin0_.cust_id = custinfo1_.ID
and entityacct2_.ACCOU ......

oracle scnÑо¿

ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹ØÏµ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......

Oracle½«±íÊÚȨ¸øÓû§µÄÃüÁî

Oracle½«±íÊÚȨ¸øÓû§µÄÃüÁî
ÃüÁgrant  xxxȨÏÞ on TableA to USERA
grant select,insert,update,delete on ±íÃû to Óû§Ãû
ÀýÈ磺½«test±íµÄ²éѯȨÏÞ¸³ÓèsolidwangÕâ¸öÓû§
grant select on test to solidwang ......

WindowsÏÂÃüÁîÐÐÏÂÆô¶¯ORACLE·þÎñ


    * ¼ì²é¼àÌýÆ÷״̬£º
      C:\>lsnrctl status
      LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-6ÔÂ -2009 21:08
      :04
      Copyright (c) 1991, 2002, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ