DEVELOPER 2000/ORACLE FORMS/REPORTS

<body topmargin=0 leftmargin=0 marginheight=0 marginwidth=0> <script type="text/javascript"> //OwnerIQ var __oiq_pct = 50; if( __oiq_pct>=100 || Math.floor(Math.random()*100/(100-__oiq_pct)) > 0 ) { var _oiqq = _oiqq || []; _oiqq.push(['oiq_addPageBrand','Lycos']); _oiqq.push(['oiq_addPageCat','Internet > Websites']); _oiqq.push(['oiq_addPageLifecycle','Intend']); _oiqq.push(['oiq_doTag']); (function() { var oiq = document.createElement('script'); oiq.type = 'text/javascript'; oiq.async = true; oiq.src = document.location.protocol + '//px.owneriq.net/stas/s/lycosn.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(oiq, s); })(); } //Google Analytics var _gaq = _gaq || []; _gaq.push(['_setAccount','UA-21402695-19']); _gaq.push(['_setDomainName','tripod.com']); _gaq.push(['_setCustomVar',1,'member_name','tlr46',3]); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); //Lycos Init function getReferrer() { var all= this.document.cookie; if (all== '') return false; var cookie_name = 'REFERRER='; var start = all.lastIndexOf(cookie_name); if (start == -1) return false; start += cookie_name.length; var end = all.indexOf(';', start); if (end == -1) end = all.length; return all.substring(start, end); } function getQuery() { var rfr = getReferrer(); if (rfr == '') return false; var q = extractQuery(rfr, 'yahoo.com', 'p='); if (q) return q; q = extractQuery(rfr, '', 'q='); return q ? q : ""; } function extractQuery(full, site, q_param) { var start = full.lastIndexOf(site); if (start == -1) return false; start = full.lastIndexOf(q_param); if (start == -1) return false; start += q_param.length; var end = full.indexOf('&', start); if (end == -1) end = full.length; return unescape(full.substring(start, end)).split(" ").join("+"); } function generateHref(atag, template){ atag.href=template.replace('_MYURL_', window.location.href.replace('http://', '')).replace('_MYTITLE_','Check%20out%20this%20Tripod%20Member%20site!'); } var lycos_ad = Array(); var lycos_onload_timer; var cm_role = "live"; var cm_host = "tripod.lycos.com"; var cm_taxid = "/memberembedded"; var tripod_member_name = "tlr46"; var tripod_member_page = "tlr46/microlynk/id3.htm"; var tripod_ratings_hash = "1745730667:abb70f65fa12765af316523b80389b1e"; var lycos_ad_category = {"dmoz":"science\/social_sciences","ontarget":"&CAT=news&L2CAT=science%20and%20technology","find_what":"paris"}; var lycos_ad_remote_addr = "209.202.244.9"; var lycos_ad_www_server = "www.tripod.lycos.com"; var lycos_ad_track_small = ""; var lycos_ad_track_served = ""; var lycos_search_query = getQuery(); </script> <script type="text/javascript" src="https://scripts.lycos.com/catman/init.js"></script> <script type='text/javascript'> var googletag = googletag || {}; googletag.cmd = googletag.cmd || []; (function() { var gads = document.createElement('script'); gads.async = true; gads.type = 'text/javascript'; var useSSL = 'https:' == document.location.protocol; gads.src = (useSSL ? 'https:' : 'http:') + '//www.googletagservices.com/tag/js/gpt.js'; var node = document.getElementsByTagName('script')[0]; node.parentNode.insertBefore(gads, node); })(); </script> <script type='text/javascript'> googletag.cmd.push(function() { googletag.defineSlot('/95963596/TRI_300X250_dfp', [300, 250], 'div-gpt-ad-1450204159126-0').addService(googletag.pubads()); googletag.defineSlot('/95963596/TRI_above_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-1').addService(googletag.pubads()); googletag.defineSlot('/95963596/TRI_below_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-2').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.enableServices(); }); </script> <script type="text/javascript"> (function(isV) { if( !isV ) { return; } var adMgr = new AdManager(); var lycos_prod_set = adMgr.chooseProductSet(); var slots = ["leaderboard", "leaderboard2", "toolbar_image", "toolbar_text", "smallbox", "top_promo", "footer2", "slider"]; var adCat = this.lycos_ad_category; adMgr.setForcedParam('page', (adCat && adCat.dmoz) ? adCat.dmoz : 'member'); if (this.lycos_search_query) { adMgr.setForcedParam("keyword", this.lycos_search_query); } else if(adCat && adCat.find_what) { adMgr.setForcedParam('keyword', adCat.find_what); } for (var s in slots) { var slot = slots[s]; if (adMgr.isSlotAvailable(slot)) { this.lycos_ad[slot] = adMgr.getSlot(slot); } } adMgr.renderHeader(); adMgr.renderFooter(); }((function() { var w = 0, h = 0, minimumThreshold = 300; if (top == self) { return true; } if (typeof(window.innerWidth) == 'number' ) { w = window.innerWidth; h = window.innerHeight; } else if (document.documentElement && (document.documentElement.clientWidth || document.documentElement.clientHeight)) { w = document.documentElement.clientWidth; h = document.documentElement.clientHeight; } else if (document.body && (document.body.clientWidth || document.body.clientHeight)) { w = document.body.clientWidth; h = document.body.clientHeight; } return ((w > minimumThreshold) && (h > minimumThreshold)); }()))); window.onload = function() { var f = document.getElementById("FooterAd"); var b = document.getElementsByTagName("body")[0]; b.appendChild(f); f.style.display = "block"; document.getElementById('lycosFooterAdiFrame').src = '/adm/ad/footerAd.iframe.html'; // DOM Inj Ad (function(isTrellix) { var e = document.createElement('iframe'); e.style.border = '0'; e.style.margin = 0; e.style.display = 'block'; e.style.cssFloat = 'right'; e.style.height = '254px'; e.style.overflow = 'hidden'; e.style.padding = 0; e.style.width = '300px'; var isBlokedByDomain = function( href ) { var blockedDomains = [ "ananyaporn13000.tripod.com", "xxxpornxxx.tripod.com" ]; var flag = false; for( var i=0; i<blockedDomains.length; i++ ) { if( href.search( blockedDomains[ i ] ) >= 0 ) { flag = true; } } return flag; } var getMetaContent = function( metaName ) { var metas = document.getElementsByTagName('meta'); for (i=0; i<metas.length; i++) { if( metas[i].getAttribute("name") == metaName ) { return metas[i].getAttribute("content"); } } return false; } var getCommentNodes = function(regexPattern) { var nodes = {}; var nodesA = []; var preferredNodesList = ['a', 'c', 'b']; (function getNodesThatHaveComments(n, pattern) { if (n.hasChildNodes()) { if (n.tagName === 'IFRAME') { return false; } for (var i = 0; i < n.childNodes.length; i++) { if ((n.childNodes[i].nodeType === 8) && (pattern.test(n.childNodes[i].nodeValue))) { var areaName = pattern.exec(n.childNodes[i].nodeValue)[1]; nodes[areaName] = n; } else if (n.childNodes[i].nodeType === 1) { getNodesThatHaveComments(n.childNodes[i], pattern); } } } }(document.body, regexPattern)); for (var i in preferredNodesList) { if (nodes[preferredNodesList[i]]) { if( isTrellix && nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode ) { nodesA.push(nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode); } else { nodesA.push( nodes[preferredNodesList[i]] ); } } } return nodesA; } var properNode = null; var areaNodes = getCommentNodes( new RegExp( '^area Type="area_(\\w+)"' ) ); for (var i = 0; i < areaNodes.length; i++) { var a = parseInt(getComputedStyle(areaNodes[i]).width); if ((a >= 300) && (a <= 400)) { properNode = areaNodes[i]; break; } } var propertyName = getMetaContent("property") || false; if( isTrellix && (properNode) ) { e.src = '/adm/ad/injectAd.iframe.html'; properNode.insertBefore(e, properNode.firstChild); } else if( isTrellix && !( properNode ) ) // Slap the ad eventhought there is no alocated slot { e.src = '/adm/ad/injectAd.iframe.html'; e.style.cssFloat = 'none'; var cdiv = document.createElement('div'); cdiv.style = "width:300px;margin:10px auto;"; cdiv.appendChild( e ); b.insertBefore(cdiv, b.lastChild); } else if( !isBlokedByDomain( location.href ) ) { var injF = document.createElement('iframe'); injF.style.border = '0'; injF.style.margin = 0; injF.style.display = 'block'; injF.style.cssFloat = 'none'; injF.style.height = '254px'; injF.style.overflow = 'hidden'; injF.style.padding = 0; injF.style.width = '300px'; injF.src = '/adm/ad/injectAd.iframe.html'; if( b && ( !isTrellix || ( typeof isTrellix == "undefined" ) ) ) // All other tripod props { var cdiv = document.createElement('div'); cdiv.style = "width:300px;margin:10px auto;"; cdiv.appendChild( injF ); b.insertBefore(cdiv, b.lastChild); } } }( document.isTrellix )); } </script> <div id="tb_container" style="background:#DFDCCF; border-bottom:1px solid #393939; position:relative; z-index:999999999!important">  <style> .adCenterClass{margin:0 auto} </style> <div id="tb_ad" class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;"> <div id="ad_container" style="display:block!important; float:left; width:728px "> <script type="text/javascript"> if (typeof lycos_ad !== "undefined" && "leaderboard" in lycos_ad) { document.write(lycos_ad['leaderboard']); } </script> </div> </div> </div> <script type="text/javascript"> if (typeof lycos_ad !== "undefined" && "slider" in lycos_ad) { document.write(lycos_ad['slider']); } </script>  <div id="FooterAd" style="background:#DFDCCF; border-top:1px solid #393939; clear:both; display:none; width:100%!important; position:relative; z-index:999999!important; height:90px!important"> <div class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;"> <div id="footerAd_container" style="display:block!important; float:left; width:728px"> <iframe id="lycosFooterAdiFrame" style="border:0; display:block; float:left; height:96px; overflow:hidden; padding:0; width:750px"></iframe> </div> </div> </div> <table cellpadding=0 cellspacing=0 border=0><tr> <td valign="top" colspan=3 height=90 BGCOLOR="#888888" TEXT="#080000"> <div> <B>   MICROLYNK</b><B> LTD</b><FONT SIZE="6" COLOR="#000000" FACE="Arial" ><B> </b></FONT><FONT SIZE="1" COLOR="#000000" FACE="Arial" ><B> | </b></FONT><FONT SIZE="2" COLOR="#000000" FACE="Arial" ><B>  </b></FONT><FONT SIZE="2" COLOR="#FFFFFF" FACE="Arial" ><B> </b></FONT><FONT SIZE="2" COLOR="#FFFFFF" FACE="Arial" ><B> </b><A HREF="index.htm" TARGET="_top" TITLE=" MICROLYNK"><U><B>home</b></U></A></FONT></div> <DIV ALIGN="LEFT"></DIV> <div> <A HREF="id2.htm" TARGET="_top" TITLE="COMPANY PORTFOLIO"><U>COMPANY PORTFOLIO</U></A>   |   <A HREF="id21.htm" TARGET="_top" TITLE="INTRO TO ORACLE"><U>INTRO TO ORACLE</U></A>   |   <A HREF="id20.htm" TARGET="_top" TITLE="ORACLE PL/SQL"><U>ORACLE PL/SQL</U></A>   |   <A HREF="id4.htm" TARGET="_top" TITLE="ADVANCED ORACLE"><U>ADVANCED ORACLE</U></A>   |   <B>DEVELOPER 2000/ORACLE FORMS/REPORTS</b>   |   <A HREF="id16.htm" TARGET="_top" TITLE="SQL SERVER"><U>SQL SERVER</U></A>   |   <A HREF="id17.htm" TARGET="_top" TITLE="DATABASE MODELING"><U>DATABASE MODELING</U></A>   |   <A HREF="id18.htm" TARGET="_top" TITLE="DB2 PROGRAMS"><U>DB2 PROGRAMS</U></A>   |   <A HREF="id19.htm" TARGET="_top" TITLE="IMS"><U>IMS</U></A>   |   <A HREF="id15.htm" TARGET="_top" TITLE="UNIX SYSTEMS"><U>UNIX SYSTEMS</U></A>   |   <A HREF="id6.htm" TARGET="_top" TITLE="FACULTY RESUMES"><U>FACULTY RESUMES</U></A></div> <div> </div> </td> </tr><tr> <td valign="top" width=185 BGCOLOR="#888888" TEXT="#080000"> <div>  <img src="HTMLobj-67/aniGif.gif" border="0" align="bottom" width="100" height="100">  </div> <div> <B>COURSE LINKS:</b></div> <div> <B>Developer 2000: </b><A HREF="id3_m.htm#dev_2000_objectives" TARGET="TRLX_Middle" TITLE="DEVELOPER 2000/ORACLE FORMS/REPORTS"><U><B>Course Objectives</b></U></A></div> <div> <A HREF="id3_m.htm#contents" TARGET="TRLX_Middle" TITLE="DEVELOPER 2000/ORACLE FORMS/REPORTS"><U><B>Table of Contents</b></U></A></div> <div> <A HREF="id3_m.htm#forms_wizard" TARGET="TRLX_Middle" TITLE="DEVELOPER 2000/ORACLE FORMS/REPORTS"><U><B>Forms Wizard</b></U></A></div> <div> <B>Oracle Reports  and Forms :  </b><A HREF="id3_m.htm#forms_5_0" TARGET="TRLX_Middle" TITLE="DEVELOPER 2000/ORACLE FORMS/REPORTS"><U><B>Course Objectives</b></U></A></div> <div> <A HREF="id3_m.htm#forms_5_0" TARGET="TRLX_Middle" TITLE="DEVELOPER 2000/ORACLE FORMS/REPORTS"><U><B>Forms 5.0</b></U></A></div> </td> <td valign="top" height=390 BGCOLOR="#FFFFFF" TEXT="#080000"> <div> <I><B> </b></I><I><B>DEVELOPER 2000/ORACLE FORMS/REPORTS</b></I></div> <div> <I><B>                           <img src="HTMLobj-112/aniGif.gif" border="0" align="bottom" width="96" height="77">  </b></I></div> <div> <TABLE BORDER="0" CELLPADDING="2" CELLSPACING="1" WIDTH="586" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="BOX" RULES="ALL" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 4792 WIDTH="580"><div> <B>O</b><FONT SIZE="4" COLOR="#0000FF" FACE="Arial" ><B>racle Developer 2000 </b></FONT></div> <div> <B>               (5 days)</b><B> <A NAME="dev_2000_objectives"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></b></div> <bR> <div> <B>Course Description:</b></div> <bR> <div> <B>This five day class is for beginning to intermediate Oracle </b></div> <div> <B>developers and programmers.</b><B> </b></div> <bR> <div> <B>Course Objectives:</b></div> <bR> <div> <B>The class will cover course material and lab enhancement </b></div> <div> <B>exercises developed to master the following objectives:</b></div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Techniques to employ the Oracle GUI interfaces and Object</div> <div>        Navigator</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Identifying the capabilities and performance features of Developer </div> <div>        2000</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Utilizing Oracle <B>FORMS</b> for creating simple screens</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Exercises on using Forms to create Master/Detail</div> <div>       screens </div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Modifying data using Oracle Forms and restricting <B>INSERT/UPDATE/DELETE </b>capabilities</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Produce examples from ORACLE <B>REPORTS</b> in developing </div> <div>        simple reports</div> <bR> <div> <B><IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">MASTER/DETAIL</b> reports using multiple table data</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Allowing customers to<B> TRANSFER</b> data into a report for sharper presentations</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Forms, Tabular, Master/Detail and Label <B>REPORTS</b> are produced</div> <div>        by participants</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Utilizing Oracle<B> GRAPHICS</b> to produce bar, pie and line graphs</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Creating <B>MENUS</b> to use Forms, Reports & Graphs</div> <bR> <div> <B>========================================================</b></div> <div> <B>================================================</b><FONT SIZE="3" COLOR="#111111" FACE="Arial" ><B>==</b></FONT><B>======</b></div> <div> <B>                   </b><FONT SIZE="4" COLOR="#0000FF" FACE="Arial" ><B>DEVELOPER 2000</b></FONT></div> <div> <FONT SIZE="3" COLOR="#0000FF" FACE="Arial" ><B>                     </b></FONT><B>TABLE OF CONTENTS</b><B> <A NAME="contents"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></b></div> <bR> <div> <B>I.      INTRODUCTION TO DEVELOPER 2000</b></div> <div>      <B>OBJECTIVES</b><FONT SIZE="3" COLOR="#FF0033" FACE="Arial" ><B> <img src="HTMLobj-159/aniGif.gif" border="0" align="bottom" width="100" height="60">  </b></FONT></div> <bR> <div>      A.    DEVELOPER 2000 GUI<B> INTERFACES</b> & <B>WIZARDS</b></div> <bR> <div>      B.    DEVELOPER 2000 Components</div> <div>  </div> <div>      C.    Utilizing DEVELOPER 2000 Together.</div> <bR> <bR> <div> <B>II     ORACLE FORMS</b></div> <bR> <div>      <FONT SIZE="3" COLOR="#000000" FACE="Arial" ><B>OBJECTIVES</b></FONT><FONT SIZE="2" COLOR="#000000" FACE="Arial" > </FONT></div> <bR> <div>      A.  Single Table <B>SCREEN</b> Development</div> <bR> <div>      B.  <B>PARENT/CHILD</b> Screen Development</div> <bR> <div>      C.  Connecting Referential Integrity Constraints to data</div> <bR> <div>      D.  <B>EDITING</b> The CANVAS</div> <bR> <div>      E.  CREATING Form <B>TRIGGERS</b></div> <bR> <div>      F.  CREATING <B>MENUS</b></div> <bR> <div> <B>III     ORACLE REPORTS</b></div> <bR> <div>      <FONT SIZE="3" COLOR="#000000" FACE="Arial" ><B>OBJECTIVES</b></FONT></div> <bR> <div>      A.  Understanding the <B>REPORT LAYOUT</b> EDITOR</div> <bR> <div>      B.  BUILDING A QUERY WITH REPORTS</div> <bR> <div>      C.  MULTIPLE TABLE ACCESS </div> <bR> <div>      D.  Using the <B>EDITOR,FONTS</b> and <B>GRAPHICS</b></div> <bR> <div>      D.  Passing <B>PARAMETERS</b> Using REPORTS</div> <div> <B>IV     ORACLE  <img src="HTMLobj-160/aniGif.gif" border="0" align="bottom" width="100" height="60">  </b></div> <bR> <div>      <FONT SIZE="3" COLOR="#000000" FACE="Arial" ><B>OBJECTIVES</b></FONT></div> <bR> <div>      A.  Understanding the <B>GRAPHICS  EDITOR</b></div> <bR> <div>      B. <B> BUILDING</b> An X-Y Axis <B>QUERY</b> With GRAPHICS</div> <bR> <div>      C.  Displaying GRAPHICS as <B>PIE & BAR CHARTS</b></div> <bR> <div> <B>IV     ORACLE MENUS</b></div> <div> <FONT SIZE="2" COLOR="#0000FF" FACE="Arial" >     </FONT><B>OBJECTIVES</b><B> <img src="HTMLobj-168/aniGif.gif" border="0" align="bottom" width="65" height="59">  </b></div> <bR> <div>      A.  Understanding the <B>MENU FORMATS</b></div> <bR> <div>      B.  Building A Simple <B>MENU</b></div> <bR> <div>      C.  Using the <B>DEFAULT MENUDEF</b> Menu</div> <div> <B>=================================================</b></div> <div> <B>=================================================</b></div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B>ORACLE FORMS 5.0</b><B> <A NAME="forms_5_0"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></b></div> <div> <B>(4 days)</b></div> <div> <B>Course Description:</b></div> <bR> <div> <B>This  is a four day class for beginning to intermediate Oracle </b></div> <div> <B>developers and programmers. </b></div> <bR> <div> <B>Course Objectives:</b></div> <div> <B>                                             </b><B> <img src="HTMLobj-157/aniGif.gif" border="0" align="bottom" width="84" height="40">  </b></div> <div> <B>To master  the Oracle GUI interfaces and Object Navigator. This will</b></div> <div> <B>include the following tasks completed in class discussion and </b></div> <div> <B>through lab exercises:</b></div> <div>                                                              </div> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Identify the capabilities and performance features of Developer 2000</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Employing Oracle <B>FORMS</b> for creating simple screens</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Learning to use Forms to create Master/Detail screens </div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Modifying data using Oracle Forms and restricting <B>INSERT/UPDATE</b></div> <div> <B>       /DELETE</b> capabilities</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">How to call/access <B>REPORTS</b> from a Form</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Forms Wizards to produce forms using multiple table </div> <div>        data</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Allowing customers to pass data into a <B>FORM</b> </div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Utilizing Oracle graphics to produce bar, pie and line graphs</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Creating menus to use Forms, Reports & Graphs</div> <bR> <bR> <div> <B>=======================================================</b></div> <div> <B>=======================================================</b></div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B>DEVELOPER 2000</b></div> <div> <B>TABLE OF CONTENTS</b><B> <A NAME="forms_wizard"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></b></div> <bR> <div> <B>I.      INTRODUCTION TO DEVELOPER 2000</b></div> <div>      </div> <div> <B>OBJECTIVES</b></div> <bR> <div> <FONT SIZE="3" COLOR="#000000" FACE="Arial" >     </FONT>A.  DEVELOPER 2000 GUI INTERFACES & WIZARDS                    </div> <bR> <div>      B.  DEVELOPER 2000 Components ...</div> <bR> <div>      C.  UTILIZING DEVELOPER 2000 TOGETHER</div> <bR> <bR> <div> <B>II     ORACLE FORMS</b></div> <bR> <div>      <FONT SIZE="2" COLOR="#000000" FACE="Arial" ><B>OBJECTIVES</b></FONT></div> <bR> <div>      <FONT SIZE="2" COLOR="#0000FF" FACE="Arial" >A.   SINGLE TABLE SCREEN DEVELOPMENT</FONT></div> <bR> <div>      B.   PARENT/CHILD SCREEN DEVELOPMENT</div> <bR> <div>      C.  CONNECTING REFERENTIAL INTEGRITY </div> <div>                    CONSTRAINTS TO DATA</div> <bR> <div>      D.   EDITING THE CANVAS</div> <bR> <div>      E.   CREATING FORM TRIGGERS</div> <bR> <div>      F.   CREATING MENUS</div> <div> <B>III     FORMS WIZARDS</b><FONT SIZE="3" COLOR="#000000" FACE="Arial" ><B>        <img src="HTMLobj-113/aniGif.gif" border="0" align="bottom" width="80" height="80">  </b></FONT></div> <div>                                                                             </div> <div>      <B>OBJECTIVES</b></div> <bR> <div> <FONT SIZE="3" COLOR="#000000" FACE="Arial" >     </FONT>A.  UNDERSTANDING AND USING <B>FORM WIZARD</b></div> <bR> <div>      B.  BOILER PLATE TEXT AND <B>GRAPHICS</b></div> <bR> <div>      C.  MULTIPLE TABLE ACCESS </div> <bR> <div>      D.  USING THE<B> EDITOR, FONTS</b> AND <B>GRAPHICS</b></div> <bR> <div>      E.  PASSING PARAMETERS FOR USE IN OTHER</div> <div>                    APPLICATIONS</div> <bR> <div> <B>I</b><B>V     ORACLE FORMS INTERFACING WITH REPORTS</b><B> </b></div> <div> <B>            AND   <img src="HTMLobj-132/aniGif.gif" border="0" align="bottom" width="100" height="60">  </b></div> <bR> <div>      <FONT SIZE="3" COLOR="#0000FF" FACE="Arial" ><B>OBJECTIVES</b></FONT></div> <bR> <div>      <FONT SIZE="2" COLOR="#000000" FACE="Arial" >A.  UNDERSTANDING THE </FONT> <FONT SIZE="2" COLOR="#000000" FACE="Arial" ><B>GRAPHICS  EDITOR</b></FONT></div> <bR> <div> <FONT SIZE="3" COLOR="#000000" FACE="Arial" >     </FONT>B.  BUILDING AN  X Y AXIS QUERY WITH <B>GRAPHICS</b></div> <bR> <div> <FONT SIZE="3" COLOR="#000000" FACE="Arial" >     C.  </FONT>DISPLAYING GRAPHICS AS<B> PIE & BAR CHARTS</b></div> <div> <B>IV     ORACLE MENUS <img src="HTMLobj-158/aniGif.gif" border="0" align="bottom" width="65" height="59">  </b></div> <bR> <div>      <FONT SIZE="3" COLOR="#0000FF" FACE="Arial" ><B>OBJECTIVES</b></FONT></div> <bR> <div>      <FONT SIZE="2" COLOR="#000000" FACE="Arial" >A.  UNDERSTANDING THE</FONT> <FONT SIZE="2" COLOR="#000000" FACE="Arial" ><B>MENU FORMATS</b></FONT></div> <bR> <div>      <FONT SIZE="2" COLOR="#000000" FACE="Arial" >B.  BUILDING A SIMPLE MENU</FONT></div> <bR> <div> <FONT SIZE="3" COLOR="#000000" FACE="Arial" >     </FONT>C.  USING THE <B>DEFAULT MENUDEF</b> MENU</div> <bR> <div> <B>====================================================</b></div> <div> <B>====================================================</b></div> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B>Oracle Reports 3.0  (3 days)</b></div> <bR> <div> <B>Course Description:</b></div> <bR> <div> <B>This is a three day class  for beginning to intermediate Oracle </b></div> <div> <B>developers and programmers. </b></div> <bR> <div> <B>Course Objectives:</b></div> <bR> <div> <B>Developers will master techniques of Oracle GUI interfaces and</b></div> <div> <B>Object Navigator.  These include experience in the following </b></div> <div> <B>course exercises/discussions.</b></div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Identifying the capabilities and performance features of Developer 2000</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Correct techniques to use <B>ORACLE REPORTS</b> for developing simple </div> <div>       reports</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Direct training on the use of<B> ORACLE WIZARDS</b> for developing simple </div> <div>       reports</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Master/Detail reports using multiple table data</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Allowing customers to format data into a report for an improved presentation effect</div> <bR> <div> <B><IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Forms, Tabular</b>, <B>Master/Detail</b> and <B>Label</b> reports are structured and produced in class</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Utilizing<B> Oracle Graphics</b> to produce bar, pie and line graphs</div> <bR> <div> <IMG BORDER="0" SRC="Symb075c00b700dcff000000.png" HEIGHT="15" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Creating menus to use Reports & Graphs</div> <bR> </tD> </tR> </TABLE></div> <bR> </td> <td valign="top" width=185 BGCOLOR="#888888" TEXT="#080000"> <div>  <img src="HTMLobj-68/aniGif.gif" border="0" align="bottom" width="100" height="100">  </div> <div> <B>The intermediate ORACLE classes include the Developer 2000 and the Oracle Forms and Reports sections</b></div> <div>  <embed src="HTMLobj-217/drat.wav" autostart="true" hidden="true">  </div> </td> </tr></table></body>