17190544 tutorial for oracle10g forms
TRANSCRIPT
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 1/20
Tutorial for Oracle10g Forms /Reports
(Version 3.0)
by: David Zhu (IT Analyst)
Reviewed by: Joe Callaghan
School of Business Administration
Oakland University
Rochester, MI 483!"44#
March$ %&
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 2/20
Prerequisite:
'ou have an Oracle account on Oracle server and you have Oracle10gDevelo(er )uite installed and con*igured to the Oracle#+ )erver onyour orkstation$
'ou have created a )tudent ta-le ./0102)00U), MJOR, )5,)0R02)M, )0R02'R, )0UD6M7 in Oracle data-ase -y usingOracle#g Designer or )9:1lus$
'ou have -asic 19:)9 knoledge$
Lesson 1
In this lesson you will learn:
What is Orale10g !or"s#$e%orts
Tools %ro&i'e' y Orale10g !or"s#$e%orts to reate !or"s an' $e%orts
ow to log on to Orale10g !or"s#$e%orts
*reate your +irst lo, an' +or" ase' on your -tu'ent tale
;hat Is Oracle10g /or<s=Re(orts>
Orale10g !or"s#$e%orts is an Orale tool that hel%s you to reate weenale' +or"s an' re%orts ase' on the tales that you ha&e reate' usingOrale10g /esigner or -L Plus o""an's. -tarting +ro" Orale10g Orale10g!or"s#$e%orts has eo"e one o+ Orale10g /e&elo%er -uite o"%onents. 2ouan use Orale10g !or"s#$e%orts to:
/esign an' usto"ie your +or"s an' re%orts.
A'' &arious +untionality li,e ra'io uttons o"o o4es an' list o+&alues to "a,e your +or"s an' re%orts "ore user +rien'ly.
Write triggers on your o5ets to a'' +untionality to the" an' a%tureerrors.
We enale your !or"s or $e%orts on a 'e&elo%"ent ser&er.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 3/20
0ools 1rovided ?y Oracle10g /or<s=Re(orts
Orale Orale10g !or"s#$e%orts %ro&i'es +our tools:
O5et 6a&igator: In this tool you an &iew all your o5ets a'' new
o5ets an' na"e#rena"e your o5ets.
Layout 7'itor: This tool hel%s you 'esign your +or"s an' re%orts an' a''&arious o5ets to the" li,e %ush uttons an' list o4es.
PL#-L 7'itor: This is the tool that is use' to write all the o'es +or thetriggers %roe'ures or +untions.
8enu 7'itor: This tool will hel% you reate a usto"ie' "enu that ane attahe' to your +or" or re%ort.
9ogging On to Oracle10g /or<s=Re(orts
1. To log on to Orale10g !or"s#$e%orts go to -tart Progra"sOrale10g /e&elo%er -uite !or"s /e&elo%er li, -tart O*9
Instane .@ery i<(ortantA 'ou <ust kee( OC4J running hileusing Oracle10g /or<s=Re(orts BBB7, a+ter O*9 initialie' then
li, !or"s ;uil'er.
<. I""e'iately you will see the win'ow +or !or"s ;uil'er:
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 4/20
3. /oule li, /ata ;lo,s -elet =>se the /atalo, Wiar'= an' li,O?This is the easiest "etho' to 'esign a new +or".
9. 2ou will now see the Welo"e to the /atalo, Wiar' Win'ow. *li,6e4t to %roee'.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 5/20
@. 2ou will now see the win'ow +or the /atalo, Wiar'. -elet Tale orView as in the +igure an' li, 6e4t.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 6/20
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 7/20
B. One you li, rowse the onnet win'ow will a%%ear. Ty%e in youruserna"e %asswor' an' 'ataase to onnet to the 'ataase.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 8/20
C. 2ou will now see the tales win'ow. -elet urrent users an' tales an'li, O?.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 9/20
D. 2ou will now see the list o+ tales reate' in your 'ataase. -elet-tu'ents an' li, O?.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 10/20
10.2ou will now see your selete' tale an' its a&ailale olu"ns on yoursreen. *li, on the single right arrow to selet the +irst olu"n to eshown in your +or"E in this ase the -T>/I/ olu"n. 2ou will now see
this olu"n un'er the 'ataase ite"s selete' suwin'ow.
11.To "o&e the rest o+ the olu"ns si"%ly li, on the 'oule right arrowan' this will selet all your olu"ns in to the 'ataase ite"s.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 11/20
1<.2ou will now see the *ongratulations win'ow. 8a,e sure that F*reatethe 'ata lo, then all the Layout Wiar'F is selete' an' li, on!inish.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 12/20
13.2ou will now see the Layout Wiar' Welo"e win'ow li, ne4t. 2ouwill see the +ollowing sreen li, ne4t.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 13/20
19. selet the ite"s that you woul' li,e to show in the +or". 8a,e sure thatthe 'ata lo, selete' is -tu'ents an' then li, the 'oule right arrowto "o&e all the olu"ns o+ the -tu'ent lo, +ro" the a&ailale ite"s tothe 'is%laye' ite"s. *li, on 6e4t to ontinue.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 14/20
[email protected] win'ow with the %ro"%t +or the height an' wi'th o+ the ite"s willa%%ear. *li, 6e4t to ae%t the 'e+ault &alues.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 15/20
[email protected] Layout Wiar' will now %ro"%t you to selet the layout or &iew styleo+ your lo,. -elet !or" an' li, 6e4t.
1.The Layout Wiar' will now %ro"%t you to selet a title +or the +or"that you are reating. Ty%e in -tu'ent $eor's. *li, 6e4t to ontinue.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 16/20
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 17/20
1C.2ou will now see the an&as &iew o+ the +or" that you ha&e reate'. 2ouan now a'' &arious o5ets li,e %ush uttons o"o o4es an' ra'io
uttons to your +or" to "a,e it "ore gra%hial an' user +rien'ly. Wewill 'o this in the ne4t lesson.
1D.2ou an now +or"at the +or" "anually. *li, on the +ra"e to selet it.Then 'rag the +ra"e to "a,e it igger.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 18/20
<0.2ou an now s%ae out the 'ata +iel's to "a,e your +or" "ore &isuallya%%ealing. 2ou an 'o this y si"%ly seleting the 'ata +iel' an''ragging it to your 'esire' area.
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 19/20
<1.A+ter you ha&e +or"atte' all the 'ata +iel's your +or" shoul' loo, li,ethe +ollowing:
8/20/2019 17190544 Tutorial for Oracle10g Forms
http://slidepdf.com/reader/full/17190544-tutorial-for-oracle10g-forms 20/20
9esson )u<<ary
In this lesson you ha&e learne':
What is Orale10g !or"s#$e%orts
Tools %ro&i'e' y Orale10g !or"s#$e%orts to reate !or"s an' $e%orts
ow to log on to Orale10g !or"s#$e%orts
To reate a 'ata lo,
To reate a asi +or" ase' on a tale that you ha' reate'.
ow to &iew your +or" in the an&as.
6e4t you will learn to a'' "ore o5ets an' +untionality to your asi
+or". !or this %roee' to Lesson <.