| Team Fly | |
SQL> select * from date_test; TS --------- 14-DEC-06
The clob data type allows storage of very large objects in excess of four gigabytes in size. Since this is a true character data type, it is very similar to the varchar2 data type except for its much larger maximum size.
The blob data type permits storage of large unstructured binary objects. Sound and video are examples of blob data.
It's now time to have a look at the most common object in the Oracle Database 10g—the table. After that, we will have a look at a few types of programming units written using SQL, which a person can store in the Oracle Database 10g.
The best way to think of a table in a relational database such as Oracle Database 10g is to see it as a spreadsheet with rows and columns. With this in mind, note the following:
Rows are often referred to as records.
Each column has a name unique to the table within which it resides.
The intersection of each row and column, referred to as a cell in a spreadsheet, is called a field in Oracle Database 10g.
Picture the following SQL statement that creates a table (the line numbers are not part of the code):
1- create table part_master ( 2- id number(8) not null, 3- manufacturer_code number(4) not null, 4- inception date not null, 5- description varchar2(60) not null, 6- unit_price number(6,2) not null, 7- in_stock varchar2(1));
Let's pick apart the code and highlight the main points in Table 1-2.
Table 1-2 mentions the concept of a relational database. Let's inspect a few other tables and see how they are related to one another.
| Team Fly | |