How to change column varchar to clob in oracle

by

(as the previous answer) and here’s the code:

ALTER TABLE atable
 ADD (tmpdetails  CLOB);

UPDATE atable SET tmpdetails=details;
COMMIT;

ALTER TABLE atable DROP COLUMN details;

ALTER TABLE atable
RENAME COLUMN tmpdetails TO details;

Related Contents:

  1. How to check for null/empty/whitespace values with a single test?
  2. CASE .. WHEN expression in Oracle SQL
  3. Is it possible to output a SELECT statement from a PL/SQL block?
  4. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  5. Best way to reset an Oracle sequence to the next value in an existing column?
  6. PL/SQL block problem: No data found error
  7. How to insert date values into table
  8. If statement in select (ORACLE)
  9. Oracle date “Between” Query
  10. How to use BOOLEAN type in SELECT statement
  11. Oracle – Why does the leading zero of a number disappear when converting it TO_CHAR
  12. How to kill a running SELECT statement
  13. How to count the number of occurrences of a character in an Oracle varchar value?
  14. BETWEEN clause versus =
  15. Get list of all tables in Oracle?
  16. Is there a combination of “LIKE” and “IN” in SQL?
  17. What is the difference between Views and Materialized Views in Oracle?
  18. When do I need to use a semicolon vs a slash in Oracle SQL?
  19. How can I get column names from a table in Oracle?
  20. Oracle find a constraint
  21. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  22. Comparing Dates in Oracle SQL
  23. How to declare variable and use it in the same Oracle SQL script?
  24. Is there any difference between “!=” and “” in Oracle Sql?
  25. How to use Oracle ORDER BY and ROWNUM correctly?
  26. Do I need to create indexes on foreign keys on Oracle?
  27. MySQL ‘create schema’ and ‘create database’ – Is there any difference
  28. How to Alter Constraint
  29. Oracle DateTime in Where Clause?
  30. How can I get the number of records affected by a stored procedure?
  31. How can I introduce multiple conditions in LIKE operator?
  32. How to Select a substring in Oracle SQL up to a specific character?
  33. How to replace specific values in a oracle database column?
  34. How to run .sql file in Oracle SQL developer tool to import database?
  35. Oracle: What does `(+)` do in a WHERE clause?
  36. Counting number of joined rows in left join
  37. Delete with “Join” in Oracle sql Query
  38. Select without a FROM clause in Oracle
  39. What exactly do quotation marks around the table name do?
  40. Is inner join the same as equi-join?
  41. How do I query for something that starts with certain characters?
  42. Oracle SQL Developer – tables cannot be seen
  43. SQL – How to select a row having a column with max value [duplicate]
  44. INSERT SELECT statement in Oracle 11G
  45. How to create an Oracle sequence starting with max value from a table?
  46. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  47. Searching for Text within Oracle Stored Procedures
  48. Call a stored procedure with another in Oracle
  49. What is the equivalent of varchar(max) in Oracle?
  50. How can I insert multiple rows into oracle with a sequence value?

Leave a Comment