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 |
What is #table in sql?
What is set transaction?
What are inner outer left and right joins in sql?
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?
Which are the different character-manipulation functions in sql?
what is the difference between trigger and storedprocedures
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.
what is a trigger? : Sql dba
What are different clauses used in sql?
How to create your own reports in sql developer?
Explain the select statement in sql?
Which sorts rows in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)