Document Guide

Data base Source and SQLscripts: Students : Using sequence Manas9 :tables.sql C:\BareBone_Oracle\Resources\Osborne_Oracle_PLSQL\CH01 Using as an Object Type Manas 9 tablesb.sql C:\BareBone_Oracle\Resources\Osborne_Oracle_PLSQL\CH01

consider rewriting :

Home : Bare Bone Oracle Our Mission What-We are document_guide1.htm test.php phpinfo.php phpServer Name ref_urls.htm demobld-sql.txt Complete_Reference Code tables_student.txt template1.htm Oracle Security Privilages template1.htm On Line References FYI Data Base: I Database then and now Data Base : Know-What-How preface_1.htm Introducing DBMS preface_2.htm History of Oracle and PostgreSQL preface_3.htm Data Type Aggregate and composite preface_4.htm : About ORDBMS Database Intro1.htm objectives of DBMS Database_Intro2.htm function of DBMS, ER Modeling, Indexing, SQL Views, Security, Integrity, Recovery Database_intro3.htm Transaction, atomicity, consistency, isolation, durability, commit, rollback, Savepoint, MVCC, Vacuum SQL_Standards1.htm : Introducing SQL query, Tuple/ROW, Constraints PK, FK, Table SQL_Standards_2.htm SQL /PGSQL queries compared, pseudo-column, data-type, column name, Intro to built data type: BLOB, CHAR etc. in a Table, column_row1.htm :A Table has rows and columns, a  column (field) has name, a row (record) has an id. native_dbms_sql1.htm DYNAMIC_SQL and DBMS_SQL nds_dbms_sql1.htm how to use EXECUTTE IMMEDIATE  in dynamic sql FYI Database-II Data Type SQL and PSQL storage Data Type 1: Scalar data type PL/SQL Block : PLSQL_Syntaxes_Datype1.htm Data Base : Comparisons contrast_resemblances1.htm mysql_oracle_postgresql1.htm OODB_Intro1.htm OODB_Intro2.htm myClassCOMVtable1.htm Virtual_Function1.htm abstract_class_1.htm Data Base : Role: Privileges Oracle_Privileges1.htm User_privileges_1.htm more coming more coming FYI: Database III PL/SQL and PL/psql   plsql_overview_1.htm : Block Structure, variable and constant, control structure, procedure, function, cursor, trigger, record, object type and packages PLSQL_OverView2.htm : stored procedure, Anonymous block, diff between function and procedure, execute a block , and call a procedure from another block. Use As key word from stand alone procedure plsql_overview3.htm : More comparison between function and procedure. IN OUT definition,  comparing parameterized function and procedure , how to call from SQL*Plus File VS DBMS Hierarchical : Main Frame :DB2 Advantages : disadvantages Network Base Models  623 *1 Relational Database Models Logical View of Data : page 43 /*1 Keys Integrity Rules Relational Database Operator Software Classifications Data Dictionary and System Catalog Relationship SQL Introduction Common Over View for all 3 db Normalization ; 209, 213,215, 217 /*1 Database Design : System Development Life Cycle Centralized vs Decentralized Transaction Management: ch 9  355 Object Oriented DB ch 11 423 Oracle Road Map SQL Road Map : SQL_RoadMap.htm PLSQL_Scope1.htm plsql_overview_1.htm Environment Syntaxes PLSQL Data Overview Function and Procedure Packages Overview Cursor Over view Trigger Over View Type Object Outline:scope_e10897.htm get()4 MYSQL Road Map Installation : Oracle Plan Environment Widows Installation: 10g - manas5 II.2 XE - manas 11g.2 Emp database Enterprise Manager Troubleshooting : Window : Web IIS : PHP PastCGI PHP_manager : to handle php.ini Command Line or Developer tool SQL SQL Developer MySQL PostGreSQL SQL Introduction Entity Relationship Model SQL :http://docs.oracle.com/cd/E11882_01/server.112/e41084.pdf SQL : DDL SQL : DML SQL : DCL

Book Ref : Database system by Peter Rob