Oracle Function
CREATE OR REPLACE FUNCTION OFFICE.fbill_getbalance (billid NUMBER, total NUMBER)
RETURN NUMBER
IS
paid NUMBER;
balance NUMBER;
BEGIN
balance := total;
--get total paid
SELECT SUM (n_paidamount)
INTO paid
from tbnk_payoutbillconn i
WHERE i.n_billid = billid AND i.s_billorpur = 'B';
--get balance of bill
balance := NVL (total, 0) - NVL (paid, 0);
RETURN balance;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
RETURN balance;
WHEN OTHERS
THEN
RETURN balance;
RAISE;
END fbill_getbalance;
Ïà¹ØÎĵµ£º
oracle 10g
°²×°Íê³Éºó,
怫EM
ÊäÈëϵͳÓû§ÃûºÍÃÜÂëºÍÊý¾Ý¿âÓû§ÃûºÍÃÜÂëºó,
µãÆô¶¯±¨´í,
¿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ,
ʼÖÕÎÞ·¨µÇ½½øEM
µÄ½â¾ö°ì·¨......
×´¿ö£º
´ò¿ªhttp://ty-:5500/em
£¬ÏµÍ³ÏÔʾÈçÏÂÐÅÏ¢£º
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ ......
±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......
Í£Ö¹Êý¾Ý¿â£¬Í£Ö¹·þÎñ¡£
È»ºóÔÚÔËÐÐÉý¼¶³ÌÐòʱ³öÏÖError:OUI-10133:Invalid stageing area. there
are no top level components
´íÎ󣬰ëÌì²»µÃÆä½â¡£ÖÕÓÚ·¢ÏÖÊÇÒòΪÉý¼¶°ü½âѹ²»ÍêÈ«Ôì³ÉµÄ¡£ÖØÐ¸´ÖÆÒ»·ÝÍêÕû½âѹ¹ýµÄ£¬Éý¼¶¡£OK. ......
¾°£ºÔÚwindows xp serverÉϰ²×°ÁËOracle 9.2.0.1£¬ÏÖʹÓÃp4547809_92080_WINNT.zip½«ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×î
Ðµİ²È«²¹¶¡April 2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©£¨ÏÂÔØp4547809_92080_WINNT.zipÍøÖ·£º
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip£©
£¨1£©¡¢Ñ¹Ëõ°üÃû³ÆÎª p45478 ......