select length('abc') from dual; out put: 3

write a qurey for finding the length of the sting.

Question Posted / srinivas

Answer Posted / srinivas

select length('abc') from dual;

out put:
3

(or)
select length(<columname>) from <table>;

Is This Answer Correct ?

35 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do you write a subquery?

960

What is delimiter in pl sql?

986

What is synchronized subquery?

1089

How do I create a sql script?

1048

What is sql profiling in oracle?

992

What is a variable in sql?

948

Explain mutating table error.

1127

What are types of exception?

873

How can you create an empty table from an existing table?

1009

What does bitemporal mean?

1009

What is the difference between clustered and non-clustered index in sql?

953

What are the benefits of pl sql?

1049

how to return query output in html format? : Sql dba

1018

How can check sql version from command line?

1006

What is sqlexception in java?

938