Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsrinivas.
Yak Posting Veteran
56 Posts |
 Posted - 2010-05-08 : 10:12:22
|
| Dear sql team,how to find the length of text data type column?my column contains some sqltext(ie sql view text)i want to find that length of text for each row.normal length functions are not working.please tell me.-thankssrinivas. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-08 : 10:35:26
|
| use DATALENGTH function.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gsrinivas.
Yak Posting Veteran
56 Posts |
Posted - 2010-05-11 : 09:39:43
|
| thanks visakh16,and I will try.does it work in oracle ?in oracle, the data type is CLOB(Character Long Object)while in SQL Server is TEXT data type.plz specify a function for oracle alsoThanks,Srinivas. |
|
|
|
1dmf
Starting Member
5 Posts |
Posted - 2010-05-11 : 11:01:49
|
| Does this help?http://www.google.co.uk/#hl=en&source=hp&q=oracle+DATALENGTH+function&meta=&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=71f60c6bcc41f992 |
|
|
|
gsrinivas.
Yak Posting Veteran
56 Posts |
Posted - 2010-05-14 : 04:36:10
|
| I am unable to find the function for length of CLOB in oracle.can any one help plz..-thankssrini |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-14 : 05:34:13
|
| Post your question at www.orafaq.comMadhivananFailing to plan is Planning to fail |
|
|
|
gsrinivas.
Yak Posting Veteran
56 Posts |
Posted - 2010-05-17 : 11:22:18
|
| ok,thanks madhivanan.-thankssrini |
|
|
|
|
|
|
how to get the length of text datatype column?