Home » SQL & PL/SQL » SQL & PL/SQL » clob data (oracle 10g)
clob data [message #390691] Mon, 09 March 2009 05:17 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
i am having a table with column x as varchar data type which is filled with some data and now i want to change it into clob data type.
is it possible to do and can anyone show me with an example for better understanding/
Re: clob data [message #390692 is a reply to message #390691] Mon, 09 March 2009 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either:
- Add a new column, fill it, drop the old one
- Use dbsm_redefinition

Regards
Michel
Re: clob data [message #390696 is a reply to message #390692] Mon, 09 March 2009 05:29 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
can you show me with an example.
Re: clob data [message #390702 is a reply to message #390696] Mon, 09 March 2009 05:51 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Have a look at the Documentation
Re: clob data [message #390707 is a reply to message #390702] Mon, 09 March 2009 06:16 Go to previous message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
i got it.no need for your advise like " go through the documentation".Anyway thanks alot
Previous Topic: Instr Query
Next Topic: How to calcuate SGA
Goto Forum:
  


Current Time: Tue Dec 06 15:58:32 CST 2016

Total time taken to generate the page: 0.06068 seconds