write a qurey for finding the length of the sting.
Answers were Sorted based on User's Feedback
Answer / srinivas
select length('abc') from dual;
out put:
3
(or)
select length(<columname>) from <table>;
| Is This Answer Correct ? | 35 Yes | 3 No |
Answer / ajmal khan
select length('string') from dual;
or
select length(column_name) from table_name;
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between syntax error and runtime error?
What is trigger types of trigger?
Difference between IN and EXISTS
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What are tables in sql?
explain advantages of innodb over myisam. : Sql dba
What is the usage of nvl function?
How to combine two stored procedures in sql?
Which data dictionary views have the information on the triggers that are available in the database?
What does plv msg allows you to do?
what is column? : Sql dba
what is the cursor and use of cursor in pl/sql ?
Oracle (3259)
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)