Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
- Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
- Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
- Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
- Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
- Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers
Published by: O'Reilly Media | Publication date: 01/23/2014Kindle book details: Kindle Edition, 1392 pages
How do you punish an immortal?By making him human.After angering his father Zeus, the god Apollo is cast down from Olympus. Weak and disorientated, he lands in New York City as a regular teenage boy. Now, without his godly powers, the four-thousand-year-old deity must learn to survive in the modern world until he can somehow find a way to regain Zeus's favour.But Apollo has many enemies - gods, monsters and mortals who would love to see the former Olympian permanently destroyed. Apollo needs help, and he can think of only one place to go . . . an enclave of modern demigods known as Camp Half-Blood.
Published by: Puffin | Publication date: 05/03/2016Kindle book details: Kindle Edition, 375 pages
Only the determination of one man can bring victoryThe Trojan War has been raging for ten years. Greece’s greatest warriors have fallen. But then a series of oracles appear with utterances from the gods, commands that must be fulfilled if Troy is to be defeated.Agamemnon, leader of the Greeks, knows that only one man has the courage and intelligence to complete the tasks set by the Olympians: Odysseus, King of Ithaca.From an island haunted by a vengeful madman to a forsaken tomb and its deadly guardian, from the palace of a hostile king to the sacred heart of Troy itself, Odysseus and his friend Eperitus must follow the trail toward the greatest deception of all time…The Adventures of Odysseus1. King of Ithaca2. The Gates of Troy3. The Armour of Achilles4. The Oracles of Troy5. The Voyages of Odysseus6. Book 6 coming summer 2017Praise for Glyn Iliffe‘It has suspense, treachery, and bone-crunching action… It will leave fans of the genre eagerly awaiting the rest of the series’ Times Literary SupplementThis is a must read for those who enjoy good old epic battles, chilling death scenes and the extravagance of ancient Greece’ Lifestyle Magazine‘The reader does not need to be classicist to enjoy this epic and stirring tale. It makes a great novel’ Historical Novels Review‘I found it utterly fascinating, the historic detail was excellent. This was an easy and enjoyable read, and I am looking forward to the next instalments. As a personal read I can absolutely recommend it’ Book Talk Bournemouth‘An exciting story with plenty of action, and the requisite supernatural elements … if you are a fan of writers like Bernard Cornwell, Simon Scarrow and Conn Iggulden you will enjoy this.’ Rachel Hyde, Myshelf.com
Published by: Canelo | Publication date: 02/06/2017Kindle book details: Kindle Edition, 400 pages
Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes.Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old.Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.The price of this essential book will be paid back in hours saved the first time its methods are used.
Published by: O'Reilly Media | Publication date: 09/16/2003Kindle book details: Kindle Edition, 418 pages
Every child deserves a second chance, even a hopelessly psychopathic boy with a notorious history who has spent the bulk of his youth incarcerated in a forensic psychiatric hospital. There, after a decade of treatment, the manipulative patient eventually exhausts the sympathy and goodwill of his caregivers, who quickly learn to fear him. Terrified for their own safety, these hapless professionals eventually resolve to dispose of him to save themselves, regardless of consequences. Sealing the boy’s records and changing his name, his doctors consequently recruit a naïve young couple to adopt him. According to the law, they inform the would-be parents regarding the juvenile’s psychoses, but they cannot detail the many heinous crimes for which he had originally been committed.At the end of a long, hot summer in Delphi, Texas, adoptive parents welcome into their home a Bible-toting teenager they know as Micah, unaware of his murderous past and utterly beguiled by his rote knowledge of the Bible. Unwittingly supporting maniacal designs for their sleepy village, the well-meaning couple proudly introduce their new son to the congregation of their modest church, and they are all duly impressed by Micah’s theatrical delivery of the gospel. Within months, among mesmerized disciples and the West Texas scrub, the newly delivered Oracle of Delphi will rise, self-serving, evil and obsessed with carnal ambitions.
Published by: Capital Ideations, LLC | Publication date: 10/31/2011Kindle book details: Kindle Edition, 204 pages
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.
Published by: O'Reilly Media | Publication date: 06/22/2004Kindle book details: Kindle Edition, 496 pages
The ghosts of Kendril’s past have finally caught up with him.As he races to find the witch Bronwyn and discover what she knows of the Fourth Despair, he finds himself returning to the last place he expected to go…home. The frontier town of Redemption, a place that has more memories than he wants to acknowledge, and more potential enemies than even he can handle.Meanwhile Joseph and Maklavir find that bringing their friend Kara back from her living death will be more costly than they could have ever imagined. Risking everything they have in an attempt to save her, the two friends must battle not only the city gendarmes, but also their own feelings for Kara.And as for Kendril, he will soon find that some ghosts have a nasty way of staying unburied….A thrilling, action-packed fantasy adventure tale, Oracle is Book Five in the Chronicles of Zanthora, and continues the unfolding story of Kendril and the Fourth War of Despair.Cover designed by Robert Worl.Books in the Chronicles of Zanthora:Book One: GhostwalkerBook Two: Throne of LlewyllanBook Three: SoulbinderBook Four: DemonbaneBook Five: Oracle Book Six: Redemption
Publication date: 12/14/2013Kindle book details: Kindle Edition, 297 pages
When Tom Ryan stops his car late at night on a dark road for a man dressed as a Roman centurion, his first thought is that he's picked up one of those amateur re-enactors but the man, Marcus Appius Silvanus appears to speak only Latin. He insists the year is AD60 and that the British Queen is Boudicca - and that he and his men of the Fourteenth Gemina are in hot pursuit of her.Tom and his sister Mary shelter the Roman, but inadvertently attract the attention of an unscrupulous journalist. He's not the only one interested in the Ryans: an IRA terrorist who was once Mary's lover in Northern Ireland tracks her down to tell her the plane crash which killed her parents twenty years ago was caused by the British security services.Deep in the English countryside, those same servants of the state are busy exploiting the theories of a young prodigy to build 'Oracle', a probe that can view the past - and, they hope, the future, so that threats to national security can be stifled before they occur.
Published by: Gateway | Publication date: 09/29/2011Kindle book details: Kindle Edition, 283 pages
~Part two of the epic fantasy duology~After a brief respite, the Gardyn rebels have returned to fight the tyranny of King Hrafn and Prince David.Samantha, Jillis and Tobias will have to find their place in the new vision of Enchena; but first, they have to risk everything to make it real.New allies will rise, as the past plays a huge part in the future; and an Oracle must be brought, to guide them all.
Publication date: 01/01/2017Kindle book details: Kindle Edition, 222 pages
Burgton will preserve mankind, even if he has to break every single law to do it. General Burgton's self-imposed mission is to safeguard the Alliance from future alien invasion and murderous Merkiaari attacks. As the black missions Burgton authorizes begin to fail, he spends trillions of dollars on a forbidden solution: artificial intelligence. When the project collapses, Burgton compounds his crime. If he can't build an A.I., he'll just have to steal one! Operation Oracle is the third book in the Merkiaari Wars, a military science fiction space opera about the consequences of space exploration in the far future. Alien invasion is only the first of many consequences that pose the question: What is human?Buy the book to continue this must-read series today! Reading Order:1. Hard Duty2. What Price Honour3. Operation Oracle4. Operation Breakout5. Incursion
Published by: Impulse Books UK | Publication date: 03/01/2013Kindle book details: Kindle Edition, 392 pages