تفاصيل الدورة

Sophisticated graphical reports are possible with Oracle10g ODS Reports. This product is one of the most complex yet powerful graphical reporting tools available. With sufficient training, even some of the most complex reporting requirements can be satisfied using this tool. This course is presented in an intensive workshop format where participants absorb the complex topics of object hierarchies, frame hierarchies, field-level control of report output and many other subjects.

Prerequisites:
  • The course Oracle Database 10g: Introduction to SQL 
  • The course Oracle Database 10g: Program With PL/SQL

Suggested Next Course
  • The course Introduction To Java Language Programming
  • The course Oracle AS Discoverer 10g: Create Queries & Reports
INTRODUCTION TO ORACLE10g ODS & REPORTS :
  • ABOUT ORACLE10g ODS
  • ABOUT THE ORACLE10g ENTERPRISE ARCHITECTURE 
  • SMP
  • MORE ABOUT ORACLE REPORTS
INTRODUCING THE REPORTS BUILDER WIZARDS:
  • AN INTRODUCTION TO THE WIZARDS 
  • WELCOME DIALOG WIZARD
  • REPORT WIZARD 
REPORT WIZARD PRODUCTIVITY FEATURES :
  • RE-ENTERING THE WIZARDS
  • USING THE QUERY BUILDER TOOL 
BUILDING MASTER-DETAIL REPORTS:
REPORTS BUILDER INTERFACE – THE REPORT EDITOR :
REPORTS BUILDER INTERFACE – THE OBJECT NAVIGATOR & PROPERTY INSPECTOR:
  • MORE ABOUT THE REPORTS BUILDER INTERFACE
  • USING THE OBJECT NAVIGATOR 
  • WORKING WITH THE OBJECT NAVIGATOR
  • THE VIEW MENU
  • THE TOOLS MENU 
  • ABOUT THE PROPERTY INSPECTOR
FIELD FORMATTING:
  • ABOUT FIELD FORMATTING 
  • CHARACTER FORMATTING 
  • PAPER LAYOUT FORMATTING 
  • CONDITIONAL FORMATTING
THE GRAPH WIZARD:
  • ABOUT THE GRAPH WIZARD
  • COMPLETING THE GRAPH WIZARD FOR WEB OUTPUT 
  • COMPLETING THE GRAPH WIZARD FOR PAPER OUTPUT
  • MODIFYING THE GRAPH
REPORTS BUILDER INTERFACE – THE FILE MENU:
  • USING THE FILE MENU
  • MODULE & SESSION CONTROL
  • REPORT DISTRIBUTION
  • MODULE ADMINISTRATION
REPORTS BUILDER INTERFACE – EDITING PREFERENCES:
DATA MODEL VIEW – ENHANCING PROTOTYPE REPORTS:
  • USING THE DATA MODEL VIEW
  • USING THE DATA WIZARD 
  • WORKING WITH DATA MODEL VIEW OBJECTS
LAYOUT OBJECTS:
  • ABOUT THE LAYOUT OBJECTS 
  • MORE ABOUT THE PAPER LAYOUT VIEW 
  • WHAT ARE THE LAYOUT OBJECTS?
  • ADDING STANDARD OBJECTS
  • ADDING WEB PROPERTIES TO OBJECTS 
  • THE REPORT BLOCK WIZARD
ADVANCED DATA MODELS – MULTI-GROUP & MULTI-BLOCK REPORTS:
  • ABOUT THIS REPORT
  • BUILDING THE REPORT 
  • CUSTOMIZING THE LAYOUT & FILTERING DATA
ADVANCED DATA MODELS – MATRIX REPORTS:
  • ABOUT MATRIX REPORTS 
  • DEFINING A MATRIX REPORT 
  • CUSTOMIZING A MATRIX REPORT
  • NESTED MATRIX REPORTS
UTILIZING REPORT PARAMETERS :
  • WHAT ARE PARAMETERS? 
  • SETTING PARAMETER VALUES 
EMPLOYING PL/SQL:
  • MORE ABOUT PL/SQL & ORACLE REPORTS
  • REPORT LEVEL TRIGGERS 
  • PROGRAM UNITS 
  • PL/SQL LIBRARIES
USING TEMPLATE FILES:
  • ABOUT TEMPLATES 
  • LAYOUT OBJECTS WITHIN TEMPLATES
تحديث بتاريخ 08 November, 2015

نبذة عن معهد Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
عرض الجميع دورات Professional Training Solutions Ltd
Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Oracle ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو