what is the difference between char_length and length? : Sql dba



what is the difference between char_length and length? : Sql dba..

Answer / Nalinaksh Punj Gautam

"In SQL, CHAR_LENGTH(column) returns the total number of characters in a string, regardless of leading spaces. Length(column) returns the actual number of non-space characters in a string."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is #table in sql?

1 Answers  


What is set transaction?

1 Answers  


What are inner outer left and right joins in sql?

1 Answers  


create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,


Which are the different character-manipulation functions in sql?

1 Answers  


what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,


In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,


what is a trigger? : Sql dba

1 Answers  


What are different clauses used in sql?

1 Answers  


How to create your own reports in sql developer?

1 Answers  


Explain the select statement in sql?

1 Answers  


Which sorts rows in sql?

1 Answers  


Categories