2004Unpublished venueRequires access

Oracle Database 10g PL/SQL 101

Christopher S. Allen

Open publisher page 1 citations

Abstract

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned. Table of contents PART I Database Basics 1 Introduction to Databases 2 Storing and Retrieving Data: The Basics 3 Advanced Data Manipulation 4 Controlling SQL*Plus PART II Advanced SQL 5 SQL Functions 6 Using Indexes and Constraints 7 Other Useful Oracle Techniques PART III Create Programs Using PL/SQL 8 Introduction to PL/SQL 9 More PL/SQL ToolsGlossary of Common Oracle Terms

About this research paper

What this paper is about

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned. Table of contents PART I Database Basics 1 Introduction to Databases 2 Storing and Retrieving Data: The Basics 3 Advanced Data Manipulation 4 Controlling SQL*Plus PART II Advanced SQL 5 SQL Functions 6 Using Indexes and Constraints 7 Other Useful Oracle Techniques PART III Create Programs Using PL/SQL 8 Introduction to PL/SQL 9 More PL/SQL ToolsGlossary of Common Oracle Terms

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned. Table of contents PART I Database Basics 1 Introduction to Databases 2 Storing and Retrieving Data: The Basics 3 Advanced Data Manipulation 4 Controlling SQL*Plus PART II Advanced SQL 5 SQL Functions 6 Using Indexes and Constraints 7 Other Useful Oracle Techniques PART III Create Programs Using PL/SQL 8 Introduction to PL/SQL 9 More PL/SQL ToolsGlossary of Common Oracle Terms

Key concepts: PL/SQL, SQL/PSM, Computer science, Stored procedure, SQL, Database, Data definition language, Oracle

Related papers

Back to paper searchBrowse research topicsOriginal source
Oracle Database 10g PL/SQL 101 — Research Paper | ScholarLens