serverÓïÑÔת³ÉoracleÓïÑÔ - Oracle / ¿ª·¢
Çë¶®µÄ°ïæת»»Ï¡£¡£¡£¡£Ð»Ð»ÁË¡£¡£
//ÓÃÓÚ·ÀÖ¹Èճ̱êÌⳤ¶È³¬¹ýÊý¾Ý¿âÖÐÈճ̱êÌâ×ֶεÄ×î´ó³¤¶È£¬Èç¹û³¬¹ý£¬½ØÈ¡ÔÊÐíµÄ×î´ó³¤¶ÈÊýÁ¿µÄ×Ö·û×÷Ϊ±êÌâ
public void CheckTitle()
{
Title.Trim();
if (Title.Length>=MaxTitleLength)
{
Title=Title.SubString(0,MaxTitleLength);
}
}
ÔΣ¬·¢´íÁË¡£¡£
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:
update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......