Oracle PL/SQL Programming: Guide to Oracle8i Features by Steven Feuerstein

By Steven Feuerstein

This concise and interesting advisor provides you with a bounce commence at the new PL/SQL gains 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 applications, fine-grained entry keep an eye on, calling Java equipment from inside PL/SQL, and lots more and plenty extra. incorporates a diskette containing a hundred documents of reusable resource code and examples.

Show description

Read Online or Download Oracle PL/SQL Programming: Guide to Oracle8i Features PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time info entry and knowledge sharing throughout your dispensed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g information Replication explains how one can arrange and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software show four Recipes offers an example-based method of studying program exhibit - the ground-breaking, speedy program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a superb instance or to kick begin their considering and get pointed within the correct path.

Extra resources for Oracle PL/SQL Programming: Guide to Oracle8i Features

Sample text

So I have my table. Now, how should I write to my log? Here's what you should not do: EXCEPTION 30 31 WHEN OTHERS THEN v_code := SQLCODE; v_msg := SQLERRM; INSERT INTO log81tab VALUES ( v_code, v_msg, SYSDATE, USER, SYSDATE, USER, NULL, NULL); END; In other words, never expose your underlying logging mechanism by explicitly inserting into it in your exception sections and other locations. Instead, you should build a layer of code around the table (this is known as encapsulation). Why do this? Two reasons: • If you ever change your table's structure, all those uses of the log table will not be disrupted.

In other words, this call to runddl: SQL> exec runddl ('create table newone (rightnow DATE)'); would create the newone table in the COMMON schema. newone (rightnow DATE)'); might solve the problem, but would fail with the following error: ORA-01031: insufficient privileges unless I grant CREATE ANY TABLE to the COMMON schema. Yikes . . my attempt to share a useful piece of code got very complicated very fast! It sure would be nice to let people run the runddl procedure under their own authority and not that of COMMON, without having to install multiple copies of the code.

Connected. Dummy1 owned by scott As you can see, DEMO called SCOTT's dummy2 procedure, which was set up as an invoker rights procedure. dummy2 did not call DEMO's dummy1 procedure. Instead it called its own version. sql (you'll find it on the companion disk) ; there you will see that table access is redirected to the DEMO schema. So just remember this: you can use invoker rights to change the resolution of external data element references (tables and views) but not that of program elements. Team-Fly Top Team-Fly Oracle PL/SQL Programming Guide to Oracle 8i Features By Steven Feuerstein Table of Contents Chapter 3.

Download PDF sample

Rated 4.73 of 5 – based on 46 votes