Common Database structure
1- Table: Common structure in database is a Table .table consist of columns and rows in which data is stored .the intersection of a column and a row is called a field.
2- View: a view is a logical symbol of subsets of data from one or more database table.
3- Sequence: generate unique numbers. You can it to generate Primary key
4- Synonym: alternate names for tables or for other database object
5- Index: by using the index object you improve the performance of queries.
Note: that you can create and modify table structures while database in used.
This post first appeared on Oracle Sql Tutorials,oracle 10g Tutorial, please read the originial post: here
