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

ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
       ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
      
       ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
 
Óαê
       ¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐǰ¹ØÁª
&nb ......

¶ÁÈ¡oracle blob×Ö·û´®

OleDbConnectioncon=newOleDbConnection(cnnstr);
try
{
con.Open();
}
catch
{}
OleDbCommandcmd=newOleDbCommand(strSQL,con);
System.Data.OleDb.OleDbDataReaderdr=cmd.ExecuteReader();
while(dr.Read())
 
{
stringdd=dr["gggg"].ToString();
byte[]ooo=(byte[])dr["hhhh"];
stringstr;
str=Sys ......

Oracle SQL PLUS µÇ¼ Æô¶¯ ¹Ø±Õ


Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba"  ÒÔsysdbaÉí·ÝµÇ¼
 
c:\>sqlplus/nolog   ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
 
 
Æô¶¯ 
SQL>  startup    &nb ......

Ãâ°²×°Oracle¿Í»§¶ËʹÓÃPL/SQLÁ¬½ÓOracle


´ó¼Ò¶¼ÖªµÀ£¬ÓÃPL/SQLÁ¬½ÓOracle£¬ÊÇÐèÒª°²×°Oracle¿Í»§¶ËÈí¼þµÄ¡£ÓÐûҪÏë¹ý²»°²×°Oracle¿Í»§¶ËÖ±½ÓÁ¬½ÓOracleÄØ£¿
      ÆäʵÎÒÒ»Ö±ÏëÕâÑù×ö£¬ÒòΪÕâ¸ö¿Í»§¶ËʵÔÚÌ«ÈÃÈËÌÖÑáÁË£¡£¡£¡²»µ«»á°²×°Ò»¸öJDK£¬¶øÇÒ»¹»á°Ñ×Ô¼º·ÅÔÚ»·¾³±äÁ¿µÄ×îÇ°Ãæ£¬»áÔì³É²»Ð¡µÄÂé·³¡£
    &n ......

Oracle sysdate ʱ¼äÂýÁË£¡

×î½ü·¢ÏÖÒ»¸öÎÊÌ⣬һ¸ö9iÅÜÔÚredhat5µÄ£¬¾ÓÈ» select sysdate from dual  ³öÀ´µÄʱ¼äºÍʵ¼Êʱ¼ä²îÁ˼¸·ÖÖÓ£¬ÒòΪ»ùÓÚÕâ¸öoracleµÄϵͳʱ¼äÕýÈ·ÐÔ»¹ÊÇÓеãÒªÇóµÄ¡£ËùÒÔÖ»ÄÜ #date -s 2010-2-10 8:55:00  ÁË£¬ÔÙ#clock -w дÈëCOMS ×¢ÒâÐÞ¸Äʱ¼äµÃÔÚrootÏ¡£
ÔÚϵͳÆô¶¯Ê±£¬Linux²Ù×÷ϵͳ½«Ê±¼ä´ÓCMOSÖжÁµ½ÏµÍ³Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ