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

ADO+ORACLE´óÏÀÇë½ø

ÎÒÏÖÔÚÏëʵÏÖÒ»¸öÅжÏORACLEÖÐÒ»¸öÊÓͼÊÇ·ñ´æÔÚ£¬Èç¹û´æÔÚ¾Íɾ³ý¡£
ÔÚ³ÌÐòÖÐÎÒÕâÑùдµÄ:
try
 {
 #pragma region [ɾµôÀϵÄÊÓͼ]
  csSqlText.Format("SELECT COUNT(*) AS ÊÓͼ¼ÆÊý from SYS.ALL_VIEWS WHERE VIEW_NAME='%s';",csViewName);
  if (!dbcontroler.Connect_to((_bstr_t)m_csOracleConnectionText))  return;
  if (!dbcontroler.OpenRecordSet(csSqlText))  return;
  if ( dbcontroler.p_RecordSet->ADOEOF)   return;
  dbcontroler.p_RecordSet->MoveFirst();
  iViewCounter = dbcontroler.p_RecordSet->GetCollect("ÊÓͼ¼ÆÊý");
  if (iViewCounter > 0)
  {
   csSqlText.Format("DROP VIEW %s",csViewName);
   dbcontroler.UpDataDB(csSqlText);
  }
  dbcontroler.p_RecordSet->Close();
  dbcontroler.p_Connection->Close();
 }
 catch(_com_error e)
 {
  CString errorString;
  errorString.Format(_T("´ò¿ªÊý¾Ý¿â±í·¢ÉùÒì³£ £¬´íÎóÐÅÏ¢£º%s"),e.ErrorMessage());
  AfxMessageBox(errorString);
  return ;
 }
×ÜÊÇÌáʾÊÓͼ²»´æÔÚ¡£
µ«ÊÇ£¬ÎÒÖ±½ÓÔÚoracleÖÐÖ´ÐÐSELECT COUNT(*) AS ÊÓͼ¼ÆÊý from SYS.ALL_VIEWS WHERE VIEW_NAME='È¥Äê²úÁ¿';ÊÇ¿ÉÒԵġ£
ÕâʱΪʲô£¿ÈçºÎ²ÅÄÜÔÚ³ÌÐòÀïÃæÊµÏÖÊÓͼµÄɾ³ýÄØ£¿


Ïà¹ØÎĵµ£º

Oracleº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
        A         A      ZERO     ......

Oracle undo »Ø¹ö¶Î¹ÜÀí


ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1.  ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
      ¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
  http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2.  »Ø¹ö¶Î(»Ø¹ö ......

oracleÖÐÖ±½ÓÐ޸ıíÁеÄÃû³ÆºÍ˳Ðò

µ¼ÈëÊý¾ÝµÃʱºò£¬Óöµ½Ò»¸öÎÊÌ⣬Ïë°ÑÁÐÃû˳Ðò¸Ä±äһϡ£ÔÚÍøÉÏËÑË÷µ½ÕâÆªÎÄÕ£¬Ã»È¥ÊÔÑé¡£ÌùÉÏÀ´£¬ÒÔºóÓлú»áÊÔÑéÏ¡£
£¨http://www.im80hou.com/html/oracle/2009/0710/712.html£©
 
°´ÕÕ¹ØÏµÊý¾Ý¿âµÄÀíÂÛ£¬ÐÐÓëÁж¼ÊÇÎÞÐòµÄ£¬µ«ÔÚʵ¼ÊÓ¦ÓÃÖÐÓÐʱÐèҪȷ¶¨ÁеÄ˳Ðò¡£µ«ÔÚOracleÖУ¬Ò»µ©±í¶¨ÒåºÃ£¬ÔÙÏëÐÞ¸ÄÁеÄ˳Ðò¿ ......

oracle µÝ¹é

sqlÓï¾ä£º
select bid from t_branch c start with c.upbid  ='11000000'  connect by prior c.bid=c.upbid
˵Ã÷£º
1¡¢Í³¼ÆÄ³¸ö»ú¹¹ÏÂËùÓеÄ×ÓËï»ú¹¹¡£Èçͳ¼Æ±±¾©»ú¹¹ÏµÄ×ÓËï»ú¹¹£¬°üÀ¨£º³¯ÑôÇø»ú¹¹¡¢º£µíÓªÏú»ú¹¹¡¢¡¢¡¢ÇàÁúÇÅÏç»ú¹¹¡¢¡¢¡¢¡¢Ò»Ö±µ½×îµ×²ãµÄ»ú¹¹¡£
2¡¢upbidÊÇÖ¸Éϼ¶»ú¹¹µÄID¡£º£µíÇø»ú¹¹ID(b ......

oracleµÄ9¸öname

OracleµÄ9¸ö_name
2008-07-17 23:47
1¡¢db_name Êý¾Ý¿âÃû
¡¡¡¡SQL> connect xys/manager as sysdba
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> show user
¡¡¡¡USER Ϊ "SYS"
¡¡¡¡SQL> show parameter db_name
¡¡¡¡NAME TYPE VALUE
¡¡¡¡---- -------- ------------
¡¡¡¡db_name string test1
¡¡¡¡db_nameÊÇÊý¾Ý¿âµÄÃû×Ö£¬or ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ