BLOB / CLOB [message #50681] |
Mon, 01 April 2002 05:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sanjay chatterji
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
When i am creating a table with blob or clob,
While describing it it show undifined in
the desc command. Also it does not allow my to enter any thing into it
Please help
Regards & thanks
Sanjay
|
|
|
Re: BLOB / CLOB [message #50691 is a reply to message #50681] |
Mon, 01 April 2002 21:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Ardian B. Santoso
Messages: 11 Registered: April 2002
|
Junior Member |
|
|
Maybe it can help ;
SQL> create table test2
2 (id clob,
3 address blob);
Table created.
SQL> desc test2
Name Null? Type
-------- -------- --------
ID CLOB
ADDRESS BLOB
SQL> desc test2
Name Null? Type
-------- -------- ----------------------------
ID CLOB
ADDRESS BLOB
SQL> insert into test2(id) values('one');
1 row created.
SQL>
for BLOB you must use new syntax of SQL 8i
Regards,
Ardian
|
|
|