Guerrilla Oracle: The Succinct Windows Perspective
Guerrilla Oracle: The Succinct Windows Perspective
ISBN: 0201750775
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 84
Pages: 84
Authors: Richard Staron
- Main Page
- Table of content
- Copyright
- Preface
- A Note about Typography
- Acknowledgments
- Chapter 1. Introduction
- Welcome
- Oracle8 i and 9 i the Guerrilla Way
- Chapter 2. The Three Most Important Dates
- Dr. Edgar F. Codd, Radical Thinker
- Storage Technology Becomes System R
- Beep Beep Here Comes Oracle Passing IBM on the Information Highway
- Chapter 3. Concepts
- Relational Databases
- The Server Environment
- SQL Programming Languages
- Development Tools
- Oracle Web
- Other Oracle Modules
- Thin and Thick Clients
- Endnotes
- Chapter 4. Business Opportunity
- Chapter 5. Finalizing the Tables for the Waiver Exam
- Refining the Tables
- Data and Relationships
- Chapter 6. The Major Parts of an Oracle Windows Installation
- Concepts
- Major Parts of the Installation
- Chapter 7. Installing the Oracle 8 i and 9 i Database Server
- The Installation
- Chapter 8. Security
- System Security
- Data Security
- User Security
- Password Management Policy
- Auditing
- Building Your Security Schema
- Waiver Database Security
- Chapter 9. Creating the Tables
- Overview
- Table Creation Syntax
- Creating the Tables
- The Entire Table Creation Script
- The Output Spool File
- Loading the Tables
- Chapter 10. The Data Dictionary
- What Is the Data Dictionary?
- How Does the Data Dictionary Work?
- The Data Dictionary Views
- Chapter 11. Installing the Oracle 8 i and 9 i Client
- The Installation
- Adding Another Service
- In Case of Failure
- Chapter 12. DBA Tasks
- System Upgrades
- Oracle Licensing
- Startup and Shutdown
- Backup and Recovery
- Database Instances
- Modification and Tuning
- Chapter 13. Forms 6 i
- Installing Forms 6 i
- Creating a Simple Form
- Running the Form
- Creating Real GUI Forms
- The Splash Screen
- The Main Screen
- Chapter 14. Guerrilla Toolbox
- Simple Report Writing
- Calculations
- Queries
- Date Handling
- Sequences
- Manipulating Letters and Numbers
- Some Interesting Verbs and Adverbs You Should Know
- Triggers
- Feeding Other Systems
- Linking to Access
- i SQLPlus
- Chapter 15. The Web
- Appendix A. Forms 6 i Security
- Bibliography
Guerrilla Oracle: The Succinct Windows Perspective
ISBN: 0201750775
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 84
Pages: 84
Authors: Richard Staron
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Using Data Control Language (DCL) to Setup Database Security
- Creating Indexes for Fast Data Retrieval
- Using Keys and Constraints to Maintain Database Integrity
- Working with Comparison Predicates and Grouped Queries