| BLOB / CLOB [message #50681] |
Mon, 01 April 2002 05:51  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
