Home » SQL & PL/SQL » SQL & PL/SQL » how to use clob data type?
how to use clob data type? [message #215028] Fri, 19 January 2007 00:53 Go to next message
karismapanda
Messages: 58
Registered: January 2007
Member
I want to create a column of clob data type.

Can anyone please tell me how to create,retrive and do dmls on it.

where does it store the data.in database or external file?

does it hold only the pointer to the data?

Thanks
Karisma
Re: how to use clob data type? [message #215039 is a reply to message #215028] Fri, 19 January 2007 01:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why are you so sure you want to use a clob-column if you don't know anything about it?
These are all quite basic questions. Look it up in the manuals. ( this is a good starting point) All your questions are answered there.
Re: how to use clob data type? [message #215040 is a reply to message #215039] Fri, 19 January 2007 01:26 Go to previous messageGo to next message
karismapanda
Messages: 58
Registered: January 2007
Member
actually i have to store large text data in that column and varchar is insufficient for that.that's why i am trying to use clob.
thanks
Re: how to use clob data type? [message #215045 is a reply to message #215039] Fri, 19 January 2007 01:40 Go to previous messageGo to next message
karismapanda
Messages: 58
Registered: January 2007
Member
can u please give me some scripts on its usage
thanks
Re: how to use clob data type? [message #215050 is a reply to message #215045] Fri, 19 January 2007 01:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You're saying you went through all the documentation in under 14 minutes?
Re: how to use clob data type? [message #215057 is a reply to message #215050] Fri, 19 January 2007 03:08 Go to previous messageGo to next message
karismapanda
Messages: 58
Registered: January 2007
Member
yah i have gone through it
Re: how to use clob data type? [message #215067 is a reply to message #215057] Fri, 19 January 2007 03:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Wow, you really are a fast reader!
Maybe you should pace down, then you would see the example scripts in the docs..
i am so sorry [message #215071 is a reply to message #215067] Fri, 19 January 2007 03:34 Go to previous message
karismapanda
Messages: 58
Registered: January 2007
Member
i am very sorry,i had missed that portion.
thanks a lot
Previous Topic: Currval and disconnect
Next Topic: occurance of string
Goto Forum:
  


Current Time: Mon Dec 05 04:49:30 CST 2016

Total time taken to generate the page: 0.09174 seconds