By Steven Feuerstein
This concise and interesting consultant offers you a leap commence at the new PL/SQL beneficial properties of Oracle8i (Oracle's progressive "Internet database"). It covers self sustaining transactions, invoker rights, local dynamic SQL, bulk binds and collects, system-level database triggers, new integrated programs, fine-grained entry keep an eye on, calling Java tools from inside PL/SQL, and masses extra. encompasses a diskette containing a hundred records of reusable resource code and examples.
Read or Download Oracle PL/SQL Programming: Guide to Oracle8i Features PDF
Best oracle books
Oracle Web Applications: PL/SQL Developer's Intro: Developer's Introduction
It is a impressive ebook, transparent and well-written. it really is uncomplicated adequate for these with out a lot event, but in addition presents adequate aspect when you don't want coddling. .. certainly, well worth the $.
Oracle Database 11g Underground Advice for Database Administrators
This day DBAs are anticipated to install and deal with huge databases with caliber carrier and little to no downtime. The DBA’s major concentration is on expanding productiveness and casting off idle redundancy during the firm. notwithstanding, there is not any magic set of most sensible practices or tough and quick principles that DBAs have to stick to, and this may make lifestyles tough.
RMAN Recipes for Oracle Database 11g
It’s occasionally acknowledged that the genuine task of an Oracle database administrator could be summed up in a single, crucial ability: so one can get well your database.
There’s a lot knowledge in that assertion. Of all the pieces you're chargeable for as a database administrator, not anything is extra very important than the knowledge itself. love it or now not, the fearsome accountability of shielding your agencies most important information falls squarely upon your shoulders:
- Lose that facts and your organization may perhaps fail.
- Lose that info and also you can be out of a job.
Scared? you have to be. yet theres support. you're not on my own. Oracle specialists Darl Kuhn, Sam Alapati, and Arup Nanda have come jointly during this booklet to teach you the ability of restoration supervisor, or RMAN, that is Oracles backup and restoration software of selection. RMAN Recipes for Oracle Database 11g is helping you're taking good thing about all that RMAN has to provide via offering easy-to-understand ideas to business-critical backup and restoration operations. this useful guide
- Demystifies the stairs required to guard your online business data
- presents ready-made and step by step strategies to easy and complicated backup, repair, and restoration operations
- Is task-oriented, making it effortless so you might uncover the answer to urgent backup and restoration problems
- Respects some time via supplying example-based suggestions, now not never-ending analyzing material
When the pressure’s on, you dont have time for lengthy discussions of conception. This publication will get correct to the purpose with quickly and easy-to-read, step by step suggestions which may assist you backup and get better your info with confidence.
What you’ll learn
Oracle Database specialists Darl Kuhn, Sam Alapati, and Arup Nanda convey you ways to
- Reliably again up and recuperate your database utilizing Oracles restoration Manager.
- make the most of New Oracle Database 11g positive aspects akin to the information restoration Advisor.
- enable Oracle Database deal with your backup documents through the Flash restoration Area.
- Automate backup and restoration initiatives by means of writing scripts.
- Troubleshoot RMAN difficulties and optimize RMAN performance.
- Interface with a Media administration Layer to control your backup tape library.
- get over the lack of a keep watch over dossier, lack of a web redo log, and different (hopefully! ) strange situations.
Who is that this booklet for?
Oracle database directors liable for database backup and restoration operations.
Achieving Extreme Performance with Oracle Exadata
Maximize Oracle Exadata services Leverage the entire strong positive factors on hand within the Oracle Exadata Database computer utilizing the confirmed strategies within this Oracle Press advisor. Written via Oracle specialists, attaining severe functionality with Oracle Exadata exhibits you ways to take complete good thing about this entire, optimized package deal of software program, servers, and garage.
- Expert Oracle9i Database Administration
- Ocp: Oracle8i DBA SQL & PL/SQL Study Guide (OCP study guide)
- Expert Oracle9i Database Administration
- Oracle 9i Datenbankentwicklung in 21 Tagen
- Oracle Application Server 10g: J2EE Deployment and Administration
- Oracle Automatic Storage Management for 10g and 11g
Additional info for Oracle PL/SQL Programming: Guide to Oracle8i Features
Example text
40 41 A few weeks later, I start getting calls from my coworkers. " "Steven, I asked it to drop my table, and runddl said that there is no such table. " "Steven. . " Well, you get the idea. I begin to have serious doubts about sharing my code with other people. Sheesh, if they can't use something as simple as runddl without screwing things up . . but I decide to withhold judgment and do some research. I log into the COMMON schema and find that, sure enough, all of the objects people were trying to create or drop or alter were sitting here in COMMON.
NDS supports all SQL datatypes available in Oracle8i. So, for example, define variables and bind arguments can be collections, large objects (LOBs), instances of an object type, and REFs. On the other hand, NDS does not support datatypes that are specific to PL/SQL, such as Booleans, index-by tables, and user-defined record types. The INTO clause may, however, contain a PL/SQL record. Let's take a look at a few examples: 1. Create an index: EXECUTE IMMEDIATE 'CREATE INDEX emp_u_1 ON employee (last_name)'; It can't get much easier than that, can it?
Pkg */ CREATE OR REPLACE PACKAGE retry IS PROCEDURE incr_attempts (item IN VARCHAR2); PROCEDURE set_limit (item IN VARCHAR2, limit IN INTEGER); FUNCTION limit (item IN VARCHAR2) RETURN INTEGER; FUNCTION limit_reached (item IN VARCHAR2) RETURN BOOLEAN; PROCEDURE clear_attempts (item IN VARCHAR2); FUNCTION attempts (item IN VARCHAR2) RETURN INTEGER; FUNCTION attempts_left (item IN VARCHAR2) RETURN INTEGER; FUNCTION attempted_at (item IN VARCHAR2) RETURN DATE; PROCEDURE show_retries (item IN VARCHAR2 := '%'); END retry; / The programs are self-explanatory; the implementations are also very straightforward.