O'Reilly logo

Oracle PL/SQL For Dummies by Paul Dorsey, Michael Rosenblum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2

The PL/SQL Environment

In This Chapter

bullet Installing the Oracle database

bullet Using tools

bullet Understanding users and connections

bullet Looking at sample data

Before you can start working with PL/SQL, you need a place to write and run your programs as well as a database (preferably populated with some sample data) that your programs can interact with. You might be lucky enough to be working at a company where someone can help you set up and install everything. Or, you might be completely on your own and need to do everything yourself.

Installing an Oracle environment isn’t the same as installing a simple Windows application. You can’t just put the CD in the drive and have it all magically install for you. You need to set up the right environment. This involves installing the Oracle database and the necessary tools to allow you to write, edit, and debug the code. In this chapter, you discover what you need to do to start writing and testing your PL/SQL code.

Depending upon your particular system configuration and where you’re working, you might need some help from a database administrator ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required