Tables:
1)Data is permanently stored in tables in the database.
2)Database tables are generated from them.
Structure:
1)It contains data temporarily during pro...
Four Types of Tables:
1. Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Bo...
You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like this:
SELECT * FROM information_schema.tables
This returns the n...
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands t...
The DATA DICTIONARY is a comprehensive set of tables and views owned by the DBA users SYS and SYSTEM, which activates when ORACLE is initially installed, and is...