Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint
    Share this Page URL
    Help

    PART II SQL Development > CHAPTER 13 PL/SQL Programming Language

    image

    image

    racle introduced the PL/SQL programming language more than 20 years ago in the Oracle 6 database. PL/SQL provides a procedural extension to SQL and lets you call SQL from a PL/SQL program, or vice versa. This chapter introduces you to the basics of writing stored programs in Oracle 11g and provides a summary overview of PL/SQL. You can find more complete treatment in Oracle Database 11g PL/SQL Programming.

    Chapter 4 showed you the concept of transactional units built with combinations of INSERT, UPDATE, and DELETE statements. It also introduced Transactional Control Language (TCL). With PL/SQL, you bring the two together to write powerful database-centric programs.

    In this chapter you'll learn the basics of writing PL/SQL programs. The chapter covers the following topics:


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial