Oracle应用 express 入门指南

需积分: 11 40 浏览量更新于2024-07-27 收藏 18.49MB PDF 举报

"Beginning Oracle Application Express 是一本专为初学者设计的Oracle Application Express(APEX)入门教程。作者Rick Greenwald通过深入浅出的方式引导读者理解并掌握如何使用APEX构建应用程序。书中涵盖从基础到高级的各种主题，包括数据库基础知识、快速启动APEX应用、扩展应用功能、验证与计算、导航与列表、报告与图表、组件协同工作、用户界面定制、PL/SQL编程以及安全性和部署策略等。此外，还涉及了打包应用程序和迁移等实际应用场景。" 本书分为三个部分： 1. **Part I: Introducing Oracle Application Express** - 引入了Oracle APEX的基础概念，包括Oracle数据库的基础知识，以及为何选择APEX作为开发工具。第一章"Welcome to Oracle!"介绍了Oracle公司和其在数据库领域的地位，为后续学习打下基础。 2. **Part II: Building an Application with Application Express** - 这部分详细讲解了如何使用APEX构建应用程序。从第二章"Jumpstart Oracle Application Express"开始，读者将逐步学会创建和扩展应用程序，包括添加验证、计算、导航和列表等功能。第五章"Reporting and Charting"介绍了数据可视化的重要性和如何在APEX中创建报告和图表。 3. **Part III: Deploying the Application** - 最后一部分关注的是应用的部署和管理。第十章"Deployment and Administration"讨论了如何将应用上线并进行日常管理。第十一章"Packaged Applications"讲解了如何使用和配置预打包的应用程序。第十二章"Migration"则探讨了在不同环境之间迁移应用程序的方法。附录包括索引，便于读者查找特定主题。本书适合对数据库和Web开发感兴趣，希望通过Oracle APEX快速上手的初学者。通过阅读本书，读者可以系统地学习到从设计到部署的完整流程，从而成为一名熟练的Oracle APEX开发者。

88372flast.indd 14 11/10/08 9:53:47 PM

Introduction

Oracle Application Express is an easy-to-use application development environment built on the Oracle

technology stack. There are two aspects of that previous sentence that you may ﬁnd jarring — that

Oracle, a company widely known for its database technology, has an application development environ-

ment, and that Oracle, a company thought of as delivering high-end, enterprise-ready technology, has

anything that is easy to use.

But, as this book will show, the introductory statement is completely accurate. Oracle Application Express,

commonly known as Oracle APEX or simply APEX, does beneﬁt from the long-established enterprise-

class robustness that is the hallmark of Oracle technology. The applications you build will be able to

support hundreds of users and many terabytes of data, scalability far beyond even the imagination of

most other development environments.

And Oracle APEX, with its declarative, wizard-driven methodology, is truly easy to use. In the course of

the few hundred pages of this book, you will not only learn about how to use APEX, you will create a usable

order entry system. The fast learning curve presented in these pages is a consequence of many years of

development and reﬁnement of the APEX product, which began life almost a decade ago within Oracle.

By the end of this volume, you will know enough to create your own applications, as well as having the

knowledge and understanding of Oracle APEX and the world of Oracle technology to explore further

reﬁnements on your own.

Best of all, you can use APEX with absolutely no cost — either in a hosted environment, as suggested in

Chapter 1, or with a free version of the Oracle database.

Welcome to the world of Oracle Application Express!

Who This Book Is For

This book is aimed at a particular group of users — those who are not familiar with Oracle Application

Express. The book assumes that you have a basic knowledge of application development, the type you

could get from playing around with a personal database such as Access. In fact, this book was written with

an Access developer in mind — an Access developer looking to step up to a more scalable and reliable envi-

ronment, with reduced maintenance overhead and greater integration between application systems.

What T his Book Covers

This book covers the use of Oracle Application Express. Although the book is based on the 3.5 version,

you can use the book with older versions as well. However, since the book will use a hosted version of

Oracle Application Express, and since both the Oracle database that supports the product and the prod-

uct itself are available as free downloads from

http://otn.oracle.com, you should be able to use the

latest version easily.

88372flast.indd 15 11/10/08 9:53:47 PM

Introduction

xvi

How This Book Is Structured

This book is structured to give the reader a gradual introduction to the essentials of development with

Oracle Application Express. The book contains the following chapters:

Chapter 1: Welcome to Oracle! — This chapter contains an overview of Oracle Application Express, as

well as instructions on how to set up a hosted development environment for performing the exercises

used in the book.

Chapter 2: Jumpstart Oracle Application Express — In this chapter, you will leap into creating appli-

cations with Oracle Application Express and ﬁnish a simple application by the end of the chapter.

Chapter 3: Extending Your APEX Application — This chapter will introduce you to the options in

Oracle APEX that let you ensure that your users will enter correct data while using your application.

Chapter 4: Validation, Calculation, Navigation, and Lists — This chapter continues the exploration of

the aspects of APEX that help you to ensure that data used in your application is correct. Additionally,

the chapter covers basic navigation options for your application.

Chapter 5: Reporting and Charting — This chapter covers the powerful and ﬂexible reports you can

create with Oracle APEX, and introduces you to the graphical capabilities of APEX reporting.

Chapter 6: Components Working Together — This chapter extends your work with charts, showing

how you can create charts that link to a more detailed view of the data they represent. You will also

learn how to create a calendar page with links to the data shown as part of the calendar, and how to add

images taken from the underlying database to an Oracle APEX report.

Chapter 7: Customizing User Interfaces — This chapter explores advanced options for customizing

user interfaces, on individual pages as well as across your entire APEX application.

Chapter 8: PL/SQL — This chapter introduces you to PL/SQL, the underlying language used to imple-

ment your APEX application, and demonstrates how to use the power of PL/SQL to extend the logic in

your application.

Chapter 9: Security — This chapter covers how security is implemented for your APEX environment.

Chapter 10: Deployment and Administration — This chapter covers the options you have for deploying

an APEX application to another environment and walks you through one of those options. Additionally,

this chapter introduces you to the administrative functionality you can use to monitor and manage

your APEX applications.

Chapter 11: Packaged Applications — This chapter gives an overview of packaged applications avail-

able for Oracle Application Express, with a more detailed look at a select few.

Chapter 12: Migration — This chapter describes how to migrate applications from Microsoft Access to

Oracle Application Express.

88372flast.indd 16 11/10/08 9:53:47 PM

Introduction

xviii

Source Code

As you work through the examples in this book, you may choose either to type in all the code manually

or to use the source code ﬁles that accompany the book. All of the source code used in this book is avail-

able for downloading at

www.wrox.com. Once at the site, simply locate the book’s title (either by using

the Search box or by using one of the title lists) and click the Download Code link on the book’s detail

page to obtain all the source code for the book.

Because many books have similar titles, you may ﬁnd it easiest to search by ISBN; this book’s ISBN is

978-0-470-38837-2.

Once you download the code, just decompress it with your favorite compression tool. Alternately, you

can go to the main Wrox code download page at

www.wrox.com/dynamic/books/download.aspx to

see the code available for this book and all other Wrox books.

Errata

We make every effort to ensure that there are no errors in the text or in the code. However, no one is perfect,

and mistakes do occur. If you ﬁnd an error in one of our books, such as a spelling mistake or faulty piece of

code, we would be very grateful for your feedback. By sending in errata you may save another reader hours

of frustration, and at the same time you will be helping us provide even higher-quality information.

To ﬁnd the errata page for this book, go to

www.wrox.com and locate the title using the Search box or

one of the title lists. Then, on the book details page, click the Book Errata link. On this page you can

view all errata that has been submitted for this book and posted by Wrox editors. A complete book list,

including links to each book’s errata, is also available at

www.wrox.com/misc-pages/booklist.shtml.

If you don’t spot “your” error on the Book Errata page, go to

www.wrox.com/contact/techsupport

.shtml

and complete the form there to send us the error you have found. We’ll check the information

and, if appropriate, post a message to the book’s errata page and ﬁx the problem in subsequent editions

of the book.

p2p.wrox.com

For author and peer discussion, join the P2P forums at p2p.wrox.com. The forums are a web-based

system for you to post messages relating to Wrox books and related technologies and interact with other

readers and technology users. The forums offer a subscription feature to email you topics of interest of

your choosing when new posts are made to the forums. Wrox authors, editors, other industry experts,

and your fellow readers are present on these forums.

http://p2p.wrox.com you will ﬁnd a number of different forums that will help you not only as you

read this book but also as you develop your own applications. To join the forums, just follow these steps:

1. Go to p2p.wrox.com, and click the Register link.

2. Read the terms of use, and click Agree.

88372flast.indd 18 11/10/08 9:53:47 PM

剩余385页未读，继续阅读

yangyangman0

粉丝: 4
资源: 1

Oracle应用 express 入门指南

Beginning Oracle Application Express.part2.rar

Beginning Oracle Application Express.part1.rar

Beginning Oracle Application Express 4.2(Apress,2ed,2013)

Beginning Oracle Application Express 5, 3rd Edition

beginning_oracle_application_express_4.2_2nd_edition

基于微信小程序的社区门诊管理系统php.zip

白色大气风格的设计师作品模板下载.zip

工程经济学自考必备软件下载

UML课程设计报告.doc

白色大气风格响应式彩绘精品水果网站模板.zip

最新资源