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

ORACLE ·Ö×é ÅÅÐò³öÇ°Ãæ×î´óµÄNÐÐ

select  custid,carid,Cunote,INVNO,BUYPLAN  
from ( select custid,carid,Cunote,INVNO,BUYPLAN,
row_number() over(partition by custid,carid order by Feedbackid desc) rn
  from pvE3S.T_VCTM_CUSTOMER_FEEDBACK) t1 where rn=1
°´Feedbackid ÅÅÐò,rnÊÇǰNÐÐ


Ïà¹ØÎĵµ£º

java¶àÏ̱߳£´æoracleµÄblob×Ö¶ÎÔÚ±¾µØÉú³ÉͼÏñ

ǰЩÈÕ×ÓÕÛÌÚµÄÔÚÏßÅÄÕÕ£¬ÓÉÓÚÖ»ÊǸüÐÂblob×ֶΣ¬Ã»ÓÐÔÚ±¾µØ±£´æÕÕÆ¬£¬µ¼Ö¿ͻ§ÅÄÄÔÃÅÏëÒªµÄʱºò²»ÄÜÂíÉÏÄóöÀ´¡£Ã»ËµµÄË­Èù˿ÍÊÇÉϵÛÄØ£¬×ö°É¡£Ê¹ÓÃÏ̳߳ش´½¨Èý¸öÏß³ÌÈÃ×Ô¶¨Ò»¸öÏß³ÌÄ¿±ê¹²Ïí£¨Ò²¾ÍÊǰѱíÀïµÄ¼Ç¼·Ö³Én×éͬʱִÐе¼³ö£©¡£³ÌÐòºÜ¼òµ¥£¬Ò»¹²ËĸöÀàºÍÒ»¸öojdbc14.jar°ü¡£ÓÉÓÚsqlÓï¾äд´íÁËÔì³É¶à¸öÏ̶߳ÔÒ»¸ ......

ORACLE È¥³ýÖØ¸´¼Ç¼

      delete from tbl_talbe
      where (col1,col2,col3) in
     (select col1,col2,col3
       from tbl_table
       group by col1,col2,col3
   &nbs ......

Oracle:PL/SQL ÖÐÈçºÎʹÓÃArray

http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......

Oracle Sql¼¼ÇÉ Upsert, Multitable Insert, Undrop

UpSert¹¦ÄÜ£º
MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
WHEN NOT MATCHED THEN <insert_clause>;
MultiTable Inserts¹¦ÄÜ£º
Multitable inserts allow a single INSERT INTO .. SELECT statement to ......

Oracleº¯ÊýÖ®substr

Oracle
º¯
ÊýÖ®substr
¹Ø¼ü×Ö: substr

substrº¯ÊýÓÐÈý¸ö²ÎÊý£¬ÔÊÐíÄ㽫Ŀ±ê×Ö·û´®µÄÒ»²¿·ÝÊä³ö£¬
µÚÒ»¸ö²ÎÊýΪĿ±ê×Ö·û´®£¬
µÚ¶þ¸ö×Ö·û´®Êǽ«ÒªÊä³öµÄ×Ó´®µÄÆðµã£¬
µÚÈý¸ö²ÎÊýÊǽ«ÒªÊä³öµÄ×Ó´®µÄ³¤¶È¡£
    
Àý×Ó1£º
substr('ABCDEFG',   2,   3)   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ