Oracle database 11g new features for dbas and developers by Alapati, Kim
By Alapati, Kim
Read or Download Oracle database 11g new features for dbas and developers experts voice in oracle PDF
Best oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication permit real-time info entry and information sharing throughout your dispensed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains how one can manage and administer a unified company facts sharing infrastructure.
Oracle software convey four Recipes offers an example-based method of studying software exhibit - the ground-breaking, fast software improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes an outstanding instance or to kick begin their pondering and get pointed within the correct course.
- Oracle Database 11g DBA Handbook (Oracle Press)
- Database Performance Tuning and Optimization: Using Oracle
- Oracle Database 11g A Beginner's Guide, 1st Edition
- Pro Oracle Application Express (Expert's Voice in Oracle)
- Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard
Additional resources for Oracle database 11g new features for dbas and developers experts voice in oracle
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.