Advanced Oracle PL/SQL Developer's Guide

Author: Saurabh K. Gupta

Publisher: Packt Publishing Ltd

ISBN: 1785282522

Category: Computers

Page: 428

View: 493

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: 1387

Release

Oracle PL/SQL Programming

Author: N.A

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565923355

Category: Computers

Page: 987

View: 1313

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

Oracle PL/SQL Programming

Guide to Oracle8i Features

Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565926752

Category: Computers

Page: 248

View: 4887

Introducing the latest PL/SQL features of Oracle8i, this detailed manual discusses autonomous transactions, invoker rights, native dynamic SQL, system-level database triggers, access control, and other valuable topics and provides one hundred files of reusable source code and examples on diskette. Original. (Intermediate)
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: 3543

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 kurz & gut

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: O'Reilly Media

ISBN: 3868990194

Category: Computers

Page: 184

View: 894

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

Oracle Advanced PL/SQL Developer Professional Guide

Author: Saurabh Gupta

Publisher: Packt Publishing Ltd

ISBN: 1849687226

Category: Computers

Page: 440

View: 474

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 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: 7482

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: 5431

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: 6328

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 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: 9056

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

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 8357

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

SQL von Kopf bis Fuss

Author: Lynn Beighley

Publisher: O'Reilly Germany

ISBN: 3955619443

Category: Computers

Page: 608

View: 5804

Ihre Daten erdrücken Sie? Ihre Tabellen verheddern sich regelmäßig? Wir haben ein Mittel, wie Sie Ihre Datenbanken in den Griff bekommen: SQL von Kopf bis Fuß nimmt Sie mit auf eine Reise durch die SQL-Welt, es geleitet Sie von einfachen INSERT-Anweisungen und SELECT-Abfragen zu knallharten Datenbank-Manipulationen mit Indizes, Joins und Transaktionen. Erwarten Sie dennoch Spaß, gehen Sie davon aus, etwas zu lernen, und machen Sie sich darauf gefasst, dass Sie Ihre Daten wie ein Profi abfragen, normalisieren und verknüpfen werden, noch bevor Sie dieses Buch ausgelesen haben. SQL von Kopf bis Fuß ist in einem visuell abwechslungsreichen Format gestaltet, das sich an den neuesten Forschungsergebnissen aus Kognitionswissenschaft und Lerntheorie orientiert und Ihnen das Lernen so einfach wie möglich machen soll. Das Buch bietet Ihnen ein unterhaltsames Lernerlebnis und spielt Ihnen SQL direkt ins Hirn - und zwar so, dass es sitzt.
Release

Oracle PL/SQL

Das umfassende Handbuch

Author: Jürgen Sieben

Publisher: N.A

ISBN: 9783836214520

Category:

Page: 881

View: 7196

Release

Network troubleshooting tools

Author: Joseph D. Sloan

Publisher: O'Reilly Media

ISBN: 9780596001865

Category: Computers

Page: 346

View: 1093

Over the years, thousands of tools have been developed for debugging TCP/IP networks. They range from very specialized tools that do one particular task, to generalized suites that do just about everything except replace bad Ethernet cables. Even better, many of them are absolutely free. There's only one problem: who has time to track them all down, sort through them for the best ones for a particular purpose, or figure out how to use them? "Network Troubleshooting Tools" does the work for you--by describing the best of the freely available tools for debugging and troubleshooting. You can start with a lesser-known version of "ping" that diagnoses connectivity problems, or take on a much more comprehensive program like MRTG for graphing traffic through network interfaces. There's "tkined" for mapping and automatically monitoring networks, and Ethereal for capturing packets and debugging low-level problems. This book isn't just about the tools available for troubleshooting common network problems. It also outlines a systematic approach to network troubleshooting: how to document your network so you know how it behaves under normal conditions, and how to think about problems when they arise, so you can solve them more effectively. The topics covered in this book include: Understanding your network Connectivity testing Evaluating the path between two network nodes Tools for capturing packets Tools for network discovery and mapping Tools for working with SNMP Performance monitoring Testing application layer protocols Software sources If you're involved with network operations, this book will save you time, money, and needless experimentation.
Release

PNG

The Definitive Guide

Author: Greg Roelofs

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565925427

Category: Computers

Page: 321

View: 7512

Helps graphic designers get the most out of this nextgeneration graphics file format and programmers who want to add full PNGsupport to their own applications by emphasizing the implementation of PNG with the libng C library and discussing such improvements as gamma correction and standard color spaces. Original. (Intermediate)
Release

XML in a Nutshell

A Desktop Quick Reference

Author: Elliotte Rusty Harold,W. Scott Means

Publisher: Oreilly & Associates Incorporated

ISBN: 9780596000585

Category: Computers

Page: 480

View: 6033

A reference to the fundamental rules of XML details tags, grammar, placement, element names, attributes, and syntax.
Release

Web Navigation

Designing the User Experience

Author: Jennifer Fleming

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565923515

Category: Computers

Page: 253

View: 5615

Web Navigation: Designing the User Experienceoffers the first in depth look at designing web site navigation. Author Jennifer Fleming offers design strategies to help you uncover solutions that work for your site and audience. Acclaimed Web design author Lynda Weinman says in the foreword to this book: "Kudos to Fleming for her excellent research, approachable tone and generosity of information. If you're looking for help in giving your site's visitors a more positive experience than they get today, this book is an excellent place to start. It provides ideas and direction, not preachy rules that apply to someone else's site." The first half of the book suggests goals and processes for developing workable navigation schemes. Topics include: Basic concepts in navigation Traits of navigation that work User testing and user-centered design Site architecture Interface and interaction design The second half ofWeb Navigationfocuses on designing by purpose, with chapters on entertainment, shopping, identity, learning, information, and community sites. Through case studies and interviews, each section explains common navigation problems and presents real world solutions and advice. Designer interviews feature conversations with industry leaders such as Clement Mok, Jakob Nielsen, and Nathan Shedroff. Case studies include sites such as FAO Schwarz, National Geographic, and IBM. The accompanying CD-ROM is more than just a handy drink coaster. It serves as a launchpad to the sites mentioned in the text, and also offers software demos and a "netography" of related Web resources. "The Web needs more books like this if it to evolve to the next level," Weinman writes. "I believe this book can help you make your site a better place, regardless of whether your purpose is community-building, commerce, education, entertainment, information, or hobby. It's written is such an enjoyable, conversational tone that you may have trouble putting it down; I certainly did. I wholeheartedly recommend it for all Web publishers."
Release

Oracle SQL High-performance Tuning

Author: Guy Harrison,Raymond Aron

Publisher: Prentice Hall

ISBN: 9780130123817

Category: Computers

Page: 630

View: 5366

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