oracle ´æ´¢¹ý³ÌʵÀý
/*²»´øÈκβÎÊý´æ´¢¹ý³Ì(Êä³öϵͳÈÕÆÚ)*/
create or replace procedure output_date is
begin
dbms_output.put_line(sysdate);
end output_date;
/*´ø²ÎÊýinºÍoutµÄ´æ´¢¹ý³Ì*/
create or replace procedure get_username(v_id in number,v_username out varchar2)
as
begin
select username into v_username from tab_user where id = v_id; --±äÁ¿¸³Öµ
exception
when no_data_found then
raise_application_error(-20001,'ID²»´æÔÚ!');
end get_username;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
´´½¨ÐµÄÓû§Ê±£¬ÒªÖ¸¶¨default tablespace£¬·ñÔòËü»á°Ñsystem±í¿Õ¼äµ±³É×Ô¼ºµÄȱʡ±í¿Õ¼ä¡£ÕâÑù×öÊDz»ÌᳫµÄ¡£¹À¼ÆÔÀ´´´½¨Ä³¸öÓû§µÄʱºòûÓÐÖ¸¶¨È±Ê¡±í¿Õ¼ä£¬¶øÏÖÔÚËüʹÓÃϵͳ±í¿Õ¼äµÄȨÏÞ±»DBA¸øÊÕ»ØÁË¡£
ÏÈÓõļòµ¥µÄ°ì·¨ÊÔÊÔ£¬Ò»°ãȱʡµÄORACLE°²× ......
Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......
declare cursor myCursor is select * from ±íÃû;
myRow myCursor%rowtype;
begin
open myCursor;
loop
fetch myCursor into myRow;
exit when myCursor%notfound;
--ÒªÖ´ÐеÄSQLÓï¾ä
end loop;
end; ......
¹ØÓÚSGAÉèÖõÄÒ»µã×ܽá
±¾×ܽ᲻Õë¶ÔÌØÀý£¬½ö¶Ô·þÎñÆ÷Ö»´æÔÚOS + ORACLE ΪÀý£¬Èç¹û´æÔÚÆäËûÓ¦ÓÃÇë×ÃÇ鿼ÂÇ
дÕâ¸öÒ²ÊÇÒòΪ½üÀ´ÕâÖÖÖظ´ÐÔµÄÎÊÌâ·¢ÉúµÄÌ«¶àËùµ¼ÖµÄ
Ê×ÏȲ»ÒªÃÔÐÅSTS,SG,OCP,EXPERT µÈ¸ø³öµÄÈκν¨Òé¡¢ÄÚ´æ°Ù·Ö±ÈµÄ˵·¨
»ù±¾ÕÆÎÕµÄÔÔòÊÇ£¬ data buffer ͨ³£¿ÉÒÔ¾¡¿ÉÄܵĴó£¬shared_pool_size ÒªÊÊ¶È ......