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

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 ±íÁ¬½Ó·½Ê½½éÉÜ£¨SML + NL + HJ£©

JoinÊÇÒ»ÖÖÊÔͼ½«Á½¸ö±í½áºÏÔÚÒ»ÆðµÄν´Ê£¬Ò»´ÎÖ»ÄÜÁ¬½Ó2¸ö±í£¬±íÁ¬½ÓÒ²¿ÉÒÔ±»³ÆÎª±í¹ØÁª¡£ÔÚºóÃæµÄÐðÊöÖУ¬ÎÒÃǽ«»áʹÓÔrow source”À´´úÌæ”±í”£¬ÒòΪʹÓÃrow source¸üÑϽ÷һЩ£¬²¢ÇÒ½«²ÎÓëÁ¬½ÓµÄ2¸örow source·Ö±ð³ÆÎªrow source1ºÍrow source 2¡£Join¹ý³ÌµÄ¸÷¸ö²½Öè¾­³£ÊÇ´®ÐвÙ×÷£¬¼´Ê¹Ïà¹ØµÄr ......

²¿ÊðASP.NET·ÃÎÊoracleÌáʾÕÒ²»oracle¿Í»§¶Ë×é¼þÎÊÌâ

ǰÁ½Ì콫×Ô¼º±¾»úÆ÷ÖеÄASP.NETÓ¦Óò¿Êðµ½ÁË·þÎñÆ÷ÉÏ,½á¹û³öÏÖÁËЩÎÊÌâ.ÕÛÌÚÁËÁ½Ìì²Å¸ãÇå³þ.
Ê×ÏÈ·¢ÏÖ°²×°.NET3.5ʱºòÐèÒªÁ¬½ÓInternet,(Æäʵ°²×°°üÍêÕûµÄÀëÏß°²×°°ü)¶ø·þÎñÆ÷ÊÇÄÚ²¿ÍøÂçµÄ,ÿ°ì·¨Ö»Äܰ²×°Ò»¸öVS2008ÉÏÈ¥,Õæ²»Ã÷°×ΪºÎ°²×°VSʱºòdotNetFrameworkÓÖ²»ÐèÒªÁ¬½ÓInternetÁË.
ºóÀ´·¢ÏÖÔÚ±¾»úÆ÷ûÓÐÎÊÌâµÄÓ¦Óò¿ ......

SQLÃüÁî²éѯOracle´æ´¢¹ý³ÌÐÅÏ¢£¨´úÂëÄÚÈݵȣ©

SELECT * from ALL_SOURCE 
where TYPE='PROCEDURE'  AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......

Oracle Form開發(5) FormÏûÏ¢Ìáʾ

ºÃ¾Ã沒ÓÐ來寫Ïà關FormµÄÎÄÕÂÁË¡£
ÏÂÃæ給´ó¼ÒÊÕ¼¯Ò»ÏÂÏà關Oracle FormµÄÏûÏ¢Ìáʾ
 
FND_MESSAGE.SET_STRING(‘<Message>’)¡£
´ËÏûÏ¢Ò»¶¨Òª結ºÏFND_MESSAGE.SHOW»òFND_MESSAGE.ERROR»òFND_MESSAGE.HINT»òFND_MESSAGE.WARN»òFND_MESSAGE.QUESTIONʹÓòÅÄ ......

oracle ÎﻯÊÓͼ

ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï
¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
¡¡¡¡Oracle×îÔçÔÚOLAPϵͳÖÐÒýÈëÁËÎﻯÊÓͼµÄ¸ÅÄî¡£µ«ºóÀ´ºÜ¶à´óÐÍOLTPϵͳÖÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ