User Tables: –Are a collection of tables created and maintained by the user –Contain user information Data Dictionary: –Is a collection of tables created and […]
Category: Oracle 9i Tutorial
Oracle 9i Tutorial : CREATE TABLE Syntax
Oracle 9i Tutorial : CREATE TABLE Syntax •You must have: –CREATE TABLE privilege –A storage area •You specify: –Table name –Column name, column data type, […]
Oracle 9i Tutorial : Naming Rule
Naming Rules : Table names and column names: Must begin with a letter Must be 1–30 characters long Must contain only A–Z, a–z, 0–9, _, […]
Oracle 9i Tutorial – Database Objects
Database Objects An Oracle database can contain multiple data structures. Each structure should be outlined in the database design so that it can be created […]