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 is sqlservr exe?

1029

What is a stored procedure in sql with example?

1204

Can you have more than one key in a database?

995

What does varchar include?

995

what is isam? : Sql dba

1067

How do you get column names only for a table (sql server)?

1217

What does (*) mean in sql?

1002

what is the difference between where clause and having clause? : Sql dba

1047

Write a sql query to get the third highest salary of an employee from employee_table?

1120

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

1067

How to pronounce postgresql?

1099

What is rank () in sql?

999

Do foreign keys improve performance?

1068

What is type and rowtype in pl sql?

1058

how to escape special characters in sql statements? : Sql dba

1083