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

Oracle ²Ù×÷º¯Êý

º¯Êý£º
 1.ʹÓÃCreate Function Óï¾ä´´½¨
 2.Óï
·¨£º
     Create or replace Function  º¯ÊýÃû[²ÎÊýÁбí]
     Return  Êý¾ÝÀàÐÍ
IS|AS
            ¾Ö²¿±äÁ¿
     Begin
            ¿ÉÖ´ÐÐÓï¾ä
    
end£»
 3.·ÃÎʺ¯Êý
    -ÓÃÁ½ÖÖ·½Ê½½øÐзÃÎÊ
        ʹÓÃPL/SQL¿é
       
ʹÓÃSQLÓï¾ä
    -½ö½ÓÊÜIn²ÎÊý
ʾÀý£º
 create or replace function
GetName(sNo varchar2)
 return  varchar Is  --²»ÄÜÖ¸¶¨¾«¶È
    name
varchar(12);
 Begin
    select ename into name from emp
   
where empno=sNo;
     return name;
 Exception
    when
Too_many_rows then
      DBMS_output.put_line('·µ»ØÖµ¶àÓàÒ»Ìõ');
    when
Others then
       DBMS_output.put_line('ÔÚÖ´Ðк¯ÊýGetNameʱ³öÏÖÒâÍâ´íÎó!');
 End;
/
µ÷ÓÃ
declare
 name varchar(12);
begin
  
name:=getname('7369');
   DBMS_output.put_line('½á¹ûΪ:'||name);
end;
/
Êý¾Ý×ֵ䣺user_source  
±àÒëʱ³ö´íµÄÊý¾Ý×Ö
µä£ºuser_errors;
»ò show errors£»
select * from user_source from where
name='GETNAME';  --×¢Òâ´óд
¹ý³ÌÓ뺯Êý
¹ý
³Ì                                                            º¯Êý
×÷Ϊ
PL/SQLÓï¾äÖ´ÐР           &nb


Ïà¹ØÎĵµ£º

ORACLE³ÌÐò°ü

³ÌÐò°ü
 
°üÖ÷Ìå/¹æ·¶Ãû×ÖÒ»Ñù
°üÖ÷Ìå/¹æ·¶ÖеĶÔÓ¦²ÎÊý±ØÐëÀàÐͼ°Ãû×ÖÒ»Ñù
Ö»ÄÜʹÓÃÇ¿ÀàÐ͵ÄREFÓαê
 
´´½¨³ÌÐò°ü¹æ·¶
create or replace package my_pack
is
       procedure find_emp_proc(eno emp.empno%type);
       function fin ......

vb Á¬½ÓoracleÊý¾Ý¿â

         
    Dim cn As ADODB.Connection
    Dim rs     As ADODB.Recordset
    Set cn = New ADODB.Connection
    cn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info= ......

Oracle µÄÊÓͼÓëË÷Òý


ÓбíA(×Ö¶ÎA1,A2)ºÍ±íB(×Ö¶ÎB1,B2).
×Ö¶ÎA2,B2É϶¼ÓÐË÷Òý.
A,B ±íÁª²é
sql1 Õâ¸ösql ·Ç³£¿ì 2ÃëµÄÑù×Ó
select * from A,B where A.A1=B.B1(+) and A2='Öµ1'
sql2 Õâ¸ösql Âýµ½ÈÃÈËÎÞ·¨ÈÌÊÜ
select * from A,B where A.A1=B.B1(+) and B2='Öµ1'
ÍâÁªÒÔºó ±íBÉϵÄË÷Òý²»Æð×÷ÓÃÁË.
Èç¹û»»³ÉÄÚÁª ËٶȺܿì.
sel ......

Oracle³£ÓÃϵͳ±í²éѯ

-- get all dictionary for oracle db
select * from dict;
--select * from dictionary;
-- get all columns for dictionarys
select * from dict_columns;
-- get the default name-space for current user
select username,default_tablespace from user_users;
-- get roles for current user
select * from us ......

Oracle SQLµÄÓÅ»¯

SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ»¯Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ