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

Oracle Çå³ýÒÑɾ³ý°ü(´øºì²æµÄ)


ÉÏͼÏÔʾ£ºÔõÑù°ÑÒѾ­²»´æÔڵİü³¹µ×ɾ³ý£¬Ëü´ø¸öºì²æ¡£ÔõÑù°ÑËü´ÓPackagesÎļþ¼ÐÀï³¹µ×ɾ³ýµô¡£Ð»Ð»´ó¼ÒÀ²¡£
commit£¬È»ºórefresh¡£¡£ÄãÕâ¸öºÃÏñij¸ö¹¤¾ß°É£¿

Ë¢ÐÂÒ»ÏÂ



ÔÚ°üÉÏÓÒ»÷£¬É¾³ý£¬ÔÚË¢ÐÂÒ»ÏÂ..


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

´ÓͼƬÉÏÌáʾµÄÀ´¿´£¬ºÃÏñ¸Ã°üÒѾ­±»¸ÉµôÁËѽ£¡£¡

ÏòÂ¥ÉÏ3λ˵µÄÄÇÑùÊÔÊÔ¡£
²»Ðеϰ£¬ÔÚsqlÃüÁîÐÐÏÂÔÚdropһϸðü¿´¿´¡£
drop package package_name;

ÎҵIJÙ×÷: °üÃûÓÒ¼ü Drop »ò drop package ½á¹ûÈçͼÏÔʾ¡£¡£¡£

ÎÒÓõÄÊÇ PLSQL Developer¡£¡£¡£

ÏÖÔÚ»¹ÊÇÏÔʾºì²æÂð£¿

½¨ÒéÄãͨ¹ýsqlplusÁ¬½Óµ½Êý¾Ý¿âÉÏÈ¥£¬È»ºóͨ¹ýÃüÁî
drop package package_name;
ÊÔÊÔ¡£

Èç¹û¶¼²»ºÃʹµÄ£¡½¨ÒéÓãӣù£óÁ¬½ÓÉϣϣţͣ¬È»ºóɾ³ý£¡ÎÒÒ²Óöµ½¹ýÕâ¸öÎÊÌ⣡


ºÜÉÙÓõ½°ü£¬°ï¶¥Ò»ÏÂÁË

¸ú×ÙÒ»ÏÂsql

alter session set events '10046 trace name context forever,level 12'

²é²éÊÇʲôÇé¿ö¡£

²»ÊÇÌáʾ¶ÔÏó²»´æÔÚÁËô¡£ÒѾ­É¾³ýÁË£¬²»¹ý½çÃæ»¹Ã»Óиıä¹ýÀ´¡£

Ë¢ÐÂÏ£¬Èç¹û»¹´æÔÚ£¬¾Íµã»÷ÓÒ¼ü--ɾ³ý


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ