|
SQL
It is a Standard Query language for Relational Database.
SQL statements are the instructions to the Dataabse.
SQL -Features
Querying Data
Inserting , updating and Deleting rows in a table
Creating, Replacing, Altering and Dropping Objects
Controlling access to the Database Objects
Basic Terms
Tables - It is uniquely identified by its name and consists of rows with data values and columns with its name.
Each row containing one record (or tuple)
Each column is called as attribute which describes an attribute of the records.
Data Type - ORACLE
|
Data Type |
| Number |
Number(p) |
| Decimal |
Number(p,s) |
| String |
Char(L) |
| Nstring |
Varchar2(L) |
| Float |
Float(p) |
| Date |
Date |
| Time |
Time |
|
|
