Skip to Content
Oracle PL/SQL Programming, Third Edition
book

Oracle PL/SQL Programming, Third Edition

by Steven Feuerstein, Bill Pribyl
September 2002
Intermediate to advanced
1024 pages
30h 52m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL Programming, Third Edition

Predefined Object Types

Oracle9i implements a collection of useful, predefined object types. These include:

XMLType

Use this to store and manipulate XML data.

Various URI types

Use these to store uniform resource identifiers (such as HTML addresses).

Various “Any” types

Use these to define a PL/SQL variable that can hold any type of data.

In the following sections, we provide brief introductions to these predefined object types and then point you to sources of more information.

The XMLType Type

XML (Extensible Markup Language) is fast becoming a very important technology to understand. Did we say “fast becoming”? Strike that—XML is important right now, and the predefined object type XMLType enables you to store XML data in an Oracle database and manipulate that XML data from within SQL and PL/SQL.

XML is a huge subject that we can’t hope to cover in detail. Instead, we will settle for familiarizing you with XMLType so that you understand how important it is and what you can do with it. To learn more about using XML with Oracle, we recommend Steve Muench’s book, Building Oracle XML Applications (O’Reilly). To learn more about XML in general, you might try Learning XML by Erik T. Ray (O’Reilly).

Tip

In Oracle9i Release 1, you need to use the “SYS.” prefix when referencing the XMLType object type. Release 2 allows synonyms to point to object types, and the database creation script ($ORACLE_HOME/rdbms/admin/dbmsxmlt.sql) that creates XMLType now also creates the public synonym XMLTYPE, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Oracle PL/SQL Programming, 6th Edition

Oracle PL/SQL Programming, 6th Edition

Steven Feuerstein, Bill Pribyl
Oracle PL/SQL Programming, 5th Edition

Oracle PL/SQL Programming, 5th Edition

Steven Feuerstein, Bill Pribyl
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham

Publisher Resources

ISBN: 0596003811Catalog PageErrata