Creating a Table by Using a Subquery Syntax •Create a table and insert rows by combining the CREATE TABLE statement and the AS subquery option. […]
Category: Oracle Interview Questions
Oracle 9i Tutorial : Table and Data Dictionary
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 […]
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 […]