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.
Read Online or Download Oracle PL/SQL Programming: Guide to Oracle8i Features PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.
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 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.
- Oracle Automatic Storage Management, 1st Edition
- Practical Oracle Security: Your Unauthorized Guide to Relational Database Security
- Expert Oracle JDBC Programming
- Oracle Real Application Clusters Guard. Administration and Reference Guide
- Oracle Siebel CRM 8 installation and management : install, configure, and manage a robust customer relationship management system using Siebel CRM
- Mastering Oracle GoldenGate
Extra resources for Oracle PL/SQL Programming: Guide to Oracle8i Features
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.