Oracle SQL & PL/SQL Annotated Archives PDF Download

Author: Kevin Loney
Publisher:
ISBN: 9780078825354
Category : PL/SQL (Computer program language)
Languages : en
Pages : 585

View

Book Description

Author: Kevin Loney
Publisher: McGraw-Hill/Osborne Media
ISBN:
Category : Oracle (Computer file)
Languages : en
Pages : 618

View

Book Description
SQL and PL/SQL are the languages used to program Oracle databases and manipulate their data. This title provides hundreds of ready-to-run SQL and PL/SQL scripts to programmers on the CD-ROM. Also featured are thousands of lines of annotated code providing in-depth understanding how to use and customize each program.

Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003814
Category : Computers
Languages : en
Pages : 1028

View

Book Description
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

Author: Joel Murach
Publisher: Mike Murach & Associates
ISBN: 9781890774806
Category : Computers
Languages : en
Pages : 0

View

Book Description
If you're developing applications that access Oracle databases, you can save time and trouble by having the database do more work for you. That's where this book comes in. It teaches you how to create effective SQL queries to retrieve and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use Oracle's procedural language, PL/SQL, to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer.

Author:
Publisher:
ISBN:
Category : Libraries
Languages : en
Pages : 996

View

Book Description
Includes, beginning Sept. 15, 1954 (and on the 15th of each month, Sept.-May) a special section: School library journal, ISSN 0000-0035, (called Junior libraries, 1954-May 1961). Also issued separately.

Author: Kevin Loney
Publisher: McGraw-Hill Companies
ISBN:
Category : Oracle (Computer file)
Languages : en
Pages : 630

View

Book Description
This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and Programmer's Notes and Annotations that provide expert explanations on the scripts and how they can be customized.

Author: John Adolph Palinski
Publisher: Addison-Wesley Professional
ISBN: 9780201752946
Category : Computers
Languages : en
Pages : 532

View

Book Description
CD-ROM contains: Practice database -- Sample scripts reference in text.

Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 007180174X
Category : Computers
Languages : en
Pages : 1473

View

Book Description
Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions. Set up Oracle Database 12c or upgrade from an earlier version Design Oracle databases and plan for application implementation Construct SQL and SQL*Plus statements and execute powerful queries Secure data with roles, privileges, virtualization, and encryption Move data with SQL*Loader and Oracle Data Pump Restore databases using flashback and the Oracle Database Automatic Undo Management feature Build and deploy PL/SQL triggers, procedures, and packages Work with Oracle pluggable and container databases Develop database applications using Java, JDBC, and XML Optimize performance with Oracle Real Application Clusters

Author: Christopher Beck
Publisher: Apress
ISBN: 1430207027
Category : Computers
Languages : en
Pages : 637

View

Book Description
If you have mastered the fundamentals of the PL/SQL language and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you.

Author: PRANAB KUMAR DAS GUPTA
Publisher: PHI Learning Pvt. Ltd.
ISBN: 8120348427
Category : Computers
Languages : en
Pages : 568

View

Book Description
Database Management System (DBMS) and Oracle are essentially a part of the curriculum for undergraduate and postgraduate courses in Computer Science, Computer Applications, Computer Science and Engineering, Information Technology and Management. The book is organized into three parts to introduce the theoretical and programming concepts of DBMS. Part I (Basic Concepts and Oracle SQL) deals with DBMS basic, software analysis and design, data flow diagram, ER model, relational algebra, normal forms, SQL queries, functions, subqueries, different types of joins, DCL, DDL, DML, object constraints and security in Oracle. Part II (Application Using Oracle PL/SQL) explains PL/SQL basics, functions, procedures, packages, exception handling, triggers, implicit, explicit and advanced cursors using suitable examples. This part also covers advanced concepts related to PL/SQL, such as collection, records, objects, dynamic SQL and performance tuning. Part III (Advanced Concepts and Technologies) elaborates on advanced database concepts such as query processing, file organization, distributed architecture, backup, recovery, data warehousing, online analytical processing and data mining concepts and their techniques. All the chapters include a large number of examples. To further reinforce the concepts, numerous objective type questions and workouts are provided at the end of each chapter. Key Features • Explains each topic in a step-by-step detail.• Includes about 300 examples to illustrate the concepts. • Offers about 400 objective type questions to quiz students on key points.• Provides about 100 challenging workouts that invite deeper analysis and interpretation of the subject matter. New to the Second Edition • The book reorganized into three parts for better understanding of DBMS concepts.• All the existing chapters thoroughly revised and eight new chapters added.• New chapters discuss Oracle PL/SQL advanced programming concepts, data warehousing, OLTP, OLAP and data mining concepts.• Additional examples, questions and workouts in each chapter. TEACHING AID MATERIAL Teaching Aid Material for all the chapters is provided on the website of PHI Learning, which can be used by the faculties/teachers for delivering lectures. Visit www.phindia.com/gupta to explore the contents.