select length('string') from dual; or select length(column

write a qurey for finding the length of the sting.

Question Posted / ajmal khan

Answer Posted / ajmal khan

select length('string') from dual;
or
select length(column_name) from table_name;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the two types of periodical indexes?

988

how can we know the count/number of elements of an array? : Sql dba

1109

What is the difference between the implicit and explicit cursors?

1111

What is sql profiling in oracle?

1133

What is the difference between having and a where in sql?

1152

What is latest version of sql?

1102

How to fetch alternate records from a table?

1306

What plvcmt and plvrb does in pl/sql?

1366

What is execution plan in sql?

1092

What is implicit cursor in pl sql?

1148

how to see the create table statement of an existing table? : Sql dba

1060

Why is %isopen always false for an implicit cursor?

1153

Which join condition can be specified using on clause?

1015

Explain the structure of pl/sql in brief.

1142

Differentiate between pl/sql and sql?

1217