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 pl/sql package consists of?

0 Answers  


What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,


What is sql*plus?

0 Answers  


what is normalization? : Sql dba

0 Answers  


What normalization means?

0 Answers  






What is the difference between unique and primary key constraints?

0 Answers  


What is sql table?

0 Answers  


Does pl sql work in mysql?

0 Answers  


Can we use update in sql function?

0 Answers  


what are the different functions in sorting an array? : Sql dba

0 Answers  


How exception is different from error?

0 Answers  


What is Data Concarency and Consistency?

1 Answers  


Categories