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

Can we use update in sql function?

0 Answers  


What information is needed to connect sql*plus an oracle server?

0 Answers  


What are the different types of joins in sql?

0 Answers  


How to pronounce postgresql?

0 Answers  


What are %type and %rowtype for?

0 Answers  






What is rownum in sql?

0 Answers  


Does sql backup shrink transaction log?

0 Answers  


What is sequence in sql?

0 Answers  


How can we find duplicate records in a table?

0 Answers  


What is dynamic sql in pl sql?

0 Answers  


discuss about myisam key cache. : Sql dba

0 Answers  


what is the difference between blob and text? : Sql dba

0 Answers  


Categories