Advanced Oracle PL/SQL Developer's Guide

Author: Saurabh K. Gupta

Publisher: Packt Publishing Ltd

ISBN: 1785282522

Category: Computers

Page: 428

View: 8115

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination Build robust and secure applications in Oracle PL/SQL using the best practices Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn Learn and understand the key SQL and PL/SQL features of Oracle Database 12c Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling Implement Virtual Private Databases to prevent unauthorized data access Trace, analyze, profile, and debug PL/SQL code while developing database applications Integrate the new application development features of Oracle Database 12c with the current concepts Discover techniques to analyze and maintain PL/SQL code Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database. Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.
Release

Oracle PL/SQL Programmierung

Author: Steven Feuerstein,Bill Pribyl

Publisher: O'Reilly Verlag DE

ISBN: 9783897211841

Category: ORACLE 9i

Page: 1058

View: 6004

Release

Oracle Database 11g - DBA-Handbuch

Eine skalierbare und sichere Oracle Enterprise Datenbank administrieren

Author: Bob Bryla,Kevin Loney

Publisher: N.A

ISBN: 9783446413795

Category:

Page: 717

View: 5762

Release

Oracle PL/SQL Programming

Author: N.A

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565923355

Category: Computers

Page: 987

View: 9226

The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language. Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery. NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk. Oracle PL/SQL Programming is divided into seven parts: Foreword Preface Part I: Programming in PL/SQL 1. Introduction to PL/SQL 2. PL/SQL Language Fundamentals 3. Effective Coding Style Part II: PL/SQL Language Elements 4. Variables and Program Data 5. Conditional and Sequential Control 6. Database Interaction and Cursors 7. Loops 8. Exception Handlers 9. Records in PL/SQL 10.PL/SQL Tables Part III: Built-in Functions and Packages 11. Character Functions 12. Date Functions 13. Numeric, LOB, and Miscellaneous Functions 14. Conversion Functions Part IV: Modular Code 15. Procedures and Functions 16. Packages 17. Calling Stored PL/SQL Functions from SQL Part V: PL/SQL Oracle8 Features 18. Object Types 19. Nested Tables and VARRAYs 20. Object Views 21. External Procedures Part VI: Making PL/SQL Programs Work 22. Code Design Tips 23. Managing Code in the Database 24. Debugging PL/SQL 25. Tracing PL/SQL 26. Tuning PL/SQL Part VII: Appendixes A. What's on the Companion Disk? B. Calling Stored Procedures from PL/SQL Version 1.1 C. Built-in Packages
Release

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 6175

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.
Release

Oracle Advanced PL/SQL Developer Professional Guide

Author: Saurabh Gupta

Publisher: Packt Publishing Ltd

ISBN: 1849687226

Category: Computers

Page: 440

View: 7171

This book is packed with real world examples that cover all the advanced features of PL/SQL. In turn, each major certification topic is covered in a separate chapter that makes understanding concepts easier. At the end of each chapter, you will find plenty of practice questions to strengthen and test your learning.If you are a PL/SQL developer looking for deeper insight and a move from mid-level programmer to professional database developer, then this is the best guide for you. This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.
Release

Oracle PL/SQL kurz & gut

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: O'Reilly Germany

ISBN: 386899680X

Category: Computers

Page: 184

View: 7332

Die vierte Auflage dieser beliebten Taschenreferenz liefert Ihnen die wichtigsten Informationen, die Sie für die Arbeit mit Oracle PL/SQL benötigen, und deckt jetzt auch die neuen Features von Oracle Database 11g ab. Das Buch bietet eine Zusammenfassung der Sprachelemente und Funktionen von PL/SQL und behandelt unter anderem folgende Themen: - Blockstruktur, Bezeichner, Variablen, Datentypen und Deklarationen - Anweisungen zur Ablaufsteuerung, zur Cursor-Verwaltung und zum Exception-Handling - Aufruf von PL/SQL-Funktionen in SQL - Datensätze, Prozeduren, Funktionen, Trigger und Packages - Kompilationsoptionen, objektorientierte Features und Collections
Release

The Oracle PL-SQL CD Bookshelf

CD-ROM.

Author: O'Reilly & Associates Inc,O'Reilly and Associates, Inc. Staff

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565928497

Category:

Page: 285

View: 7053

Readers get the complete text of the following books on CD-ROM: "Oracle PL/SQL Programming, Advanced PL/SQL Programming, Oracle Web Applications, Oracle Built-in Packages, Oracle Developer's Workbook, Oracle PL/SQL Pocket Reference, Oracle Built-ins Pocket Reference", and "Oracle PL/SQL Programming: A Guide to Oracle 8i Features".
Release

Oracle PL/SQL Language

Pocket Reference

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596004729

Category: Electronic books

Page: 121

View: 514

Provides a reference to basic language elements including block structure and declarations, statements for program control, and the calling of functions.
Release

Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF

Author: Peter Koletzke,Duncan Mills

Publisher: McGraw Hill Professional

ISBN: 0071710477

Category: Computers

Page: 562

View: 2213

The most efficient way to learn J2EE programming techniques Two Oracle experts demonstrate techniques for working within J2EE and JDeveloper for the thousands of developers currently using Oracle Forms and the PL/SQL language. Oracle is shifting their focus towards Java technologies, so you will need to know how to use the Java-based J2EE and JDeveloper. The book includes explanations of the Application Development Framework (ADF). Throughout, high-level and low-level Forms concepts are related to Java concepts so that you can become comfortable with the new terminology. Covers the new components required when developing and deploying a J2EE application Special mentions in the text describe how JDeveloper techniques translate to PL/SQL or Oracle Forms Covers JDeveloper 10.1.3 and ADF Faces All code and examples will be available online
Release

CGI Programming with Perl

Author: Scott Guelich,Shishir Gundavaram,Gunther Birznieks

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565924192

Category: Computers

Page: 451

View: 1122

Explains how to use CGI to provide information servers on the Web and includes coverage of Perl Version 5, CGI.pm, CGI_lite, FastCGI, and mod_perl.
Release

Designing with Javascript

Creating Dynamic Web Pages

Author: Nick Heinle,Bill Peña

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565923607

Category: Computers

Page: 216

View: 2382

A guide for beginners offers an overview of JavaScript basics and explains how to create Web pages, identify browsers, and integrate sound, graphics, and animation into Web applications
Release

Oracle SQL

Das umfassende Handbuch

Author: Jürgen Sieben

Publisher: N.A

ISBN: 9783836237178

Category: Computers

Page: 1011

View: 2676

Release

UML 2 und Patterns angewendet - objektorientierte Softwareentwicklung

Author: Craig Larman

Publisher: mitp Verlags GmbH & Co. KG

ISBN: 9783826614538

Category:

Page: 716

View: 5159

Dieses Lehrbuch des international bekannten Autors und Software-Entwicklers Craig Larman ist ein Standardwerk zur objektorientierten Analyse und Design unter Verwendung von UML 2.0 und Patterns. Das Buch zeichnet sich insbesondere durch die Fahigkeit des Autors aus, komplexe Sachverhalte anschaulich und praxisnah darzustellen. Es vermittelt grundlegende OOA/D-Fertigkeiten und bietet umfassende Erlauterungen zur iterativen Entwicklung und zum Unified Process (UP). Anschliessend werden zwei Fallstudien vorgestellt, anhand derer die einzelnen Analyse- und Designprozesse des UP in Form einer Inception-, Elaboration- und Construction-Phase durchgespielt werden
Release

SQL für Dummies

Author: Allen G. Taylor

Publisher: John Wiley & Sons

ISBN: 3527810897

Category: Computers

Page: 440

View: 8260

Daten und Datenbanken sind quasi überall. Mit der Standardabfragesprache SQL können Daten in relationalen Datenbanken einfach, strukturiert und zielsicher abgefragt werden. Erfahren Sie in diesem Buch, welches kein Vorwissen voraussetzt, wie man Datenbanken erstellt, wie man Daten ordnet und abfragt und wie man SQL-Anweisungen in Programme und Websites einbindet. Nutzen Sie dieses Buch auch als Nachschlagewerk. Ganz wichtig: Sie lernen auch, wie Sie Ihre Datenbanken und Daten schützen und wie Sie typische Fehler vermeiden.
Release

Sams Teach Yourself PL/SQL in 21 Days

Author: Jonathan Gennick,Tom Luers

Publisher: Sams Publishing

ISBN: 9780672317989

Category: Computers

Page: 692

View: 6148

Presented in an easy-to-learn, tutorial style, this "teach yourself" guide has been revised to include new features of Oracle 8i. New topics include: extended dynamic SQL within PL/SQL; use of invoker's rights; interfacing; and more. Web site includes author examples and source code.
Release

Oracle SQL High-performance Tuning

Author: Guy Harrison,Raymond Aron

Publisher: Prentice Hall

ISBN: 9780130123817

Category: Computers

Page: 630

View: 3925

Canada was young during the First World War, and with as many as 20,000 underage soldiers leaving their homes to join the war effort, the country's army was, too. Jim, at 17, was one of them, and he penned countless letters home. But these weren't the writings of an ordinary boy. They were the letters of a lad who left a small farming community for the city on July 15, 1915, a boy who volunteered to serve with the 79th Queen's Own Cameron Highlanders. Jim's letters home gloss over the horrors of war, focusing instead on issues of the home front: of harvesting, training the horses, and the price of hogs. Rarely do these letters, especially those to his mother and father, mention the mud and rats, the lice and stench of the trenches, or the night duty of cutting barbed wire in no man's land. For 95 years his letters remained in a shoebox decorated by his mother. Jim was just 18 when he was wounded and died during the Battle of the Somme. Hold the Oxo! tells the story that lies between the lines of his letters, filling in the historical context and helping us to understand what it was like to be Jim.
Release

Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL

Author: Matthew Morris

Publisher: Createspace Independent Pub

ISBN: 9781482570748

Category: Computers

Page: 174

View: 4542

This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Professional in the PL/SQL developer track. The book provides information covering all of the exam topics for the Oracle certification exam: "1Z0-146: Oracle Database 11g: Advanced PL/SQL." The books in the Oracle Certificaton Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times. This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.
Release