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
Ïà¹ØÎĵµ£º
Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......
×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
http://www.oracle.com/technology/software/products/database/index.html
È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
Oracle Database 10g Release 2 ( ......
×î½üµÄÑо¿·¢ÏÖ Oracle Êý¾Ý¿âËùʹÓõÄË÷Òý´ÓÀ´Ã»Óдﵽ¹ý¿ÉÓÃË÷ÒýÊýµÄ1/4£¬
»òÕ߯äÓ÷¨ÓëÆä¿ªÊ¼Éè¼ÆµÄÒâͼ²»Ïàͬ¡£Î´ÓõÄË÷ÒýÀ˷ѿռ䣬¶øÇÒ»¹»á½µµÍ DML
µÄËÙ¶È£¬ÓÈÆäÊÇ UPDATE ºÍ INSERT Óï¾ä;¿ØÊý¾Ý¿âË÷ÒýµÄʹÓã¬ÊÍ·ÅÄÇЩδ±»Ê¹ÓÃ
µÄË÷Òý£¬´Ó¶ø½Úʡά»¤Ë÷ÒýµÄ¿ªÏú£¬ÓÅ»¯sqlÐÔÄÜ
ÔÚ Oracle9i ֮ǰ£¬¼à¿ØË÷ÒýʹÓõÄÎ ......
×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£ÔÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËÆºõ±äµÃÏ൱À§ÄÑ¡£¼¸¾ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
1¡¢ ±ÜÃâʹÓÃHibernate¿ò¼Ü
HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£
¹ØÓÚ²åÈ룺
......
Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æÎªhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......