Day 1: Learning the Basics of PL/SQL

PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. Here's how to get started using it.

provided by: 
Originally published at Internet.com


Congratulations on your decision to read this book, Sams Teach Yourself PL/SQL in 21 Days, Second Edition! If you are new to the Oracle environment, this book will help you learn and master Oracle's built-in procedural language quickly. Knowledge of PL/SQL (Procedural Language/Structured Query Language) is becoming a fundamental necessity no matter which of Oracle's many products you use.

Today, on your first day, you will accomplish these tasks: *

Learn what PL/SQL is and why you should master it *

Learn how PL/SQL relates to other Oracle products *

Learn what resources you need to finish this book *

Write your first PL/SQL function

Over the remaining 20 days, you'll delve deeper into the power and capabilities of this language and learn how to leverage its power in your applications regardless of whether you are doing client/server programming with Oracle's tools (such as Developer/2000), using other front-end tools (such as PowerBuilder), or simply writing some batch jobs that run on the server.

What Is PL/SQL?



PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. --------------------------------- ...

Read article at Internet.com site
Related Articles
- Using More Advanced JDBC Features
Expand your basic knowledge of connecting to a database from a Java application using JDBC. Discover how to use just about any database application you may want. In this example its a Microsoft Access database.
- Cross Apply and Outer Apply Operators
Regional Articles
- Day 1: Learning the Basics of PL/SQL Alabama
- Day 1: Learning the Basics of PL/SQL Alaska
- Day 1: Learning the Basics of PL/SQL Arizona
- Day 1: Learning the Basics of PL/SQL Arkansas
- Day 1: Learning the Basics of PL/SQL California
- Day 1: Learning the Basics of PL/SQL Colorado
- Day 1: Learning the Basics of PL/SQL Connecticut
- Day 1: Learning the Basics of PL/SQL DC
- Day 1: Learning the Basics of PL/SQL Delaware
- Day 1: Learning the Basics of PL/SQL Florida
- Day 1: Learning the Basics of PL/SQL Georgia
- Day 1: Learning the Basics of PL/SQL Hawaii
- Day 1: Learning the Basics of PL/SQL Idaho
- Day 1: Learning the Basics of PL/SQL Illinois
- Day 1: Learning the Basics of PL/SQL Indiana
- Day 1: Learning the Basics of PL/SQL Iowa
- Day 1: Learning the Basics of PL/SQL Kansas
- Day 1: Learning the Basics of PL/SQL Kentucky
- Day 1: Learning the Basics of PL/SQL Louisiana
- Day 1: Learning the Basics of PL/SQL Maine
- Day 1: Learning the Basics of PL/SQL Maryland
- Day 1: Learning the Basics of PL/SQL Massachusetts
- Day 1: Learning the Basics of PL/SQL Michigan
- Day 1: Learning the Basics of PL/SQL Minnesota
- Day 1: Learning the Basics of PL/SQL Mississippi
- Day 1: Learning the Basics of PL/SQL Missouri
- Day 1: Learning the Basics of PL/SQL Montana
- Day 1: Learning the Basics of PL/SQL Nebraska
- Day 1: Learning the Basics of PL/SQL Nevada
- Day 1: Learning the Basics of PL/SQL New Hampshire
- Day 1: Learning the Basics of PL/SQL New Jersey
- Day 1: Learning the Basics of PL/SQL New Mexico
- Day 1: Learning the Basics of PL/SQL New York
- Day 1: Learning the Basics of PL/SQL North Carolina
- Day 1: Learning the Basics of PL/SQL North Dakota
- Day 1: Learning the Basics of PL/SQL Ohio
- Day 1: Learning the Basics of PL/SQL Oklahoma
- Day 1: Learning the Basics of PL/SQL Oregon
- Day 1: Learning the Basics of PL/SQL Pennsylvania
- Day 1: Learning the Basics of PL/SQL Rhode Island
- Day 1: Learning the Basics of PL/SQL South Carolina
- Day 1: Learning the Basics of PL/SQL South Dakota
- Day 1: Learning the Basics of PL/SQL Tennessee
- Day 1: Learning the Basics of PL/SQL Texas
- Day 1: Learning the Basics of PL/SQL Utah
- Day 1: Learning the Basics of PL/SQL Vermont
- Day 1: Learning the Basics of PL/SQL Virginia
- Day 1: Learning the Basics of PL/SQL Washington
- Day 1: Learning the Basics of PL/SQL West Virginia
- Day 1: Learning the Basics of PL/SQL Wisconsin
- Day 1: Learning the Basics of PL/SQL Wyoming
Related Articles
- Using More Advanced JDBC Features
Expand your basic knowledge of connecting to a database from a Java application using JDBC. Discover how to use just about any database application you may want. In this example its a Microsoft Access database.
- Cross Apply and Outer Apply Operators

Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin

Topics:
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML