Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ë÷ÒýµÄ¼à¿Ø

×î½üµÄÑо¿·¢ÏÖ Oracle Êý¾Ý¿âËùʹÓõÄË÷Òý´ÓÀ´Ã»Óдﵽ¹ý¿ÉÓÃË÷ÒýÊýµÄ1/4£¬
»òÕ߯äÓ÷¨ÓëÆä¿ªÊ¼Éè¼ÆµÄÒâͼ²»Ïàͬ¡£Î´ÓõÄË÷ÒýÀ˷ѿռ䣬¶øÇÒ»¹»á½µµÍ DML
µÄËÙ¶È£¬ÓÈÆäÊÇ UPDATE ºÍ INSERT Óï¾ä;¿ØÊý¾Ý¿âË÷ÒýµÄʹÓã¬ÊÍ·ÅÄÇЩδ±»Ê¹ÓÃ
µÄË÷Òý£¬´Ó¶ø½Úʡά»¤Ë÷ÒýµÄ¿ªÏú£¬ÓÅ»¯sqlÐÔÄÜ
ÔÚ Oracle9i ֮ǰ£¬¼à¿ØË÷ÒýʹÓõÄÎ ......

´«ÖDz¥¿Í 2010 1 18Ê®Æß¡¢ORACLE(1)_°²×°Óë¹ÜÀí


Ò»¡¢Êý¾Ý¿âµÄÏà¹Ø¸ÅÄî
Êý¾Ý¿â£¨DB£©ÊÇÒ»¸ö°´Êý¾Ý½á¹¹À´´æ´¢ºÍ¹ÜÀíÊý¾ÝµÄ¼ÆËã»úÈí¼þϵͳ¡£
1¡¢Êý¾Ý¿â¹ÜÀíϵͳÓëÊý¾Ý¿âÓ¦ÓÃϵͳ
(1)Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨DBMS£©ÊÇרÃÅÓÃÓÚ¹ÜÀíÊý¾Ý¿âµÄ¼ÆËã»úϵͳÈí¼þ¡£Êý¾Ý¿â¹ÜÀíϵͳÄܹ»ÎªÊý¾Ý¿âÌṩÊý¾ÝµÄ¶¨Òå¡¢½¨Á¢¡¢Î¬»¤¡¢²éѯºÍͳ¼ÆµÈ²Ù ......

Oracle´æ´¢¹ý³ÌÓ﷨ѧϰ

´æ´¢¹ý³Ì´´½¨Óï·¨£º
 
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
       ........................
Exception
       ........................
End;
 
£¨2£©´ø ......

Oracle Spatail ÌØÀí´æ´¢½á¹¹

MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâÐ©×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ­´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ