MCSE, Cisco, Oracle, Java, UNIX, Linux, Webmaster(CIW), ASP, .NET certification training offered here.

 
 

Oracle9i SQL 1Z0-007 : SQL*Plus And iSQL*Plus Reporting and PL/SQL

Product Code: or0710 Time: 3.0 hour(s) CEUs: Available
Back

Summary:
This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.

Objectives:

After completing this course, students will be able to:
  • Create a well formatted report with SQL Plus
  • Know when and how to use variables
  • Use iSQL Plus
  • Use Top-N Analysis
  • Identify the basic concepts of PL/SQL

Topics:

  • SQL Plus reports
  • Environment settings
  • Using environment settings
  • Variables and scripts
  • Generating reports
  • Reporting features
  • Running reports
  • Top-N queries
  • PL/SQL
  • Retrieving data in PL/SQL
  • Dynamic SQL
  • Control structures
  • Iteration and repitition

 
 
 

 
 
 

TechieCert.com Accepts Visa, MasterCard, Discover, American Express and PayPal
 

Accessibility || Affiliates || Befefits || Certifications || Contact Us || Corporate || Demo || FAQ || Features || Help || Home || Information || Instructional Design || Login || Orders || Privacy || Products || Proposed || Resources || Search || Site Map
 

©2004 - 2007 TechieCert.com
MCSE, Cisco, Oracle, Java, UNIX, Linux, Webmaster(CIW), ASP, .NET certification training offered here. MCSE, Cisco, Oracle, Java, UNIX, Linux, Webmaster(CIW), ASP, .NET certification training offered here.