Best Oracle Pl/SQL programming book
Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
0-9759135-7-3
ISBN 13
978-0975913574
Library of Congress Number: 2005928019
200 pages
Perfect bind - 9x7
PD 306
Shelving: Databases/Oracle Easy Oracle Series
# 2

  Easy Oracle PL/SQL Programming
Get Started Fast with Working PL/SQL Code Examples

John Garmany      

Retail Price $16.95 /  £11.95

Order now for 30% off with access to the code depot! Only $9.95
(30% off)
       
Key Features   About the Authors Table of Contents
Index   Reader Comments Errata
       
Get the Easy Oracle Pack
Five books for $59.95 - A $110.00 value
Easy Oracle Jumpstart $27.95
Easy Oracle PHP $27.95
Oracle DBA Made Simple (eBook) $19.95
Easy Oracle SQL $16.95
Easy Oracle PL/SQL Programming $16.95

 


Written by a distinguished graduate of West Point,  Garmany leverages his 20+ years of experience into an indispensable guide for any Oracle professional who must quickly implement Oracle reporting.

A noted instructor, author and lecturer, John Garmany leverages his ability to explain complex issues in Plain English into a one-of-a-kind book. John Garmany targets his decades of SQL*Plus experience into this must-have book. Intended for anyone who need to extract Oracle data and format reports, John reveals the secrets of quickly and easily producing stunning reports from Oracle.

Easy Oracle PL/SQL provides you with the tools you need to create, debug and execute PL/SQL code. The example driven methodology will have you coding basic PL/SQL blocks by the end of the first chapter. Each chapter will build on previous concepts, introducing you to increasingly more complex PL/SQL coding, while always focusing on readability and manageability.

Each concept is introduced using multiple examples and each chapter has exercises to test you knowledge. With Easy Oracle PL/SQL you will be able to put the incredible power of the Oracle Database to use with your application.

 

 
Key Features

* Learn PL/SQL basics, anonymous blocks, stored procedures and functions.

* Implement Best Practices to make your code readable and maintainable.

* Understand PL/SQL variable including user defined and abstract datatypes.

* Learn PL/SQL language structures including if/then/else and loops.

* Become skilled at handling exceptions.

* Learn to effectively use Cursors and Ref Cursors.

* Begin working with Collections, Arrays, and PL/SQL Tables.

* Improve performance with Bulk Collects and Loads.

* See the power of packages including creating and using packages.

* Call PL/SQL procedures and functions from applications.

* Run PL/SQL from a script or database job.

* Learn how to use triggers to react to database events.

About the Author:
 

John Garmany

 

John Garmany has been working as an Oracle DBA since 2002.

Table of Contents:

Chapter 1: Using SQL*Plus and iSQL*Plus.

Chapter 2: Incremental approach to Oracle reporting.

Chapter 3: Writing the SQL. 

Chapter 4: Spooling and viewing report output.   

Chapter 5: Formatting data. Creating summaries and breaks.


Index Topics:
%rowtype
%type
%TYPE
A
ADA
AND/OR logical operators
anonymous blocks
author table
B
book table
Boolean
Boolean logic
bulk collect
BULK COLLECT INTO
C
C++
Cartesian product
CASE statement
CASE_NOT_FOUND
CLOSE statement
COLLECTION_IS_NULL exception
constant
COUNT
CURSOR FOR
cursor%isopen
D
Data Definition Language
Data Manipulation Language
datatype
dba_objects
dbms_output.put_line
DDL
DECLARE clause
DELETE method
DESCRIBE command
determinate loop
DISTINCT clause
DML
drop function
dynamic SQL
E
ELSIF
END clause
END IF
END LOOP
EXECUTE IMMEDIATE clause
EXIST method
EXIT statement
EXIT WHEN
EXTEND method
F
FETCH clause
FIRST method
Flow control
FOR ALL ROWS clause
FOR loop
FORALL clause
function
functions
G
GOTO statement
H
HTML-DB
I
IBM
IF/THEN
indeterminate loops
INDEXED BY BINARY_INTEGER
initcap function
inner cursor
INOUT
INOUT mode
INOUT variables
J
Java
L
LAST method
LIMIT method
M
multivariate statistics
 
N
nested block
nested table
Newtonian Calculus
NEXT method
NO_DATA_FOUND exception
NOCOPY clause
NULL
NULL statement
O
OR REPLACE clause
Oracle Corporation
Oracleg
Oraclei
OTHERS clause
OTHERS option
OUT mode
outer cursor
overloading procedures
P
passing variables
Perl
PL/SQL block
PL/SQL error messages
PL/SQL errors
PL/SQL module
PL/SQL packages
PL/SQL tables
PRIOR method
procedure
Procedures
PUBS database
R
RAISE_APPLICATION_ERROR
Raptor
REF CURSOR
RETURN clause
RETURN statement
RETURNING clause
REVERSE
ROLLBACK statement
ROWTYPE_MISMATCH
S
scope
SELECT INTO
set serveroutput on
SET SERVEROUTPUT ON
SQL
SQL%FOUND
SQL%ISOPEN
SQL%NOTFOUND
SQL%ROWCOUNT
SQL*Plus
SQLCODE
SQLERRM
T
TextPad
THEN clause
tnsnames.ora
TOAD
TOO_MANY_ROWS
trigger
TRIM method
U
UPDATE WHERE CURRENT OF clause
user_objects
user_source
V
Variables passed to procedures
VARRAY
Visual Basic
W
WHEN clause
WHERE clause
WHILE loop
 

Reviews:

 

Errata:

 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks