ࡱ ; x
! " # $ % & ' ( ) * + , . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w y z R o o t E n t r y
!r\V )䰱
Presentation StarImpress 5.0 1z DS SfxDocumentInfo lX1&
Ryan Brown lX1 uK Info 0 Info 1 Info 2 Info 3 lX1& ` <
TASK,0,1,H
1,0,100,1, Oh +'0 h
t
5 @ 2 @ ) @ bn@ ݹn Ryan Brown XOutdevItemPool 1
)
&'()*+,-./06789:;UVWXYZ[\] c !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrst t
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdef d 0 \ ' @ q X X ' , @ X ' . @ 2 X X X ' @ X ' @ Arrow
Arrow d d X X XS ' c @ ( Arrow d d X X ' . @ ^ , X X X ' " @ , X X ' @ X X ' @ X
@
@
@ !
@ 7
@ M
@ c
@ y ' @ X X ' b @ ̙ X X X2 XD ' 6 @ O 2 2 d d X ' ( @ X ' " @ BMv v ( @ @ SD @ x^SI
0 s\ z
46ZBn 8x)1̔.<觔B+̄ ޢ40:prf
|q]~+H~|WFM b P@aoCē[ȡz6~U{߃ ** < @ X X X X X& 77 < @ I X X X X X& HH R @ +' ' X X X X& X, X2 ff
@ JJ KK JJ KK JJ KK QQ VV JJ KK JJ KK JJ KK JJ KK RR
JJ JJ KK X X X2 XP Xb Xt X X X 8 p ) W " 8 b F t $ : P f | , B X n 4 J ` v X
0
F
\
r
, B X n
z
P ! * EditEngineItemPool 6 f % 0 8 g* | @ e,
" , StarBats N
- " , StarBats N
- " , StarBats N
- " ` ` , StarBats N
- " , StarBats N
- " , StarBats N
- " hh , StarBats N
- " , StarBats N
- " , StarBats N
- " pp , StarBats N
-
" X , StarBats N
- " , StarBats N
- " , StarBats N
- " ` ` , StarBats N
- " , StarBats N
- " , StarBats N
- " hh , StarBats N
- " , StarBats N
- " , StarBats N
- " pp , StarBats N
-
" , StarBats N
- " , StarBats N
- " , StarBats N
- " ` ` , StarBats N
- " , StarBats N
- " , StarBats N
- " hh , StarBats N
- " , StarBats N
- " , StarBats N
- " pp , StarBats N
-
Z " | , StarBats N
- " | , StarBats N
- ` ` , StarBats N
K " , StarBats N
- , StarBats N
K " pp , StarBats N
- " , StarBats N
- " , StarBats N
- " %% , StarBats N
- " 0*0* , StarBats N
- Z
r , StarBats
- r , StarBats
- r , StarBats
- r , StarBats
- r , StarBats
- r , StarBats
- r pp , StarBats
- r XX , StarBats
- r @ @ , StarBats
- r (#(# , StarBats
- " XX , StarBats i
- " , StarBats i
- " , StarBats i
- " ` ` , StarBats i
- " , StarBats i
- " , StarBats i
- " hh , StarBats i
- " , StarBats i
- " , StarBats i
- X X. XN Xn X X
@ , @ , X X Z @ - d d d x xd d d x Y d d d x d d d Y
d d d YD d d d YD d d d YD d d d YD 8d d d 8 YD Xd d d X YD x d d d x YD !d d d ! YDX X! X: XM Xf X X X X X X X <(
n @
u. , X X X X X& X, X2 X8 X> XD
(
/ @ 0
StarBats !"- g
StarBats !"-
StarBats !K
StarBats !r-
StarBats X !"-
StarBats !"- T
StarBats !"- J
StarBats !"-
StarBats X !K X XG X X X X+ Xd X X @' ! n @ 2 d d d d d Xd d d d ,d d |d @d d d ` d d d hd d d d d d p d d d x d d d
(#d d d % 'd d d 0* d d d X
d d d Y d d d Y| d d d ` d d d ` Y d d d Y d d d Y pd d d p Y d d d Y d d d Y %d d d % Y 0*d d d 0* YX X! X4 XG XZ Xm X X X X X X X X X X7 XJ Xc X| X X X X X A' @ 3 d d d d d d d d d d d d d ,d d d
d d d X X X& X2 X> XJ XV Xb 1' @ 4 d X +' ( @ 54 X X X '
@ W4 !' @ y4 X ' @ 4
Times X '
@ 55
Nd
4d
d
d
{d
d
d
hd
d
d
d
id
X X X" X, X6 X@ XJ XT X^ Xh Xr X| ?(
@ {5 ' @ 5
X X ' @ 5
X ' @ 5
X ' @ 6 Q X X ' @ $6
X ' @ C6
X %'
@ ]6 S'
@ s6 "'
@ 6 '
@ 6 @ 6 X {( @ w8 p 8 http://dbase.cs.jhu.edu:8080/pls/cs415/summation?x=4&y=58 http://dbase.cs.jhu.edu:8080/pls/cs415/summation?x=4&y=5W! X! pT ! http://www.orafaq.org/faqjdbc.htm! http://www.orafaq.org/faqjdbc.htmW! X! pV " http://www.orafaq.org/faqloadr.htm" http://www.orafaq.org/faqloadr.htmW! X! pL http://dbase.cs.jhu.edu:8080/ http://dbase.cs.jhu.edu:8080/W! X! X X X X[ < k & Z p ~! ! ! ! ! "" A" `" v" " " " " P = g*
" XX , StarBats N
- " , StarBats N
- " , StarBats N
- " ` ` , StarBats N
- " , StarBats N
- " , StarBats N
- " hh , StarBats N
- " , StarBats N
- " , StarBats N
- " pp , StarBats N
-
(
StarBats !"- !' ' Times ' Od
0 8 s 2 + L Standard Standard # ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' +;( ,, -- .. g*
( @' A' 1' +' !' ' ' ' ' ' ' ' ' Object with arrow Standard Object with arrow ' ' ' ' ' ' ' Object with shadow Standard Object with shadow +;( ,, -- .. Object without fill Standard Object without fill ' Text Standard Text ' ' Text body Standard Text body ' ' ' Text body justfied Standard Text body justfied ' ' +' First line indent Standard First line indent ' ' g* @' Title Standard Title ' ' ' Title1 Standard Title1 ' ' ' +;( ,, -- .. +' ' Title2 Standard Title2 ' ' +;( ,, -- .. g* @' A' +' ' Heading Standard Heading ' ' A' ' Heading1 Standard Heading1 ' ' A' ' ' Heading2 Standard Heading2 ' ' A' ' ' ' Dimension Line Standard Dimension Line ' ' ' ' ' ' ' Home~LT~Gliederung 1 Home~LT~Gliederung 1 ' ' g* @' A' +' !' ' ' ' ' ' ' ' ' Home~LT~Gliederung 2 Home~LT~Gliederung 1 Home~LT~Gliederung 2 @' A' ' Home~LT~Gliederung 3 Home~LT~Gliederung 2 Home~LT~Gliederung 3 @' A' ' Home~LT~Gliederung 4 Home~LT~Gliederung 3 Home~LT~Gliederung 4 @' A' '
Home~LT~Gliederung 5 Home~LT~Gliederung 4 Home~LT~Gliederung 5 @' A' '
Home~LT~Gliederung 6 Home~LT~Gliederung 5 Home~LT~Gliederung 6 @' A' '
Home~LT~Gliederung 7 Home~LT~Gliederung 6 Home~LT~Gliederung 7 @' A' '
Home~LT~Gliederung 8 Home~LT~Gliederung 7 Home~LT~Gliederung 8 @'
A' '
Home~LT~Gliederung 9 Home~LT~Gliederung 8 Home~LT~Gliederung 9 @' A' '
Home~LT~Titel
Home~LT~Titel ' ' QQ g* +' !' ' ' ' ' ' ' ' ' Home~LT~Untertitel Home~LT~Untertitel ' ' QQ g* @' +' !' ' ' ' ' ' ' ' ' Home~LT~Notizen Home~LT~Notizen ' ' !' ' ' ' ' ' ' ' ' Home~LT~Hintergrundobjekte Home~LT~Hintergrundobjekte +;( ,, -- .. Home~LT~Hintergrund Home~LT~Hintergrund ' ' Title Title @ Subtitle Subtitle @ Background objects Background objects @
Background
Background @ Notes Notes @ Outline 1 Outline 1 @ Outline 2 Outline 1 Outline 2 @ Outline 3 Outline 2 Outline 3 @ Outline 4 Outline 3 Outline 4 @ Outline 5 Outline 4 Outline 5 @ Outline 6 Outline 5 Outline 6 @ Outline 7 Outline 6 Outline 7 @ Outline 8 Outline 7 Outline 8 @ Outline 9 Outline 8 Outline 9 @ t P D P 8 >
p < n
x H t &
Y
% DrMd JoeMn 0 lX1( lX1ħ lX1r O DrLy LAYER_LAYOUT DrLy
LAYER_BCKGRND DrLy LAYER_BACKGRNDOBJ DrLy LAYER_CONTROLS DrLy ! LAYER_MEASURELINES DrMP ' JoeM l T DrML DrOb < SVDr & 0 !& DrOb < SVDr & ; 6d !& DrOb < SVDr & - 0 DL DrOb < SVDr & ; - 6d DL DrXX gg f Home~LT~Gliederung DrMP JoeM `m R DrML DrOb SVDr & _m R ' Home~LT~Hintergrund _m R DrOb SVDr & oe !
Home~LT~Titel oe p xV4B1 [ # Click to edit the title text format
Home~LT~Titel <(
( @'
DrOb W SVDr & oe {J ( Home~LT~Gliederung 1 oe {J xV4B1 % Click to edit the outline text format Home~LT~Gliederung 1 <(
( @' Second Outline Level Home~LT~Gliederung 2
<(
( @' Third Outline Level Home~LT~Gliederung 3 <(
( @' Fourth Outline Level Home~LT~Gliederung 4 <(
( @' Fifth Outline Level Home~LT~Gliederung 5 <(
( @' Sixth Outline Level Home~LT~Gliederung 6 <(
( @' Seventh Outline Level Home~LT~Gliederung 7 <(
( @' Eighth Outline Level Home~LT~Gliederung 8 <(
( @' Ninth Outline Level Home~LT~Gliederung 9 <(
( @' DrXX gg ^ Home~LT~Gliederung DrMP JoeM T l DrML DrOb SVDr & 5
B (0 !
Home~LT~Titel 5
B (0 d xV4B1 O Click to move the slide
Home~LT~Titel <(
( @'
DrOb SVDr & 3 OG "] # Home~LT~Notizen 3 OG "] m xV4B1 X Click to edit the notes format Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg c JoeM l T DrML 8 DrMD , DrXX Handoutsgg F Home~LT~Gliederung DrPg
JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe e xV4B1 P Database Systems: PL/SQL
Home~LT~Titel <(
( @'
DrOb F SVDr &
% g C Standard
% g C xV4B1 2 - PL/SQL is a procedural language, based upon PL/1 Standard <(
( @' - - PL/SQL adds procedural functionality to SQL Standard <(
( @' 5 - PL/SQL is interpreted by the Oracle database engine Standard <(
( @' 2 - PL/SQL procedures are stored in the table space. Standard <(
( @' Standard <(
( @'
Basic Syntax: Standard <(
( @'
# create [or replace] procedure NAME Standard <(
( @' ( [(argument [IN | OUT | IN OUT] datatype Standard <(
( @' 1 [, argument [IN | OUT | IN OUT] datatype] ... )] Standard <(
( @' {IS | AS} block; Standard <(
( @' Standard <(
( @' drop procedure NAME; Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] # Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel} oe ^ xV4B1 I Example Procedure
Home~LT~Titel <(
( @'
DrOb SVDr & ve 6D Standard ve 6D l xV4B1 C S This example procedure does an INSERT, and takes the variable Person_Name as input. Standard <(
( @' S Standard <(
( @' 5 create procedure NEW_WORKER (Person_Name IN varchar2) Standard <(
( @' AS Standard <(
( @' BEGIN Standard <(
( @' ) insert into WORKER (Name, Age, Lodging) Standard <(
( @' # values (Person_Name, null, null); Standard <(
( @' END; Standard <(
( @' / Standard <(
( @' Standard <(
( @' J .. note the / on a line by itself. This denotes the end of the procedure. Standard <(
( @' J DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg ] JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe ` xV4B1 K Declaring Variables
Home~LT~Titel <(
( @'
DrOb SVDr & g ~@ Standard H g ~@ )
xV4B1
P We may also want to declare variables to use within our procedure. For example: Standard <(
( @' P Standard <(
( @' A create or replace procedure PrintMatches (SearchName IN varchar2) Standard <(
( @' IS Standard <(
( @' person contactinfo%ROWTYPE; Standard <(
( @' CURSOR person_match IS Standard <(
( @'
SELECT * Standard <(
( @' FROM contactinfo Standard <(
( @' & WHERE contactinfo.name = SearchName; Standard <(
( @' BEGIN Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg l JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titels oe T xV4B1 ? Cursors
Home~LT~Titel <(
( @'
DrOb SVDr & c EG Standard c c EG D xV4B1 Continuing our example... Standard <(
( @' Standard <(
( @' OPEN person_match; Standard <(
( @' FETCH person_match INTO person; Standard <(
( @' WHILE person_match%FOUND LOOP Standard <(
( @' F PUT_LINE ('Name: ' || person.name || ', Phone #: ' || person.phone); Standard <(
( @' ! FETCH person_match INTO person; Standard <(
( @'
END LOOP; Standard <(
( @' CLOSE person_match; Standard <(
( @' END; Standard <(
( @' / Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg ? JoeM `m R DrML 8 DrMD , DrOb SVDr & 8 c N Standard 8 c N g xV4B1 0 l The HTP library for PL/SQL has a number of functions that make printing a HTML formatted result very simple. Standard <(
( @' l Standard <(
( @' BEGIN Standard <(
( @' HTP.htmlOpen; Standard <(
( @' HTP.headOpen; Standard <(
( @' HTP.Title ('Scores'); Standard <(
( @' HTP.headClose; Standard <(
( @' OPEN person_match; Standard <(
( @' FETCH person_match INTO person; Standard <(
( @' WHILE person_match%FOUND LOOP Standard <(
( @' G HTP.print ('Name: ' || person.name || ', Phone #: ' || person.phone); Standard <(
( @' ! FETCH person_match INTO person; Standard <(
( @'
END LOOP; Standard <(
( @' CLOSE person_match; Standard <(
( @' HTP.bodyClose; Standard <(
( @' HTP.htmlClose; Standard <(
( @' END; Standard <(
( @' / Standard <(
( @' DrXX gg F Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe j xV4B1 U Accessing PL/SQL from the web
Home~LT~Titel <(
( @'
DrOb 8 SVDr & V
c K Standard V
c K
xV4B1
a In order to call our functions after they are in our table space, we need to create an HTML form. Standard <(
( @' a Standard <(
( @' Standard <(
( @' * My PL/SQL Test Standard <(
( @' Standard <(
( @' Q Standard <(
( @' Standard <(
( @' Standard <(
( @' Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg a JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe ` xV4B1 K PL/SQL from the web
Home~LT~Titel <(
( @'
DrOb $ SVDr & < c MH Standard < c MH xV4B1 e Upon typing a name into the form and clicking "Search", the web browser will fetch the following URL: Standard <(
( @' e Standard <(
( @' H http://dbase.cs.jhu.edu:8080/pls/cs415/PrintMatches?SearchName=Bob+Smith Standard <(
( @' Standard <(
( @' The web server running on dbase (Apache) will call your PL/SQL procedure called PrintMatches with the argument of "Bob Smith" for the SearchName variable. Standard <(
( @' Standard <(
( @' The web server will also ask you for the login & password the first time you try and run a PL/SQL query. Enter your Oracle User Name & Oracle Password. This allows the web server to connect to the correct table space & run your procedure. Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0
DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg ` JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel} oe ^ xV4B1 I Summation Example
Home~LT~Titel <(
( @'
DrOb SVDr & 5g !Q Standard M 5g !Q . xV4B1 B create or replace procedure summation (x IN NUMBER, y IN NUMBER ) Standard <(
( @' IS Standard <(
( @' sum NUMBER; Standard <(
( @' BEGIN Standard <(
( @' sum := x + y; Standard <(
( @' htp.htmlopen; Standard <(
( @' htp.headopen; Standard <(
( @' htp.title('Sum'); Standard <(
( @' htp.headclose; Standard <(
( @' htp.bodyopen; Standard <(
( @' ] htp.print( 'The Sum of ' || to_char(x) || ' and ' || to_char(y) || ' is ' || to_char(x+y) ); Standard <(
( @' htp.bodyclose; Standard <(
( @' htp.htmlclose; Standard <(
( @' END; Standard <(
( @' / Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg [ JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel} oe ^ xV4B1 I Summation Example
Home~LT~Titel <(
( @'
DrOb SVDr & 7 ,e N Standard H 7 ,e N ) xV4B1 = To reach our summation example from our web browser, we type: Standard <(
( @' = Standard <(
( @' Standard <(
( @' Standard <(
( @' % Likewise, we could make an HTML form: Standard <(
( @' % Standard <(
( @' " summer Standard <(
( @' Standard <(
( @' N Standard <(
( @' Standard <(
( @' Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe a xV4B1 L Adding HTML tables..
Home~LT~Titel <(
( @'
DrOb SVDr &
\ Vf %K Standard l
\ Vf %K M xV4B1 " \ Back to our PersonMatch example, lets put the output in an HTML table so it is easy to read: Standard <(
( @' \ Standard <(
( @' " HTP.print (''); Standard <(
( @' < HTP.print ('| Name | Phone Number |
|---|
'); Standard <(
( @' OPEN person_match; Standard <(
( @' FETCH person_match INTO person; Standard <(
( @' WHILE person_match%FOUND LOOP Standard <(
( @' W HTP.print ('| ' || person.name || ' | ' || person.phone || ' |
'); Standard <(
( @' ! FETCH person_match INTO person; Standard <(
( @'
END LOOP; Standard <(
( @' CLOSE person_match; Standard <(
( @' HTP.print ('
'); Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe i xV4B1 T An aside on meta information
Home~LT~Titel <(
( @'
DrOb I SVDr &
2 g ( Standard
2 g ( xV4B1 m Oracle has a number of views that you can select from to get information about the items in your table space: Standard <(
( @' Standard <(
( @' # SELECT table_name FROM user_tables; Standard <(
( @' + SELECT procedure_name FROM user_procedures; Standard <(
( @' ! SELECT view_name FROM user_views; Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg ' JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe e xV4B1 P PERL Interface to Oracle
Home~LT~Titel <(
( @'
DrOb SVDr & \ f u: Standard \ f u: p xV4B1 S - PERL has a DBI (DataBase Interface) library that allows users to incorporate a connection to a relational database into their PERL programs. Standard <(
( @' Standard <(
( @' S - The DBD::Oracle module defines how the DBI module connects to an Oracle database. Standard <(
( @' S Standard <(
( @' o - The DBI module may be used in any script, including a standalone application, GUI application, or CGI script. Standard <(
( @' o DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe f xV4B1 Q PERL Command Line Example
Home~LT~Titel <(
( @'
DrOb SVDr & Q X rd !J Standard h Q X rd !J I xV4B1 #!/usr/local/bin/perl Standard <(
( @' Standard <(
( @' use DBI; Standard <(
( @' Standard <(
( @' % $ENV{ORACLE} = "/home/oracle/oracle"; Standard <(
( @' 3 $ENV{ORACLE_HOME} = "/home/oracle/oracle/OraHome1"; Standard <(
( @' 3 $ENV{ORACLE_BASE} = "/home/oracle/oracle/OraHome1"; Standard <(
( @' $ENV{ORACLE_SID} = "dbase"; Standard <(
( @' Standard <(
( @' $username = "xcatalina"; Standard <(
( @' $password = "tarxfdfm"; Standard <(
( @' Standard <(
( @' 7 $Db = DBI->connect("dbi:Oracle:", $username, $password, Standard <(
( @' > { AutoCommit => 0, PrintError => 0}) Standard <(
( @' 2 || die("Can't login to Oracle: $DBI::errstr\n"); Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg = JoeM `m R DrML 8 DrMD , DrOb SVDr & T e s !
Home~LT~Titel T e s f xV4B1 Q PERL Command Line Example
Home~LT~Titel <(
( @'
DrOb | SVDr & Uf R Standard & Uf R xV4B1 0 print "Enter the name you want to search for: "; Standard <(
( @' $name = <>; Standard <(
( @' chomp $name; Standard <(
( @' Standard <(
( @' S my $query_string = qq(SELECT * FROM contactinfo WHERE contactinfo.name = '$name'); Standard <(
( @' ) my $handle = $Db->prepare($query_string); Standard <(
( @' if (! ($handle->execute ())) { Standard <(
( @' . print STDERR "Oracle Error: " . $DBI::errstr; Standard <(
( @' } Standard <(
( @' else { Standard <(
( @' 0 my ($name, $phone) = $handle->fetchrow_array(); Standard <(
( @' while (defined ($name)) { Standard <(
( @' . print "Name: $name, Phone Number: $phone\n"; Standard <(
( @' . ($name, $phone) = $handle->fetchrow_array(); Standard <(
( @' } Standard <(
( @' } Standard <(
( @' Standard <(
( @' DrXX gg J Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg d JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel oe f xV4B1 Q PERL Command Line Example
Home~LT~Titel <(
( @'
DrOb SVDr &
e c) Standard I
e c) * xV4B1 = $handle->finish();# closes query handle, frees up temporary Standard <(
( @' & $handle = undef;# tables and cursors Standard <(
( @' / $Db->disconnect();# closes database connection Standard <(
( @' + $Db = undef;# frees up temporary buffers Standard <(
( @'
Standard <(
( @' exit (0); Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg # JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel| oe ] xV4B1 H More Information
Home~LT~Titel <(
( @'
DrOb g SVDr &
c 3 Standard
c 3 xV4B1 S For more information on PL/SQL and running CGI scripts on the dbase machine, go to: Standard <(
( @' S Standard <(
( @' Standard <(
( @' Standard <(
( @' Please do not make your procedures for Homework 3 public. We have your Oracle passwords and will log in as you to test your homework. Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrPg JoeM `m R DrML 8 DrMD , DrOb SVDr & oe !
Home~LT~Titel{ oe \ xV4B1 G Other Languages
Home~LT~Titel <(
( @'
DrOb SVDr &
\ e mG Standard
\ e mG e
xV4B1 >
Z Simliar to the PERL interface, there are also interfaces for Java, C, and other languages: Standard <(
( @' Standard <(
( @' For information on JDBC: Standard <(
( @' Standard <(
( @' Standard <(
( @' Additionally, there is an easy way to get large amounts of data from a structured format into your database, called the SQL Loader. Example command line: Standard <(
( @' D ~oracle/bin/sqlldr userid=username/password control=foo logfile=log Standard <(
( @' Standard <(
( @' For more information: Standard <(
( @' Standard <(
( @' DrXX gg N Home~LT~Gliederung DrPg | JoeM T l DrML 8 DrMD , DrOb < SVDr & 5
B (0 ! DrOb SVDr & 3 OG #] #
Home~LT~Notizen 3 OG #] a xV4B1 L Click to add notes Home~LT~Notizen <(
( @' DrXX gg V Home~LT~Gliederung DrXX F HP LaserJet 4ML HP4ML_V1 PostScript H `T l `T l d ,,ssh isthmus lpr isthmus_queue HP4ML_V1 DrVw P SVDr
SVDr : SVDr { { SVDrA Layout : SVDr { { SVDr # SVDr SVDr# SVDr0 SVDr1 SVDr3 SVDr4 SVDr@ SVDr SVDrD SVDrP SVDrQ DrHL DrHL DrHL 1z DS
R o o t E n t r y !r\V )䰱 C o m p O b j E O l e
p e r s i s t e l e m e n t s " S f x D o c u m e n t I n f o u S f x W i n d o w s S f x S t y l e S h e e t s L S u m m a r y I n f o r m a t i o n ( 0 S t a r D r a w D o c u m e n t 3 $ - c