Download Documenting Oracle Databases: Complete Oracle Database by Mike Ault PDF

By Mike Ault

Show description

Read Online or Download Documenting Oracle Databases: Complete Oracle Database Schema Auditing (Oracle In-Focus Series) PDF

Best applied mathematicsematics books

Introduction to Algorithms, Second Edition Solution Manual

The 1st variation received the award for top 1990 specialist and Scholarly publication in desktop technology and knowledge Processing through the organization of yankee Publishers. There are books on algorithms which are rigorous yet incomplete and others that hide plenty of fabric yet lack rigor. creation to Algorithms combines rigor and comprehensiveness.

Information and Communications Technology for Competitive Intelligence (Advanced Topics in Global Information Management)

Textual content bargains types to constitution the gathering and processing of strategically appropriate info inside businesses. deals how you can arrange the intelligence procedure with right the right way to construct an enough infrastructure that considers the technological, structural, and human points. DLC: enterprise intelligence.

Pharmaceutical Applications of Raman Spectroscopy (Wiley Series on Technologies for the Pharmaceutical Industry)

Raman spectroscopy has complex in recent times with expanding use either in and academia. this is often due mostly to regular advancements in instrumentation, reducing rate, and the supply of chemometrics to help within the research of knowledge. Pharmaceutical functions of Raman spectroscopy have built equally and this booklet will concentrate on these functions.

Extra info for Documenting Oracle Databases: Complete Oracle Database Schema Auditing (Oracle In-Focus Series)

Example text

What is left are the remainder of the “soft” database objects, these being packages, package bodies, procedures, functions, triggers and views. The next script handles packages, package bodies, procedures and functions. sql scripts located in Appendix A. PAGE 44 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. ROBO BOOKS MONOGRAPH DOCUMENTING YOUR DATABASE Documenting Sequences Since sequences aren’t a part of standard SQL many people tend to overlook them, until they break. Sequences can break if you exceed their maximum (for an ascending sequence) or minimum (for a descending sequence) values or place to much stress on a single sequence.

Ofctypview (fk_ofctypofctypcd) PCTFREE 60 INITRANS 2 MAXTRANS 255 TABLESPACE DSPT_INDX STORAGE ( INITIAL 4096 NEXT 2048 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50) / . . eventcloitem (fk_cloitemcloitemn,fk_cloitemfk_clofk, fk_cloitemfk_cloc0,fk_cloitemfk_clocl) PCTFREE 60 INITRANS 2 MAXTRANS 255 TABLESPACE DSPT_INDX STORAGE ( INITIAL 4096 NEXT 2048 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50) / So far the “hard” database objects and a few “soft” ones have been documented. What is left are the remainder of the “soft” database objects, these being packages, package bodies, procedures, functions, triggers and views.

Set termout off create table t_temp (lineno NUMBER, tb_owner VARCHAR2(30), tb_name VARCHAR2(30), text VARCHAR2(255)) / DECLARE CURSOR tab_cursor IS PAGE 28 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. nullable%TYPE; BOOLEAN; NUMBER := 0; VARCHAR2(80); procedure write_out(p_line INTEGER, p_name VARCHAR2, p_string VARCHAR2) is begin insert into t_temp (lineno, tb_name, text) values (p_line,p_name,p_string); end; BEGIN OPEN tab_cursor; LOOP FETCH tab_cursor INTO lv_table_name, lv_pct_free, PAGE 29 COPYRIGHT © 2003 RAMPANT TECHPRESS.

Download PDF sample

Download Documenting Oracle Databases: Complete Oracle Database by Mike Ault PDF
Rated 4.30 of 5 – based on 12 votes