Our website is currently undergoing technical upgrades to serve you better. We’ll be back online shortly.
Oracle PL/SQL by Example

Oracle PL/SQL by Example

          
5
4
3
2
1

Available


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Quantity:
Add to Wishlist

About the Book

If you are working with Designer/2000, Oracle's powerful set of tools for information systems design and generation, this book will serve as your indispensable guide. Not only does it provide detailed and understandable documentation for every component of Designer/2000, it also shows how and when each of these tools comes into play in the context of the information systems development life-cycle. You will learn how these tools operate, how they should be used, and most importantly, how to adapt the information systems development process to take full advantage of their capabilities.The OracleA (R) Designer/2000 Handbook includes: * documentation for all of Designer/2000's strategy, analysis, design, and code-building tools, including the Process Modeller, the Entity-Relationship Diagrammer, the Database Design Wizard, the Data Diagrammer, the Application Design Wizard, the DDL Generator, and much more; * an overview of the development process, with a work flow road map detailing the specific steps to take when building an application with Designer/2000; * information on designing and generating forms and reports, including use of the Module Data Diagrammer, templates, and User Preferences; * advice on how to customize the Designer/2000 toolset to improve your productivity; * an explanation of how to capture existing applications with Designer/2000. As you discover the purpose and significance of each Designer/2000 tool, you will gain invaluable insight into the software development process and how you can use Designer/2000 to create systems that better serve your clients. 0201634457B04062001

Table of Contents:
Preface. I. INTRODUCTION. Overview of Contents. Conventions Used in This Book. How to Get the Most Out of This Book. 1. The Philosophy of Software Engineering. Progress of Development Work and Decision Compression. Is Designer/2000 Difficult to Learn and Use? The Development Team. Magic versus Technology. Cross-Checking. II. COMPONENTS OF THE DESIGNER/2000 PRODUCT. 2. Designer/2000 Components. Brief Description of Designer/2000 Components. Primary and Secondary Access Elements (PACs and SACs). III. OVERVIEW OF WORK FLOW WITH DESIGNER/2000. 3. The Full-Life Cycle Approach. Functions and Entities. Function to Entity Cross-References. Business Units and Their Function Associations. Transformation of Strategy and Analysis Phases into the Design and Implementation Phases Within the Designer/2000 Repository. Refinement of the Database Design, Part 1. Program Transformation. Menu Transformation. Refinement of the Database Design, Part 2. Refinement of Module Design After Module Is Created with Default Design Utilities. Template Design and Module Generation. Generation. User Documentation. 4. Alternative Work Flow: Straight to Design. 5. Alternative Work Flow: Capturing an Existing Application. Reverse Engineer the Data Design. Refine the Reverse-Engineered Data Design. Reverse Engineer the Programs. Create a Default Logical Data Model and Logical Function Model. Continue with (Re)Design. IV. TOOLS THAT SPAN THE DEVELOPMENT LIFE CYCLE. General GUI Characteristics. Two Dreadfully Important Commands to Understand (How Not to Delete Something Accidentally). 6. The Help System. How to Get Help On-Line. Annotating the Help Text. Cue Cards. On-Line Tutorial. Suggested Exercises: 1. 7. Repository Object Navigator. Application Window. Object Hierarchy Window. Properties Window. Application Window: Application System Commands. Application Window: Navigation Commands. Application Window: General Commands. Application Window: Property Commands. Object Hierarchy Window Commands. Properties Window Commands. 8. Repository Reports. Reports That Should Become Your Best Friends. Custom Reports. Section V. CONCEPTS THAT SPAN THE DEVELOPMENT LIFE CYCLE. 9. Application Systems Within Designer/2000. What Does Designer/2000 Mean by "Application System"? 10. Domains. When Should I Use a Domain? Can I Use Domains Instead of Reference Entities? Domain Hierarchies. Why Use Domains? Domain Properties. Domain Allowable Values. Useful Domain Reports. Useful Domain Utilities. 11. Document. A Useful Document Report. Suggested Exercises: 2. VI. DESIGNER/2000 STRATEGY AND ANALYSIS TOOLS. 12. Entity Relationship Diagrammer. Diagram Syntax. Diagram Commands. Embedded Objects in the Diagram. Entity Definition Tab (Edit Entity). Synonym Definition Tab (Edit Entity). Relationship Definition Tab (Edit Relationship). Attributes Tab (Edit Entity). Attribute Detail Tab (Edit Entity). Attribute Values Tab (Edit Entity). Unique Identifier Definition Tab (Edit Entity). Text Tab (Edit Entity). Useful Entity, Attribute, or Relationship Reports. Suggested Exercises: 3. 13. Function Hierarchy Diagrammer. Diagram Syntax. Diagram Commands. Function Definition Tab (Edit Function). Common Function Tab (Edit Function). Triggers Tab (Edit Function). How Can We Use Functions Triggering Functions? Function Entity Usages Tab (Edit Function). Defining Function/Entity Associations: The CRUDMatrix. Function Attribute Usages Tab (Edit Function). Useful Function Reports. Suggested Exercises: 4. 14. Dataflow Diagrammer. Role of Dataflow Diagrams Within Designer/2000. Definitions of Terms. Diagram Commands. Datastore Definition Tab (Edit Datastore). Datastore Contents Tab (Edit Datastore). Dataflow Definition Tab (Edit Dataflow). Dataflow Contents Tab (Edit Dataflow). Useful Dataflow and Datastore Reports. 15. Matrix Diagrammer. Diagram Commands. Useful Matrix-Oriented Reports. Suggested Exercises: 5. 16. Process Modeller. Diagram Layout. But We Aren't Re-engineering Our Business! Should We Use the Process Modeller Anyway? How Does the Oracle Process Modeller Help? Why Is This Diagrammer Presented "Out of Order"? Diagram Element Types. Diagram Display Modes. Definition of Terms. Diagram Commands. Organization (Business Unit). Main Tab (Edit Process Step). Specific Tab (Edit Process Step). Resources Tab (Edit Process Step). Multimedia Tab (Edit Process Step). Multimedia Select Dialog Box. Main Tab (Edit Flow). Specific Tab (Edit Flow). Resources Tab (Edit Flow). Multimedia Tab (Edit Flow). Useful Process Modeller Reports. Suggested Exercises: 6. 17. Completing the Strategy and Analysis Phases. VII. TRANSFORMING THE LOGICAL DATA MODEL INTO THE PHYSICAL DATA DESIGN. 18. Database Design Wizard. Database Design Wizard Tabs. Prepare Physical Definitions. Table Mappings Tab (Database Design Wizard). Run Options Tab (Database Design Wizard). Options Tab (Database Design Wizard). Column Mappings, Primary Keys, and Foreign Keys Tabs (Database Design Wizard). Indexes Tab (Database Design Wizard). Summary of the Work Process Up to Data Transformation. Suggested Exercises: 7. Gee Whiz!! Where Did All Those Horrible Column Names Come from? And Where Did Those EXTRA Columns Come from?! Two Problems and an Example. Getting Better Foreign Key Column Names. A Snippet of Interesting Code. Limitations and Warnings. But What About Those Extra Columns? Can I Safely Get Rid of Some of Those Columns? VIII. DESIGNER/2000 DATA DESIGN TOOLS. 19. Data Diagrammer. Diagram Syntax. Table Definition Tab (Edit Table). Column Definition Tab (Edit Table). Column Display Tab (Edit Table). Key Constraints Tab (Edit Table). Constraints. Validation Tab (Edit Table). Defining Views and Snapshots. View Definition Tab (Edit View). Defining a View. Base Relations Tab (Edit View). Base Cols Tab (Edit View). Completing the Definition of a View. Snapshot Definition Tab (Edit Snapshot). Completing the Definition of a Snapshot. Useful Database Design Reports. The Table Quality Control Report Explained. Suggested Exercises: 8. IX. DESIGNER/2000 PROGRAM DESIGN TOOLS. A Brief Overview of the Generation Process. Inputs to the Generators. The Generation Process. 20. Application Design Wizard. What to Expect. Rules of Operation. Application Design Wizard Checklist. 21. Module Structure Diagrammer. Structure of This Section. Using the Module Structure Diagrammer. Definition of Terms. Diagram Syntax. Diagram Commands. How the Generators Implement the Module Network. 22. Defining Modules. Module Definition Tab (Edit Module). Implements Tab (Edit Module). User Access Tab (Edit Module). Group Access Tab (Edit Module). Suggested Exercises: 9. Defining Characteristics for Client Module Types. Client Details Definition Tab (Edit Module). Parameters Tab (Edit Module). Using Parameters in a Report. Completing the Definition of a Forms or Report Module. Defining PL/SQL Server Code Modules. Server Details Definition Tab (Edit Module). Parameters Tab (Edit Module). Program Data Tab (Edit Module). Datastructure Tab (Edit Module). Sample PL/SQL Package-Declarative Method. Sample PL/SQL Package-Free Format Method. Sample PL/SQL Package-Operating System Method. 23. Module Data Diagrammer. Diagram Syntax. Definition of Terms. Diagram Commands. Table Details Tab (Detailed Usages for Screen Module). Table Layout Tab (Detailed Usages for Screen Module). Table Text Tab (Detailed Usages for Screen Module). Usage Tab (Detailed Usages for Screen Module). Column Detail Tab (Detailed Usages for Screen Module). Column Display Tab (Detailed Usages for Screen Module). Column Text Tab (Detailed Usages for Screen Module). Suggested Exercises: 10. Defining Report Modules. Table Details Tab (Detailed Usages for Report Module). Column Detail Tab (Detailed Usages for Report Module). Column Display Tab (Detailed Usages for Report Module). Column Text Tab (Detailed Usages for Report Module). Module Data Usage Utilities. 24. Module Logic Navigator. Features. Commands. Useful Module Reports. Suggested Exercises: 11. 25. Preferences Navigator. Definition of Terms. Commands. X. DESIGNER/2000 CODE BUILDING TOOLS. 26. Server Generator. Utilities to Generate DDL. Selection Tab (Generate DDL). Objects Tab (Generate DDL). Options Tab (Generate DDL). Utilities to Reconcile Repository Object Definitions. 27. Generate Module and Generate Module As. Generate, Regenerate, Reverse-Engineer? What's the Difference? Generate Tab (Generate Form). Form Option Tab (Generate Form). Other Tab (Generate Form). Generating Menus with Security. 28. Code Templates. What Effect Do Templates Have? Forms-Specific Template Information. Interaction Between the Template and Preferences. Reports-Specific Template Information. 29. Regenerate Form. Customizing Generated Forms Code: Regeneration. A Helpful Regeneration Report. 30. Reference Values, Help Text, and Code Controls. Suggested Exercises: 12. 31. Advanced Tips and Tricks. How Do I get the DDL Generator to Recognize Schemas? What If I Don't Know the Tablespace Names? Specifying the Template at Generate Time. Getting Generated Error Messages in Languages Other Than English. Navigation Tips. Automatically Querying a Block on Entry to the Form. Automatically Querying Based on Prior Context from Another Form. Context-Showing Users What's Next on the Form (or What's Past). Creating One Form for Both Character and GUI Mode. Security. Filtering What RON Shows. XI. CUSTOMIZING YOUR DESIGNER/2000 TOOLSET. 32. The Underlying Repository Database Design. Repository Objects. Properties and Property Types. Suggested Exercises: 13. Answers to Exercises. 33. User Extensibility. 34. Creating Your Own Utilities and Reports: Using the API. Why Use the API? Components of the API. Major Components of an API Program. A Sample API Program. API Components and Their Use. Where to Find More Information. Suggested Exercises: 14. XII. MANAGING THE DESIGNER/2000 REPOSITORY. 35. Repository Administration. Maintain Users Tab. Granting a User Access to an Application. Sharing and Transferring Objects. Performance Tips. Code Configuration Control. XIII. GOING BACKWARD: CAPTURING AN EXISTING APPLICATION. 36. Reverse Engineer DDL. Reverse Engineering DDL. Sample Utility-The Case of the Missing Constraints. 37. Reverse Engineer Forms and Reports. 38. Utility to Table Entity Retrofit. Things to Check Before You Retrofit. Running the Retrofit Utility. Refining the Retrofitted Logical Data Model. XIV. ASSIMILATING DESIGNER/2000 INTO YOUR SOFTWARE DEVELOPMENT PROCESS. Keep an Eye on the Big Picture. Consider the Way You Work. A. Installing the Sample Applications. B. Sample Survey. Survey 1: About Designer/2000. Survey 1 Answers. C. Suggestions for Further Reading. D. Web Site Contents. E. Detailed Tasks of a Designer/2000 Project. Purpose of This Appendix. Beginning a New Application. Upper Case Phase One: Strategy Stage. Upper Case Phase Two: Analysis Stage. Lower Case Phase One: Design Stage. Lower Case Phase Two: Build Stage. Index. 0201634457T04062001


Best Sellers


Product Details
  • ISBN-13: 9780201634457
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison-Wesley Educational Publishers Inc
  • Height: 189 mm
  • No of Pages: 624
  • Series Title: Prentice Hall Professional Oracle
  • Weight: 1057 gr
  • ISBN-10: 0201634457
  • Publisher Date: 23 Nov 1996
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Spine Width: 31 mm
  • Width: 234 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Oracle PL/SQL by Example
Pearson Education (US) -
Oracle PL/SQL by Example
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle PL/SQL by Example

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA