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

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²úÉúËæ»úÊý»ò×Ö·û´®

1 ´ÓÏÖÓеıíÖÐËæ»úÈ¡¼Ç¼
select * from (select st_base_id from t_base order by dbms_random.random) where rownum<=100; --Õâ¸öÊÇËæ»úÈ¡³ö100¸ö¼Ç¼¡£
2 ²úÉúËæ»ú×Ö·û´®
select dbms_random.string('u',100) from dual; --²úÉú´óд×Öĸ×é³ÉµÄ×Ö·û´®£¬'u'Ò²¿ÉÒÔд³É'U'
select dbms_random.string('l',100) from ......

Oracle±í¿Õ¼äºÍ±íµÄÇø±ð

ORACLEÎïÀíÉÏÊÇÓÉ´ÅÅÌÉϵÄÒÔϼ¸ÖÖÎļþ:Êý¾ÝÎļþºÍ¿ØÖÆÎļþºÍLOGFILE¹¹³ÉµÄ ±í¿Õ¼ä¾Í̸ֻÏà¹ØµÄÊý¾ÝÎļþ Ê×ÏÈÃ÷È·¸ÅÄî:±í¿Õ¼äÊÇORACLEÄÚ²¿¶¨ÒåµÄÒ»¸ö¸ÅÄî,ÊÇΪÁËͳһORACLEÎïÀíºÍÂß¼­ ÉϵĽṹ¶ø×¨ÃލÁ¢µÄ,´ÓÎïÀíÉÏÀ´Ëµ,Ò»¸ö±í¿Õ¼äÊÇÓɾßÌåµÄÒ»¸ö»ò¶à¸ö´ÅÅÌÉÏÊý ¾ÝÎļþ¹¹³ÉµÄ(ÖÁÉÙ1¶Ô1,¿ÉÒÔ1¶Ô¶à),´ÓÂß¼­ÉÏÀ´ËµÒ»¸ö±í¿Õ¼äÊ ......

ORACLE³£Óýű¾ÃüÁî

Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬ ......

ʹÓÃHibernate²åÈëoracle DateÀàÐ͵ÄÀý×Ó

package test;
import java.text.SimpleDateFormat;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import po.Stu;
public class Insert1 {
 /**
  * @param args
  */
 public ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨


1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ