- PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. PL/SQL's general syntax resembles that of Ada.
- Throw (something) forcefully in a specified direction
- deposit; "cast a vote"; "cast a ballot"
- Throw (something) so as to cause it to spread over an area
- the actors in a play
- project: put or send forth; "She threw the flashlight beam into the corner"; "The setting sun threw long shadows"; "cast a spell"; "cast a warm light"
- Direct (one's eyes or a look) at something
pl sql cast - Beginning PL/SQL:
Beginning PL/SQL: From Novice to Professional (Expert's Voice in Oracle)
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features.
Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.
Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well.
Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.
What you’ll learn
How important SQL is in PL/SQL
How to use PL/SQL in both a relational and object-relational setting
How to create maintainable, modular, and reusable PL/SQL program units
The importance of testing as you go, and of building a permanent test plan for each module
The importance of building debugging capabilities into your code and building a permanent debug facility for each module
The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
How to apply modular PL/SQL to solve real-world problems
Who this book is for
Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
Oracle For Professionals
Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly used business database models.
It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle's flagship database management system along with existing features found in Oracle Database 9i and 10g.
Expert PL/SQL Practices Book Cover
This is a book on PL/SQL best practices that I contributed a chapter.
pl sql cast
Ramp Up Your PL/SQL Programming Skills
Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.
Understand the Oracle development architecture and the mechanics of connections
Work with data types, structures, blocks, cursors, and PL/SQL semantics
Write, deploy, and use functions, procedures, and packages
Manage transactions and more
Use dynamic SQL statements in real-world applications
Support online transaction processing and data warehousing applications with external tables
Find syntax samples and best practices to solve problems
Write, deploy, and use object types
For a complete list of Oracle Press titles, visit www.OraclePressBooks.com