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

Where do we use pl sql?

1002

What operators deal with null?

1109

What is sqlca in db2?

974

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

What is the difference between between and in condition operators?

1006

What is the best free sql database?

1057

How are functions and procedures called in PL/SQL?

1235

How do I edit a trigger in sql developer?

999

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1007

Does pdo prevent sql injection?

935

What are the basic techniques of indexing?

1063

What is procedure explain with program?

1023

Is subquery faster than join?

1017

Explain what is a column in a table?

1107

What do you understand by exception handling in pl/sql?

1035