Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter table - from varchar to blob

644257Jun 10 2008 — edited Jun 10 2008
Hi all,

i want to edit a column and want to change the properties from varchar to blob. I have tried it with:
ALTER TABLE dmImage
MODIFY (label BLOB)
but the script runs into an error.

OK, for the most of you a simple question but i´m a real Oracle-SQL Noob :|

Best regards
nic.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2008
Added on Jun 10 2008
6 comments
6,026 views