oracleÐÐÁÐת»»
/*
ÔÚʵ¼ÊʹÓÃsql¹¤×÷ÖÐ×Ü»áÅöµ½½«Ä³Ò»ÁеÄÖµ·Åµ½±êÌâÖÐÏÔʾ.¾ÍÊÇ×Ü˵µÄÐÐÁÐת»»»òÕß»¥»».
±ÈÈçÓÐÈçÏÂÊý¾Ý:
ID NAME KECHENG CHENGJI
-- ---------- -------------------- -------
1 a ÓïÎÄ 80
2 a Êýѧ 70
3 b ÓïÎÄ 40
4 b Êýѧ 100
5 c ÓïÎÄ 90
6 c Êýѧ 92
ÄÇÄ©ÎÒÒªÇóÏÔʾµÄ½á¹ûÊÇ:
NAME YUWEN SHUXUE
---------- ---------------------- ----------------------
a 80 &n
Ïà¹ØÎĵµ£º
Checking kernel parameters
Checking for semmsl=250; found semmsl=250. Passed
Checking for semmns=32000; found semmns=32000. Passed
Checking for semopm=100; found semopm=32. Failed <<<<
Checking for semmni=128; found semmni=128.&nb ......
update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from ......
µ¥Öµº¯ÊýÔÚ²éѯÖзµ»Øµ¥¸öÖµ£¬¿É±»Ó¦Óõ½select£¬where×Ӿ䣬start withÒÔ¼°connect by ×Ó¾äºÍhaving×Ӿ䡣
(Ò»).ÊýÖµÐͺ¯Êý(Number Functions)
ÊýÖµÐͺ¯ÊýÊäÈëÊý×ÖÐͲÎÊý²¢·µ»ØÊýÖµÐ͵ÄÖµ¡£¶àÊý¸ÃÀຯÊýµÄ·µ»ØÖµÖ§³Ö38λСÊýµã£¬ÖîÈ磺COS, COSH, EXP, LN, LOG,
SIN, SINH, SQRT, TAN, and TANH Ö ......
ºÜ²»ÐÒ£¬½¨Á¢µÄ±í±»Ä³ÈËÎóɾÁË£¬£¬£¬
»¹ºÃ¿ÉÒÔͨ¹ýÕâÑù»Ö¸´¡£
select * from user_recyclebin where original_name like 'FINANCE_%' order by droptime desc;
FLASHBACK TABLE FINANCE_CASE_FEE_ITEM TO BEFORE DROP
¼´ËùÓÐdropµÄ±í¶¼ÔÚ user_recyclebin Õâ¸öoracle»ØÊÕÕ¾ÀïÃæµÄ£¬ÔÙͨ¹ýflashbackÃü ......