Home > Articles > Data > Oracle

This chapter is from the book

What Are Web Applications?

Advantages of Web Applications

Applications are software designed to meet a specified need. Word processing software, spreadsheet programs, and data entry tools are some examples of applications.

A Web application is just an application that is deployed on the Web. It is a Web page, or series of Web pages, allowing users to accomplish a task like obtaining information and forms, shopping, applying for a job, listening to Internet radio, or any of the many activities possible on the Web. To use a Web application, a user needs to know a URL for the application, and possibly a name and password. Another way to think of a Web application is a Web site offering a great deal of functionality.

Web pages are truly powerful when they are connected to a database. Such pages are referred to as database-driven pages. Pages are generated dynamically, and include up-to-the-minute information, without requiring someone to manually update the content of the Web page. Pages can provide current news, stock quote information, product availability data, or shipping information by retrieving information from a database at the time pages are requested. Users in turn conduct transactions directly with the database in real time. Connecting a Web page to a database truly makes for a powerful Web site. It is said that Web site programmers eventually find that they need to connect their site to a database, while database developers find that sooner or later their database needs to be accessible through the Web.

Businesses with a Web presence tend to be viewed as more competitive in the marketplace, and some conduct business entirely on the Web. Deploying an application on the Web gives an organization a way to extend their reach beyond the borders of the organization to the public directly. A Web site can be made publicly accessible to anyone with an Internet connection. Interactions with customers that were previously handled by phone, by mail, or in person can be handled via the Web. For example, consumers are familiar with the concept of an on-line retail store that lets users shop for goods and services, fill up a shopping cart, and "check out" their purchases by paying with a credit card.

Internet vs. Intranet

Organizations can set up an internal network, known as an intranet. An intranet protects the organization from having its internal files and confidential information accessed by someone outside the company. Intranets are often used to facilitate file sharing and email among members of an organization, while blocking access to outsiders.

Web applications can be deployed on an intranet, rather than the Internet. This simply means they are accessible to a smaller group of individuals. Web applications for internal use can be restricted to specific users, and in some cases, specific IP addresses.

When companies create custom applications tailored to meet their internal needs, they make a decision about what type of "front-end" to create, or what interface the users will work with when they use the application. Internal Web applications, restricted to specific users or computers, are increasingly popular within companies. Enterprise applications, which are larger applications used by every area of a company with the aim of every employee conducting business on the same, integrated system, are also being designed (or redesigned) for the Web.

Consider the advantages of using the Web from the company's perspective. An application that is not deployed on the Web typically requires employees to have some type of system software installed on their machines. Installation can be a time-consuming process that grows more burdensome as new versions of the software are released and must be installed on each computer. For example, an annoying screen problem is fixed in Version of the software, but you only have Version, so you need to install the update to fix the problem.

Monitoring is needed as people leave and join the company and as computers are reused. This is in sharp contrast to an internal Web site, which only requires a Web browser and an Internet connection. Web browsers come preinstalled on the majority of office computers, and many companies connect computers to networks as a matter of course. In Web architecture, which is discussed further in Chapter 2, application code is housed on server machines instead of on each computer. New versions of Web applications can be made available immediately to all users at the same time by making changes on the servers, instead of going to each individual user's machine.

Perhaps the main advantage of choosing a Web interface is that many employees are already familiar with it. The conventions of browsing the Web—clicking on links, navigating pages, entering data on forms—are fairly consistent. More people are using the Web for shopping or to retrieve information. Colleges and universities are producing more graduates accustomed to having sophisticated online services to register for classes, check their accounts, request transcripts, and update their personal information. When new applications require less training because they have a familiar look and feel, then a company can save a considerable amount of money in training.

Employees may also more readily accept a new application if the interface is a familiar and intuitive one, ensuring that a company's investment in software is a worthwhile one. An elegant and powerful system is neither if it is never used.

The ease of providing information to their employees on the Web has made companies increasingly think of ways to computerize and Web-enable their internal operations. Many organizations have an internal Web "home" site, restricted to employees only, for publishing relevant information and links. Internal sites are more than a way to communicate information. As a company computerizes more of its operations, an employee can conduct day-to-day business quickly and easily on the Web: request meeting rooms, fill out timesheets, request travel reimbursements, apply for internal job postings, and access up-to-date employee directories, to name a few possibilities. The relative ease of developing for the Web means that more and more business functions can be automated on-line. Although the "paperless office" is more of a dream than a reality, paperwork or processing time often can be minimized or eliminated by moving to a Web-based application.

Advantages of PL/SQL for Web Development

SQL is the industry-standard language for reading, inserting, updating, and deleting data in a database, so it is an essential part of creating dynamic Web pages. PL/SQL, or Procedural Language/Structured Query Language, is Oracle's extension to SQL. PL/SQL adds the sophisticated control structures of a procedural language, such as loops, if-then-else statements, variable declaration, and exception handling. It was first introduced by Oracle in 1988 and has continued to mature since its introduction. Oracle is committed to supporting PL/SQL, and regularly produces enhancements and refinements to the language.

Because PL/SQL is compiled and stored directly in the database, it has the distinct advantage of being fast. It does not require compilation or interpretation at runtime, and it interacts with the database quickly. Other existing technologies that generate Web content by making use of a database require many trips to and from the database. A JSP, ASP, or Perl script run on the server might go back and forth to the database while generating the HTML page. PL/SQL has the advantage of being in the database, so none of these back-and-forth trips are required.

The advantages in speed are particularly apparent as the volume of data being handled increases. The code is also reliable and secure. Backup and recovery processes for the database also save the PL/SQL code stored in the database. The security and access controls put in place for Oracle database objects, such as tables, also protect PL/SQL packages, procedures, and functions, which are themselves database objects.

As the title of this book promises, the PL/SQL language that is so effective at handling back-end processing can also generate the front-end application that the user sees. Oracle's 9i Application Server, previously known as the Oracle Application Server (OAS), is the middleware that enables the PL/SQL stored in the database to generate Web pages displayed in a browser. System architecture, middleware, and the Oracle 9iAS are described in more detail in Chapter 2.

Companies using the Oracle 9i database already have PL/SQL, since it is included with the database and does not require separate licensing. Companies using Oracle are also likely to have PL/SQL expertise in-house; there is a large knowledge base of PL/SQL programmers.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020