Oracle
c Æ Æ 6Æ 6Æ 6 Æ
Views 321 Downloads 2 File size 771KB
Recommend stories
- Author / Uploaded
- Nandikolla Srikanth
Citation preview
c
Æ Æ 6Æ
6Æ 6 Æ
Æ !"# #$Æ%Æ& Æ '
() Æ Æ () Æ
* & + Æ + Æ ,
-
. , / ,
Æ01 Æ + '2)#1 Æ + $Æ(1 $1& Æ + )1 Æ + 34( 0 + &()( 5 0 + 6(&'2 5 0 + &()(0 +7 +8 ,+6(&'2/ + 9 + Æ : + :.
/ , Æ
*
; Æ =/(& = > = Æ01)Æ1$01= > = /(& = > =
c
Æ01= > = /(& = > = 34(= =
cc c
Æ01= > =
cc
c c
c
/(& = > = 34(= = ?@#$)A&(B= =CD Æ01= > = /(& = > = 34(= > =$- -+- E-+ Æ01= > = /(& = > = 34(= > = 13$- -#$)- E- Æ01= > = /(& = > = 34(= > =F?2#11($C Æ01= > = /(& = > = @34(= =B &()( 5= > =@#Æ0+)Æ0B Æ010&'$1= > = /(& = > = Æ01= > =+Æ' = > E= /(& = > = 6(&'2 5= > = ! Æ01= > =+Æ' = > E= /(& = > = 6(&'2 5= > = 4#8$6
cc c
cc
c c
" #Æ 0(#11# = > = = ==> > > > =+
c
c
= E==> > > >E=+ " #Æ )(&21# = > = "
" #Æ 1('$0#11# = > = Æ $Æ(1$1&= > == =+= E=+ 8#'Æ= =+= E=+ $ Æ '2)#1= > = Æ1= > =G@ , B 34(? C %Æ )1/(& = > = 34(? C Æ & Æ
, . , . , Æ . + 9 +
+ + + + Æ
; * ' ! ! (): 1 Æ
+ +
; 1
0(#1+#1(+)(&2+ ($# +1('$0#1 Mc * ! ! (*): 1 Æ
+
+ + 1
Æ01+ $Æ(1+ '2)#1+ )1
c
Mc
cc c
cc
c c
c
" ! ! (" ): 1 Æ
1
0& 1+(& #0F+Æ#82&$1 Mc ! ! ( ): 1 Æ
; 1
6(#$1(8&F Mc
!" # 1 #
, 4
# *
= == == =+= E== =+= H== =I /
,
*
= == == =@ B+ = E== =@ B+ = H== =@ BI @BG +&5 -. +
, &
J+ E"+ H+
H"+ E"+ E"I
cc c
cc
c c
1 , , + +
: 9
H" ) Æ
. , = =+ =
=+= =+
c
1
, + . , # , + ,
+ , + , + , + ,
.
+
.
, # Æ ,=I=
c
) , =>$ =+ + = = : 4
) * K
/9 : ÆK
9EJJ
8 : 9K
$ ,9 K
) ) K
$ ,9 K +=K = +,9 == 3
L 3
+
, # ,
, / 9 + = = ,
1 1 ,
= = , - .+ = . = # = . =
, #
,
#
1 0
Æ
+ , +
Æ M
1 ,
# Æ :+=
=
c
- ,
, 5 ,
+
1 Æ ,
cc c
! " #
cc
c c
c
1 , 1
+ . , , + ,
+ , + ,
+ , . , + ,
1 , , , , Æ + = = > +> > +> I 9 ,+ , , - . -+ , , -6 - , &
++ +
+ + - . -+-) . -+NJ+-E H" $ -+ -4K 0 -+-6 -I +&# ,
! *- - ,
5
,* 7 3 +Æ
+EO+ J"""" 2 3 +2 +HE+NJH"""" ) .Æ+2 +NJ+!J"E"""
+ J
,
cc c
c c
c c
cÆ
EcÆ , H""""
c
# -
+ *
c
HcÆ - H" NcÆ + + , =2 = JcÆ , = = PcÆ , =2 = !cÆ O" OcÆ , == Æ ! 1
4
* = =@+= E=+ B = = @,
= =BI@BG 1 , . , , ,
5 -. + =Q= 1 , . , ' ,
1 , , ,
+ . , Æ ,-,
cc c
c c
c c
Æ Æ
34( +, ,
1 34( ,
,, 9
c
1 34( 0 , ,
9
/
9 + , ,
"
( ,
c
34( , Æ01+ )1+ '2)#1 Æ 'Æ ,-, & 34(? 9
C : Æ9 34( ,Æ * Æ01¬ /(& 34(¬ I ¬ :
9
Mc ¬ : . GR +> /(& > 34(G ""I 0 & &
34( 0 1
9 +",&# Æ01 34( &
,-, . 9
34( Æ01
c
% &
,
+
+ E"S
,
H""""+ Æ01 , , ,
cc c
c c
c c
c
Æ01 + + Q E #Æ ,> /(&
34( Q E /(& > 34( > F-ÆS-I 1 , * ' /
/
/
Æ
c
::::::::::::::::::::::::::
cc c
c c
c c
c
Æ .
6 ,
1 , ,
> -Æ-
1
, , F
+->- +
% & ,-- + Æ01 > +> /(& > 34( > F->S-I 1 , * ' /
/
:::::::::::::::::::::::::: (
Æ
+",&
Æ
* - >>S -: ,
, + -Æ>>;S- : ,
,
-Æ--- Æ ,",,+222+ 1 13$#$)+
%, & ,
" J + , . + Æ01 > +> +
c
/(& >
34( 13$ "#$) JI
cc c
c c
c c
c
1 , * ' /
/
!
:::::::::::::::::::::::::::::::: (
Æ
"
#;
,
E
Æ .
6 ,
J
Æ + & 1 $ , ,
,
&( % & , ,
Æ + , . + Æ01 > +> + ; /(& > 34( ; $- -+-Æ -I 1 , * ' /
/
#3
#;
,
Æ .
6 ,
(
Æ
Æ
Æ
/
Æ
5
; . --+- -+- -
+",&1
c
::::::::::::::::::::::::::::::::::::
cc c
c c
c c
c
Æ Æ+$ # $' 9 1 Æ $' , %, & , , + , , Æ01 > +> /(& > 34( Æ$' 1
, , > + , , Æ !
1
& + #$)+ &(+ $&1 1
, , , 3
Æ01 + 34( + , ,
!
/ , / ,
$&1
/ ,
#$)
c
&(
cc c
c c
c c
c
o-o!
& , , + +&( % & , ,
Æ + , . + Æ01 > +> + ; /(& > 34( ; G- -&( ; G-Æ - 1 , . + ' /
/
#3
:::::::::::::::::::::::::::::::::::: #;
,
Æ .
6 ,
(
Æ
Æ
Æ
/
Æ
1 , , =&(= , 4 5 - Æ ' . Æ ' . Æ 5Æ
5Æ
5Æ
$&
5Æ
$&
5Æ
5Æ
$&
$&
$&
c
5Æ
cc c
c c
c c
c
o+o!
& , , + +#$) % , &1 ,
" J + , . * Æ01 > +> + /(& > 34( @34( B @&()( 5 @+ E+ $B@)Æ0BBI # #o o +
!
Æ
""
(
EN
EJ"""
"
4 .
EO
HJ"""
"E
4
#
EO
HJ"""
"H
Æ
EE
E""""
"N
2
1
EJ
H""""
%, & ,
+ , Æ01 + /(&
&()( 5 I 1 , . +
Æ
E""""
(
EJ"""
2
H""""
4 .
HJ"""
4
HJ"""
1
cc c
c c
c c
Æ
c
::::::::::::::::::::
c
5
&()( 5 ,
+ , . + Æ01 + /(&
&()( 5 + I 1 , . *
Æ
:::::::::::::::::::::::::: Æ
E""""
(
EJ"""
2
H""""
4
HJ"""
4 .
HJ"""
+",&1 &()( 5 Æ01 5
&()( 5 Æ01 + , 1 , ,+ Æ01 + /(&
&()( 5 +EI + &()( 5 0 , + 9 , , Æ01 +
1 - - - - cc c
c c
c c
&()( 5 + )Æ0I
c
/(&
c
, + , , Æ01 + /(&
&()( 5 )Æ0+ )Æ0I -,-6 . 9
&()( 5 Æ01 % & ,
+
+ E"S
,
H""""
+ Æ01 , , , Æ01 + + Q E#Æ ,> /(&
34( Q E )Æ0I 1 ,
/
::::::::::::::::::::::::::::::::: 4 .
HJ"""
H!"""
4
HJ"""
H!"""
2
H""""
HP"""
+",&# Æ01 Æ &()( 50
c
Æ -$76
cc c
c c
c c
c
1 Æ 6(&'2 5 0 ,
%, & , . , + , * Æ01 +Æ' /(&
6(&'2 5 I 1 , . * ::::::::::::::::
:::::::::::::: EJ""" JJ""" # HJ""" 1 H"""" +",&1 9 , Æ01 + +Æ' /(&
6(&'2 5 + I 1 , . *
:::::::::::::::::::::::::::::::::::::::
EJ"""
JJ"""
# HJ"""
1 H"""" Æ !
cc c
c c
c c
1 Æ
% !0 8++ 8 $ 1 8 2 0 , , 1 1 :
c
0
c
E1
1 : 4)cÆ 7 & 1 .
Æ Æ $ ,
) Æ + 6')+ Æ Æ 2 . 1 , , Æ ' 7 & @0&$Æ1(#$1 > B2( #(5 F5 Æ ' 7 # & @0&$Æ1(#$1 > B2( #(5F5 > + > E+ > + > E
, F Mc 1 9, . @0&$Æ1(#$1 > B %, &1
,2 F + , . 7 0 # & Mc
0(#11#
J2( #(5F5+ E"+
c
"+
E+
cc c
c c
c c
c
"+ "I 0(#11#
J0&$Æ1(#$1 >>.2( #(5F5+ E"+ "+ E+ "+ "I 7 0 # & 0(#11#
J+ E"+ "+ E+ "+ "+
c
0&$Æ1(#$1 >>.2( #(5F5I
cc c
c c
c c
c
. , . +, 'Æ(>0&$Æ1(#$1Æ
9 *
Q > ,
> G- 2- > G-2-
. , , . + ,
'Æ(>0&$Æ>0&' $Æ
9 *
Æ010&' $>$# /(& 'Æ(>0&$Æ>0&' $Æ34( 0&$Æ1(#$1>$# G- 2>2( #(5>F5- 5)cÆ % ! -' ! & #
.
cc c
c c
c c
1
2( #(5 F5
,
, ,
/ /
F + 2 F ,
&
/
.
c
1
, ,
. 1
. ,
.
c
Æ ' % ! & @0&$Æ1(#$1 > B(/($0Æ (
>1 > > Æ ' % ! # & @0&$Æ1(#$1 > B/&(6$F5 > (/($0Æ
> > > I %, & = = = > = % !0 & 0(#11# > J0&$Æ1(#$1>>.2( #(5F5+ > E"+ > E"+ > "I 0(#11# > > J0&$Æ1(#$1 >>.2( #(5F5+ > J0&$Æ1(#$1>>.(/($0Æ+ >+ > E"+ > E"+ > "I
c
% !0 # &
cc c
c c
c c
c
0(#11# > > J+ > J+ > E"+ > E"+ > " 0&$Æ1(#$1 >>.2( #(5F5 >+ 0&$Æ1(#$1>>./&(6$F5 >(/($0Æ >I E
- >- +
. ,
. --, + , . + 0(#11#
J2( #(5F5+ E"+ "+ E+ > J(/($0Æ
+ "+
cc c
c c
c c
U)cÆ ++ & ,
, +
c
"I
c
.+ $&1 $' #,
$&1 $' + 9
$&1$' 0& , ,
, & $&1$' ,
9 2 $# $&1$' 1
, , 3 , Æ ' ++ & @0&$Æ1(#$1 B$&1$' %, &1
,$ + , . 0(#11#
J+ E"0&$Æ1(#$1>$&1$'+ "+ E+ "+ "I
+ + 1 cc c
c c
c c
1 1 9 -Æ $&1 $' 0 - 9 + ,
Æ >0> " , 23
+,
c
$ ,
c
, Æ 0 =Æ >=+=Æ >$ = =Æ >0= $' 1
-Æ >0> "-1 ,
-Æ >0> "-3
+
, Æ $&1$'0 " #Æ / /49 -,",",Æ >0> " Æ > !E+"+$+ Æ >$ J+"+$+ Æ >0 "+"+$ Æ / /49 # Æ >0> " Æ >0> " Æ >0> " Æ >0> " Æ >0> "
+-F -+ "I
E+-#;-+ "I
H+-(. -+ "I
N+- -+ "I
J+-Æ -+ "I
Æ / /49 Æ / E H N J :)Æ $ 1 0 &
Æ /+ F #; (. Æ
Æ / " " " " "
1
, #
@0&$Æ1(#$1 > B'$ '
cc c
c
Æ ' $ 1 &
c c
c c
c
Æ ' $ 1 # & @0&$Æ1(#$1 > B'$ ' > %, &1
,' . + , . + $ 1 0 & 0(#11#
J2( #(5F5+ E"+ "+ E+ "+ "'$ 'I 0(#11#
J2( #(5F5+ E"+ "+ E+ "+ "0&$Æ1(#$1 > '$ 'I
c
$ 1 0 # &
cc c
c c
c c
c
0(#11#
J2( #(5F5+ E"+ "+ E+ "+ "+ 0&$Æ1(#$1 > '$ ' I ±)Æ & 1 #
, 1 Æ ' & @0&$Æ1(#$1 > B040F %, &
+ , . & 0(#11#
J2( #(5F5+ E"+ "+
cc c
c c
c c
040F - -+-/-+
c
E+
c
"+ "I # & 0(#11#
J2( #(5F5+ E"+ "+ E+ + "+ "+ 0&$Æ1(#$1 > .040F - -+-/-I Æ# Æ
1 , 9
:O!* Æ01# Æ:O!=# =/(& )'#I # :::::::::: O! ,( ,
1 ,
, HNJPI
cc c
c c
HNJP60 I
c
9 *
c c
c
0 ::::::::: N %-( , 9 * 1 ,
,HNJPI HNJP6/ I / :::::::::::: H ( + + 9 1 , 9
"" "+ "" I &6 ::::::::: E -$+( 9 1 , 9
HNJ!H E HNJ!H+E6( I
c
(
:::::::::::: HNP
cc c
c c
c c
c
Æ -"(
9 1 , 9
P P I Æ (1 ::::::::: N -,",Æ"6(#1Æ1 9 + 9 E+ 9 H+ 9 N (
9 9 9
"+E"+J"+E"+H" I 6(#1Æ1 :::::::: J"
-Æ# -+-Æ0&11-+-(#8-+-Æ 14-+-1#$5#- I 6(#1Æ1 :::::::: 1#$5# ,Æ"#Æ1 9 + 9 E+ 9 H+ 9 N
9
9
"+E"+J"+E"+H" I
c
#Æ1
:::::::: "
cc c
c c
c c
c
-Æ# -+-Æ0&11-+-(#8-+-Æ 14-+-1#$5#- I #Æ1 :::::::: (#8 !!! % #
,+ , 5 #
&()( 5 4#8$6 1
, 6(&'2 5 Æ01 + ,
& , , 1 #
* # Æ 9 0 Æ 8 ; #86#%)Æ1$01 9 ( 9 9 1 ,
6# Æ I # Æ :::::::::::::::::::::::: EN""N" Æ$*Æ' #%)Æ1$01 9 ( 9 9
61 Æ I 1 Æ
cc c
c
1 ,
c c
c c
c
:::::::::::::::::::::::: EPJ"" *) / 9 ( , ) + + + Æ,K + 6 + ) .+ / 0 # (6&$>) , ,
, + ( >$ 0 >$ + ,
; ,
(6&$>)
1
; & + * Mc 0 7 7 Mc $ : 7 Mc & 7
cc c
c
Mc
c c
c c
c
Æ 7 7 , , , & & 1 + & 2 9 1 Æ : 9 , , 1 ,
; ; 34( + ; Æ : 9, Mc
Æ9, ; 9* Æ,, " 8 8= #4>2 %-* #48 #5 ,-,= #4>2 ?= #5>2 & /(& +
+ & 34( + ;
+ ,
cc c
c c
c c
$ *2
9
, , ,
(6&$>) + ,
, * Æ01(6&$>$# +0&'$1(5>$# +-, +Æ(6&$>) /(& 0&'$1(Æ+(6&$Æ 34(0&'$1(Æ(6&$>)G(6&$Æ(6&$>)I Æ 1 ,
1
+
Æ01(6&$>$# +((6&$>)+0&'$1(5>$# /(& 0&'$1(Æ0+(6&$Æ( 34(0(6&$>)G((6&$>)I 9 + 0 0&'$1(Æ + ( (6&$Æ 1
/(& + $ ,
, #
, ; *
c
1
(6&$>$# 0&'$1(5>$# , * Æ01(6&$>$# +0&'$1(5>$# /(& 0&'$1(Æ+(6&$Æ 34(0&'$1(Æ(6&$>)G(6&$Æ(6&$>)I
c
( *3
; + : ; ,
: ; ,
; + , ,
+
; + &0#1&$Æ+0&'$1(Æ+(6&$Æ1
+,
E ; 1 ; &0#1&$Æ 0&'$1(Æ0 0&'$1(5>)G00&'$1(5>) 1 ; 0&'$1(Æ0 (6&$Æ ( ((6&$>)G0(6&$>) ·
c
# ; ,
, , ; 9 ,
EJ , 0&'$1(Æ N , (6&$Æ 1 0 ; +,
""
, , 0&'$1(Æ , ,
, (6&$Æ Æ010&'$1(5>$# +(6&$>$# /(& 0&'$1(Æ+(6&$ÆI
cc c
c c
c c
c
,1 @· 1 ; : ; ,
+
1 9 , , :; * Æ01(6&$>$# +0&'$1(5>$# /(& 0&'$1(Æ+(6&$Æ 34(0&'$1(Æ(6&$>)G(6&$Æ(6&$>)I 1 (6&$>) 0&'$1(Æ + (6&$>) (6&$Æ
:; :;
;
cc c
c c
c c
1 ; : ; ,
+
1 , , Æ#6(#)
2&5Æ
& Æ#6(#) 1 #
, , """"1
, , """
c
+@,1 ·
c
E""""+ 1 2&5Æ +; >
,
+ , ; + ; , +
$ : 7
1
> + , * Æ01/(Æ1>$# +6(#) /(& 2&5Æ+Æ#6(#) 34( 2&5ÆÆ##(5 13$ $Æ##$) #TÆ#I ·
c
# ; :; ,
0 ,+ , )2#(1 $1Æ *
cc c
c c
c c
c
c
$ , , :; , )2#(1 $1>$# /(Æ1>$# 1 #$#6(>) #
1
2&5Æ +
- + , , * Æ01)2#(1 $1>$# +/(Æ1>$# /(& )2#(1 $1Æ)+ 2&5Æ 34() #$#6(>)G 2&5>)I 1 , , - , - Æ
,
cc c
c c
c c
c
cc c
c c
c c
3, ,
+ 1 ,
+
+ ,
> - > 1 + ,
:; ; ; + , 9 ,
+ , ,
+ )2#(1 $1Æ , + 2&5Æ , > 1
; +, . ; 1 D
+ ; + # + 2&5Æ
+ ;
+
:; ,
, *
c
c
Æ01)2#(1 $1>$# +/(Æ1>$# /(& )2#(1 $1Æ)+ 2&5Æ 34() #$#6(>)G, 2&5>)(A)I
Æ'· (· )
c
# ; ; ,
+ ,0 , ,
cc c
c c
c c
cc c
c c
c c
1
, ) "!+ )+ , ) "H +
, ) "H+ # 9 1
+ , # 9 )- , ,
, ,
+ , , 1
, ,+
, ,
+ , ,
1 9 ,
, ,
; ; 3 ; + , , , 1, , , /(& + , ,
+ , ,
1 /(& , .. * /(& 2&5Æ+ 2&5Æ(
c
c
c
& 2&5Æ 1 2&5Æ ( $ ,+ , , + ,
,
+ ; , :; 1
#$#6(>)
,+ 2&5>) ,
cc c
c c
c c
1
, * #$#6(>)G( 2&5>) 1
+ , ,
- - , , , * Æ01/(Æ1>$# + /(Æ1>$# /(& 2&5Æ+ 2&5Æ 34( #$#6(>)G( #$#6(>)I Æ , , ; & +
;
1 ,
5
; 34( #$) 9 ,+, ,
c
c
, , + ,
) Æ01(6&$>$# +((6&$>)+0&'$1(5>$# /(& 0&'$1(Æ0+(6&$Æ( 34(0(6&$>)G((6&$>) #$)0&'$1(5>$# F- S-I Æ #1 # Æ + ,
, Æ :
, 1 ,Æ01
, H" Æ01Q/(& 2&5Æ 34()2#(1 $1>)GH"I + )
+ 34( 4 , + . , / 9 +
: :
, -# 9 F - 4
' + ,
: , # 9 F -T-5 ,
, T E: * 3 # 9 F E3
,
Æ Æ9*
cc c
c c
c c
9+ Æ01 , 34( + 34( 1 Æ01 1 9
Æ
c
Æ01 > /(& > 34( > Æ01 >/(& > 6
c
Æ01 + 34( + 4#8$6 + /(& + Æ01
1
, # 9 F *
c
Æ01Q /(& 2&5Æ34()2#(1 $1>)GÆ01)2#(1 $1>)/(& 2&5Æ 34(/(Æ1>$# G-# 9 -#$)#Æ1>$# G-F -
cc c
c c
c c
c
9 Æ Æ
*
2 Mc ' : , , : , Mc ' : , , : ,
cc c
c c
c c
c
Mc Mc
c
# : , ,
: , *
G
1
R)G "I Æ01Q ( /(& 2&5Æ
, 34(Æ##(5)GE" I
R
(
, 9
E"
Æ01Q/(& 2&5Æ 34(Æ##(5RÆ01 #TÆ##(5 /(& 2&5Æ 34( )2#(1 $1>)GE"I
RG
(
, ,
E" ,
Æ01Q/(& 2&5Æ 34(4(>)#1RGÆ01 4(>)#1 /(& 2&5Æ 34( 2&5>)GE" I
# , ,
+ : , &(#: " NE!
* : ,
, 1 , : , , , : , *
#$5
0
#
0
cc c
c c
c c
$
c
&
c
1 : ,
, : , 1 , : , , : , &
$
9
Æ01)2#(1 $1>)+ (
)2#(1 $1>$# + )+ &0#1&$>) ) /(& )2#(1 $1Æ
34(&0#1&$>)$ Æ01&0#1&$>) ) /(& &0#1&$Æ34( 'F 0&'$1(5>)G-'F-
$#
, /(& 2&5Æ 6
34(Æ##(5)GE" E"
R#
( Æ01/(Æ1>$#
, /(& 2&5Æ 34(Æ##(5R#
Æ01Æ##(5 /(& 2&5Æ
34()2#(1 $1>)GE" E"
( Æ01/(Æ1>$#
, /(& 2&5Æ 6
34(Æ##(5