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

oracleѧϰ±Ê¼Ç£¨Ò»£©·ÖÏí

1¡¢»ù±¾Óï·¨
SELECT
from
WHERE
GROUP BY
HAVING
ORDER BY
SELECT:²éѯµÄ×Ö¶Î
1¡¢¿ÉÓÃ*±íʾËùÓÐ×ֶΡ£
2¡¢×Ö¶ÎÖ®¼äÓöººÅ·Ö¸î¡£
3¡¢¿ÉΪ×Ö¶ÎÆð±ðÃû Æä±ðÃû¿Éд³ÉSELECT AAAA¡£AA AS SS »ò AAAA¡£AA SS ¿ÉÊ¡ÂÔas
4¡¢¿ÉÖ±½Óд×Ö¶ÎÖµ£ºÈç SELECT AAAA¡£AA SS,'ÕÅÈý' NAME from ¡£¡£¡£
from:²éѯµÄ±íÃû
1¡¢±íÃû¼äÓöººÅ·Ö¸î
2¡¢¿ÉΪ±íÆð±ðÃû Æä±ðÃû¿Éд³É from AAAA AS T »ò from AAAA T ¿ÉÊ¡ÂÔas
WHERE:²éѯÌõ¼þ
º¯Êý£º
NVL
||
SYSDATE
3¡¢Á¬½Ó
Á¬½Ó£º×óÁª(+)
×ÔÁª¡¢ÄÚÁª¡¢ÍâÁª
4¡¢×Ó²éѯ£º
5¡¢ºÏ²¢Êý¾Ý£º
UNION
UNION ALL
6¡¢´¥·¢Æ÷£º
Àý×Ó1£º²åÈëÖ÷¼ü
CREATE OR REPLACE TRIGGER AA_
BEFORE INSERT ON AA
FOR EACH ROW
DECLARE
BEGIN
SELECT AA_SEQ.NEXTVAL INTO :NEW.AA from DUAL;
END AA_;
Àý×Ó2£º
CREATE OR REPLACE TRIGGER ADDB2B_GHDWUSER
AFTER INSERT ON B2B_GHDWUSER FOR EACH ROW
DECLARE
V_MENUID B2B_GHJBMENU.MENUID%TYPE;
_MENUID VARCHAR2(20);
CURSOR INSERTUMENU IS
SELECT A.MENUID from B2B_GHJBMENU A,XTGHDW B
WHERE A.JNAM = B.JB AND B.DWBM= :NEW.GHDWBM;
V_LXBM XTFBLX.LXBM%TYPE;
CURSOR INSERTLXBM IS
SELECT DISTINCT LXBM from XTFBLX;
BEGIN
OPEN INSERTUMENU;
FETCH INSERTUMENU INTO V_MENUID,_MENUID;
WHILE INSERTUMENU%FOUND LOOP
INSERT INTO B2B_USERMENU (USERBM,MENUID)
VALUES(:NEW.USERBM,V_MENUID);
FETCH INSERTUMENU INTO V_MENUID;
END LOOP;
CLOSE INSERTUMENU;
OPEN INSERTLXBM;
FETCH INSERTLXBM INTO V_LXBM;
WHILE INSERTLXBM%FOUND LOOP
INSERT INTO B2B_USERXX (USERBM,LXBM)
VALUES(:NEW.USERBM,V_LXBM);
FETCH INSERTLXBM INTO V_LXBM;
END LOOP;
CLOSE INSERTLXBM;
IF :OLD.SWBZ='2' AND :NEW.SWBZ = '0' THEN
BEGIN
SELECT TID,FUSED INTO L_ID,L_FUSED from RPC_CONTRAC WHERE HTBM = :NEW.HTBM AND HTLB <> '9';

IF L_FUSED=1 THEN
RAISE_APPLICATION_ERROR(-20005,'²»ÄÜɾ³ý!');
END IF;

DELETE RPC_CONTRACENTRY WHERE TID = L_ID;
DELETE RPC_CONTRAC


Ïà¹ØÎĵµ£º

hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/ ......

Oracle 92ºÍOracle10gÏÂÔØµØÖ·

Oracle 9iÆóÒµ°æ¹Ù·½ÏÂÔØ9.2.0.1.0
¼òµ¥ÃèÊö£º oracleµÄ¹Ù·½ÍøÕ¾£ºwww.oracle.com ÕâÀïÓÐoracleµÄ¸÷ÖÖ°æ±¾µÄÊý¾Ý¿â¡¢Ó¦Óù¤¾ßºÍȨÍþµÄ¹Ù·½Îĵµ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð­×÷¸÷ÖÖÓ¦ÓõÄÈí¼þ»ù´¡¼Ü¹¹¡£ÏµÍ³ÒªÇó£ºÊÊÓÃÓ²¼þ»·¾³ ÖÁÉÙÐèÒª512MÄڴ棻½»»»Çø£ºÒ»°ãÒªÇóÊÇÄÚ´æµÄÁ½±¶£¬ÖÁÉÙÒ ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......

OracleºÍSQL Server¡¢DB2Êý¾Ý¿â±È½Ï

¿ª·ÅÐÔ:
SQL Server   
    Ö»ÄÜÔÚwindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT serverÖ»ÊʺÏÖÐСÐÍÆóÒµ¡£¶øÇÒwindowsƽ̨µÄ¿É¿¿ÐÔ£¬°²È«ÐÔºÍÉìËõÐÔÊǷdz£ÓÐÏ޵ġ£Ëü²»ÏóunixÄÇÑù¾Ã¾­¿¼Ñ飬ÓÈÆäÊÇÔÚ´¦Àí´óÊý¾ÝÁ¿ ......

oracleÌØÊ⺯ÊýÓ÷¨

<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·­ÒëÖµ1,Öµ2,·­ÒëÖµ2,...Öµn,·­ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·­ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ