Home » SQL & PL/SQL » SQL & PL/SQL » Count Characters in Table Column
Count Characters in Table Column [message #964] Fri, 15 March 2002 17:44 Go to next message
KK
Messages: 24
Registered: March 2002
Junior Member
Hi!

How do I count the number of characters in a column?

Table1.Dept
------------
A
B

Table1.Desc
-------------
Dept1
Department2

I want the query to return the number of characters in the Table1.Desc column.

Results:
Count
-------
5 - for DeptA
11 - for DeptB

Any help would be appreciated!! Thanks!!

Report message to a moderator

Re: Count Characters in Table Column [message #965 is a reply to message #964] Fri, 15 March 2002 18:16 Go to previous message
sokeh
Messages: 77
Registered: August 2000
Member
is this what you are looking for?

select 'character length'||' '||length(ename)||' '||'for emp name'||' '||ename
from emp

Report message to a moderator

Previous Topic: Trigger Problem
Next Topic: difference!!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 01:43:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.