DataObjects in Oracle :
1. Table - Logical structure to hold your your data in the physical HD.
2. Views - Its generally used to create a table from one or more table. It also help to hide original table name.
3. Synonym
Table : table name should contain only - A-Z, a-z, 0-9, '_', $ and #
1. Difference between char and variable character(varchar)?
A : char is fixed, varchar is not fixed is size.
2. Diff between varchar and varchar2?
A: varchar contains 2000 character and varchar2 contains 4000 characters.
BLOB(binary large objects -used to store images and large files) LONG - 2GB
Monday, October 11, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment