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 cursor and why it is required?

0 Answers  


What is 19 null in sql?

0 Answers  


How do I filter in sql profiler?

0 Answers  


Does truncate release storage space?

0 Answers  


What schema means?

0 Answers  






Do prepared statements prevent sql injection?

0 Answers  


What is java sql driver?

0 Answers  


cursor types? explain with example programs?

1 Answers   HP,


What is sql resultset?

0 Answers  


What is nvl function?

4 Answers   Cap Gemini,


How does one load ebcdic data? : aql loader

0 Answers  


What is the difference between unique and primary key constraints?

0 Answers  


Categories