Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    12

    Unanswered: how can i convert CLOB to XML datatype

    hi,
    we have table, for one column, we declared CLOB(800000). we want to change the CLOB data type to XML datatype. How?
    whether we can get any performance improve, if we change???

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by vasu_479 View Post
    we want to change the CLOB data type to XML datatype. How?
    You cannot change the data type of a column. You'll need to add the new column, move data, then drop the old column.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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