Results 1 to 3 of 3

Thread: blob

  1. #1
    Join Date
    Mar 2009
    Posts
    6

    Unanswered: blob

    dear folks,
    i want to know hoe to change the long raw column data type to blob .the long raw column table contains datas.how i do?

    thanks in advance

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Code:
    ALTER TABLE the_table MODIFY long_raw_column BLOB;
    For details see the manual
    http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#CJAHHIBI

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    shammat's response is precise. If your database is large or complex dbConstructor can generate MODIFY commands script with extreme ease especially if you have many tables that you would like to alter from one data type to another.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •