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

what are the types of join and explain each? : Sql dba

1037

Can we join two tables without common column?

999

Why is a trigger used?

937

What is difference between joins and union?

1119

What port does sql server use?

1057

What is sql server and ase?

1018

Which certification is best for sql?

981

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2483

What is composite data type in pl sql?

1100

Why do we go for stored procedures?

1053

What is sql select statement?

1028

Why join is faster than subquery?

1106

How many times can we commit in a loop?

1014

what is the difference between truncate and drop statements? : Sql dba

1116

Does group by remove duplicates?

1037