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
Covers Oracle DBMS versions 10, 11, 12, and XE Sams Teach Yourself Oracle PL/SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 26 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Oracle’s PL/SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more. 10 minutes is all you need to learn how to...
- Use PL/SQL in the Oracle environments and tools
- Construct complex PL/SQL statements using multiple clauses and operators
- Retrieve, sort, and format database contents
- Pinpoint the data you need using a variety of filtering techniques
- Use string, date-time, and math functions to manipulate your data
- Join two or more related tables
- Insert, update, and delete data
- Create and alter database tables
- Work with views, stored procedures, cursors, triggers, and more
Published by: Sams Publishing | Publication date: 09/02/2015Kindle book details: Kindle Edition, 286 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
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.Whether you’re a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of:
- Fundamental language elements, such as block structure, datatypes, and declarations
- Statements for program control, cursor management, and exception handling
- Records, procedures, functions, triggers, and packages
- Execution of PL/SQL functions in SQL
- Compilation options, object-oriented features, collections, and Java integration
Published by: O'Reilly Media | Publication date: 09/09/2015Kindle book details: Kindle Edition, 190 pages
With Angeline back in Cedric’s arms and the Eye of Gaea in Romasanta’s grip, the next step in their journey begins. All eyes are set on Mt. Parnassus where the Oracle is protected by Delphyne, the mother of all dragons and beasts. Assembling a group of willing patrons, Romasanta leads them to Delphi, Greece where they will cross into a realm void of technology. Only brute strength and magic reign in a place where packs of Mimick dogs, Wyverns and Jaculus still run wild. Meanwhile, back home Lillith takes on a mysterious curse cast on Tony who will have to make a life changing choice. The question weighing on all their minds is if two werewolves, the Incubus King, and a demonized sorceress will live to fight their way into Gaea’s Gate to enter the Otherworld?
Published by: Battle Goddess Productions | Publication date: 09/01/2017Kindle book details: Kindle Edition, 331 pages
Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. • Properly index and partition Oracle Database 12c Release 2• Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager• Efficiently manage disk drives, ASM, RAID arrays, and memory• Tune queries with Oracle SQL hints and the Trace utility• Troubleshoot databases using V$ views and X$ tables• Create your first cloud database service and prepare for hybrid cloud• Generate reports using Oracle’s Statspack and Automatic Workload Repository tools• Use sar, vmstat, and iostat to monitor operating system statistics
Published by: McGraw-Hill Education | Publication date: 03/22/2017Kindle book details: Kindle Edition, 1136 pages
Strange noises. Haunting shadows. A handsome man with a mysterious past.Enid Runa doesn’t ask for anything or anyone to slip into her life, but fate deems her destined for an adventuresome life that begins with a shadow and ends with her being carried off into the night. Her captor is the enigmatic and flirtatious Ian Osman, a man with a lot of secrets and more than one interest in her. He tells her that she’s entered the world of the paranormal, and he’s her only safe ride through the fun land of horror that has their blood-red eyes set on her. She doesn’t know whether to slap Osman or hug him, and matters are complicated when she learns his darkest secret.
Published by: Crescent Moon Studios, Inc. | Publication date: 07/29/2017Kindle book details: Kindle Edition, 89 pages
It was the most renowned and respected shrine in the Roman Empire, the object of veneration by Julius Caesar, Cleopatra, Octavian, and a host of other luminaries. It stood for centuries within a sacred precinct the size of a large town at the heart of the greatest Greek city in the world. Yet it disappeared without a trace, creating the greatest archaeological enigma of the ancient world. What became of the tomb of Alexander the Great? Does any part of it still survive? Find out in the latest installment of the New York Times bestselling series by Charles Brokaw, THE ORACLE CODE. When word of the tomb’s secret location and the treasured wisdom of the Oracle of Delphi it may hold materialize in the code of an ancient scroll in Afghanistan, Harvard linguist and archeologist professor Thomas Lourds must quickly find out. That is if the evil forces that wish to obtain the treasure that the tomb holds doesn’t stop him first. Russian President Nevsky and his secret police will stop at nothing to harness the power of what the tomb may hold—power to control the world as Alexander the Great did. When the Taliban catches wind of the discovery they’re also dangerously hot on the trail.Watch the book trailer for THE ORACLE CODE here: http://www.youtube.com/watch?v=1uhe7gA60c8"Short, gripping chapters move the action from Egypt to Russia to Africa to London. Indiana Jones meets The Da Vinci Code. Look out, Dan Brown, Brokaw can play this game a lot better than most of your imitators." –Booklist on THE ATLANTIS CODE"[E]xcellent entertainment, […] A rollicking adventure, with nonstop action and suspense. Readers can only hope that Brokaw is prepared to send Professor Lourds on further quests." –Publishers Weekly on THE ATLANTIS CODEAbout the Author: New York Times bestselling author Charles Brokaw is the author of THE ATLANTIS CODE, THE LUCIFER CODE, and THE TEMPLE MOUNT CODE. Charles Brokaw is a pseudonym for an author, academic, and college educator living in the Midwest. He’s had a rich and varied life, and is fascinated by history, human accomplishment, and archeology.
Published by: Charles Brokaw | Publication date: 03/03/2013Kindle book details: Kindle Edition, 398 pages
Tina's back . . . and she’s got some serious ass to kick!When an IEA intelligence officer makes a surprise visit aboard the Marcus Garvey, Tina and Doc find themselves roped into an escort mission to the dangerous underworld of Neo-Bangkok.Instantly embroiled in a double-cross, they wind up facing off against both rival mercs and a mysterious CIA agent intent on seeing them killed. But when Tina uncovers a global conspiracy that could lead to the extinction of mankind--all hell breaks loose.Now it’s up to Tina to either stop it, or see the world doomed to Armageddon. But to do so, she’ll have to turn against her very own homeland and put the lives of everyone she loves . . . at risk.Fast paced and action-packed, book 5 of the Once Giants series is another thrill ride for old school cyberpunk fans. If you love kick ass heroines, wise cracking mercs and high stakes political threats, then this is the book for you!GRAB YOUR COPY TODAY!
Publication date: 09/25/2017Kindle book details: Kindle Edition, 153 pages
As featured in USA Today in March 2012. BOOK ONE in the War of Gods series.Inspired by Slavic mythology, Damian’s Oracle is the entree into the ongoing battle between good and evil over the fate of humanity. The White God, Damian, and his Guardians protect the world from the Black God and his monsters while rescuing Naturals – humans with extraordinary paranormal gifts – from the Black God, who would kill or convert them.Caught in the middle is cool-headed Sofia, a Natural whose gift will tip the scales in the war. Sofia begins her transformation from human into oracle, the first in thousands of years. Damian rescues her from the Black God in time to complete a ceremony that will bind her to him for eternity. Sofia struggles with her new world and her role as an oracle and Damian’s mate while haunted by a mysterious man from Damian’s past who’s supposed to be dead. Unbeknownst to her, her link to the dead man may be all that saves Damian, his Guardians, and the fate of humanity.While he wants nothing more than for the petite beauty to take her place at his side like the oracles of legend did his White God forefathers, Damian can’t quite rationalize having to win her over instead of command her. Further complicating his life is the sobering realization that there are spies in his organization who are helping the Black God take out his Guardians. Damian must help Sofia reach her potential fast, especially when a threat from his past returns.Includes exclusive excerpt from "Damian's Assassin," Book II in the War of Gods series.Editorial review: Excerpt from review in USA Today, March 30, 2012: "Damian's Oracle, the first novel in a series of four, effectively balances paranormal action with old-fashioned romance. While Sofia's emotional development and evolving supernatural powers seemed rushed at times, the cast of characters is entertaining and vivid, the story is engrossing, and the love shared between Damian and Sofia is authentic and timeless, an organic and precious factor in this supernatural saga. Damian's Oracle is a paranormal romance that is sure to entertain and thrill."
Published by: Kettlecorn Press | Publication date: 01/01/2011Kindle book details: Kindle Edition, 274 pages