write a qurey for finding the length of the sting.

Answers were Sorted based on User's Feedback



write a qurey for finding the length of the sting...

Answer / srinivas

select length('abc') from dual;

out put:
3

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

Is This Answer Correct ?    35 Yes 3 No

write a qurey for finding the length of the sting...

Answer / nagendra

select length('sting') from dual;

Is This Answer Correct ?    9 Yes 2 No

write a qurey for finding the length of the sting...

Answer / rinson

Select length('&string') from dual;

Is This Answer Correct ?    8 Yes 5 No

write a qurey for finding the length of the sting...

Answer / ajmal khan

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

Is This Answer Correct ?    1 Yes 0 No

write a qurey for finding the length of the sting...

Answer / abhiraj

select LEN('welcome')

Is This Answer Correct ?    0 Yes 0 No

write a qurey for finding the length of the sting...

Answer / manjula

SELECT LEN ('string')

output :
6

Is This Answer Correct ?    4 Yes 16 No

Post New Answer

More SQL PLSQL Interview Questions

What is sql basics?

0 Answers  


What is a memo field?

0 Answers  


what are the type of locks ? : Sql dba

0 Answers  


Explain how can you save or place your msg in a table?

0 Answers  


What is type and rowtype in pl sql?

0 Answers  






Does truncate require commit?

0 Answers  


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  


where are cookies actually stored on the hard disk? : Sql dba

0 Answers  


Is it possible to update views?

0 Answers  


What is dense_rank in sql?

0 Answers  


What is orm in sql?

0 Answers  


What is the maximum number of triggers, you can apply on a single table?

0 Answers  


Categories