Oracle Built in Packages

Oracle Built in Packages, 9781565923751 (1565923758), O'Reilly, 1998

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example:

DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code.
DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory.
DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database.
DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs.

Comments

Amazing Books

Hands-On Networking with Azure: Build large-scale, real-world apps using Azure networking solutions

Packt Publishing, 2018

A step-by-step guide to get you up and running with Azure Networking Services and help you build solutions that leverage effective design patterns

Key Features

Learn best practices for designing and implementing Azure Networking for Azure VMs

Figure out the hidden secrets...

Advanced Raspberry Pi: Raspbian Linux and GPIO Integration

Apress, 2018

Jump right into the pro-level guts of the Raspberry Pi with complete schematics and detailed hardware explanations as your guide. You'll tinker with runlevels, reporting voltages and temperatures, and work on a variety of project examples that you can tune for your own project ideas..

This book is fully updated...

Computing Information Technology: The Human Side

IRM Press, 2003

From the senior management to the clerical and support group levels, this study addresses the possible pitfalls and triumphs of implementing information technology (IT) into organizations in terms of organizational strategies, structures, and communication methods. Issues of human-computer interaction, ethics, privacy, and security are raised to...

Mathematical Modeling for Complex Fluids and Flows

Springer, 2012

Mathematical Modeling for Complex Fluids and Flows provides researchers and engineering practitioners encountering fluid flows with state-of-the-art knowledge in continuum concepts and associated fluid dynamics. In doing so it supplies the means to design mathematical models of these flows that adequately express the engineering physics...

Digital Games: Computers at Play (The Digital World)

Chelsea House Publications, 2010

In 2006, about 67 percent of Americans played video games using a computer or game console such as PlayStation, Xbox, or Wii. Video games have come a long way since they were developed in the 1970s. In the past, game programs used a computer-like gadget that could be connected to the television. The players would look at the image on the...

Bailout Nation: How Greed and Easy Money Corrupted Wall Street and Shook the World Economy

John Wiley & Sons, 2009

An engaging look at what led to the financial turmoil we now find ourselves in

Bailout Nation offers one of the clearest looks at the financial lenders, regulators, and politicians responsible for the financial crisis of 2008. Written by Barry Ritholtz, one of today's most popular economic bloggers and a well-established...