Oracle´æ´¢¹ý³ÌÓ﷨ѧϰ
´æ´¢¹ý³Ì´´½¨Óï·¨£º
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
........................
Exception
........................
End;
£¨2£©´ø²Î
create or replace procedure ´æ´¢¹ý³ÌÃû£¨param1 in type£¬param2 out type£©
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
Select count(*) into ±äÁ¿1 from ±íA whereÁÐÃû=param1£»
If (ÅжÏÌõ¼þ) then
Select ÁÐÃû into ±äÁ¿2 from ±íA whereÁÐÃû=param1£»
Dbms_output.Put_line(‘´òÓ¡ÐÅÏ¢’);
Elsif (ÅжÏÌõ¼þ) then
Dbms_output.Put_line(‘´òÓ¡ÐÅÏ¢’);
Else
Raise Òì³£Ãû£¨NO_DATA_FOUND£©;
End if;
Exception
When others then
Rollback;
End;
×¢ÒâÊÂÏ
1£¬ ´æ´¢¹ý³Ì²ÎÊý²»´øÈ¡Öµ·¶Î§£¬in±íʾ´«È룬out±íʾÊä³ö
2£¬ ±äÁ¿´øÈ¡Öµ·¶Î§£¬ºóÃæ½Ó·ÖºÅ
3£¬ ÔÚÅжÏÓï¾äÇ°×îºÃÏÈÓÃcount£¨*£©º¯ÊýÅжÏÊÇ·ñ´æÔÚ¸ÃÌõ²Ù×÷¼Ç¼
4£¬ ÓÃselect ¡£¡£¡£into¡£¡£¡£¸ø±äÁ¿¸³Öµ
5£¬ ÔÚ´úÂëÖÐÅ×Òì³£Óà raise+Òì³£Ãû
ÒÔÃüÃûµÄÒì³£
ÃüÃûµÄϵͳÒì³£ ²úÉúÔÒò
ACCESS_INTO_NULL 䶨Òå¶ÔÏó
CASE_NOT_FOUND CASE ÖÐÈôδ°üº¬ÏàÓ¦µÄ WHEN £¬²¢ÇÒûÓÐÉèÖÃ
ELSE ʱ
COLLECTION_IS_NULL ¼¯ºÏÔªËØδ³õʼ»¯
CURSER_ALREADY_OPEN ÓαêÒѾ´ò¿ª
DUP_VAL_ON_IN
Ïà¹ØÎĵµ£º
1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
select sys_context('userenv','ip_address') from dual; ......
OracleµÄµ¼ÈëʵÓóÌÐò(Import utility)ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£impʹÓõĻù±¾¸ñʽ£ºimp[username[/password[@service]]]£¬ÒÔÏÂÀý¾Ùimp³£ÓÃÓ÷¨¡£
1. »ñÈ¡°ïÖú
imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
imp system/manager file=bible_db log=dible_db full=y ignore=y
3. µ¼ÈëÒ»¸ö»òÒ»×éÖ¸¶¨ ......
1.Ê×ÏÈ˵Ã÷һϣº
ÔÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖƵÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔÀ´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ ......
º¯ÊýË÷ÒýµÄ¸ÅÄ
»ùÓÚº¯ÊýµÄË÷ÒýÒ²ÊÇ8iÒÔÀ´µÄвúÎËüÓÐË÷Òý¼ÆËãÁеÄÄÜÁ¦£¬ËüÒ×ÓÚʹÓò¢ÇÒÌṩ¼ÆËãºÃµÄÖµ£¬ÔÚ²»ÐÞ¸ÄÓ¦ÓóÌÐòµÄÂß¼ÉÏÌá¸ßÁ˲éѯÐÔÄÜ¡£Ê¹ÓûùÓÚº¯ÊýµÄË÷ÒýÓм¸¸öÏȾöÌõ¼þ£º
(1)
±ØÐëÓµÓÐQUERY REWRITE£¨±¾Ä£Ê½Ï£©»òGLOBAL QUERY REWRITE£¨ÆäËûģʽÏ£©È¨ÏÞ¡£
(2)
±ØÐëʹÓûùÓڳɱ¾µÄÓÅ»¯Æ÷£¬»ùÓÚ¹æÔ ......
#! /bin/bash
if [ -f ~/.bashrc ];then
. ~/.bash_profile
fi
export script=/home/oracle/script
export bakdata_destination=/u02/rman_backup/data
export baklog_destination=/u02/rman_backup/log
export datadir=`date +'%Y_%m_%d'`
export days=`date +'%w'`
if ! test -d $script
then
&nb ......