select length('abc') from dual; out put: 3

write a qurey for finding the length of the sting.

Question Posted / srinivas

Answer Posted / srinivas

select length('abc') from dual;

out put:
3

(or)
select length(<columname>) from <table>;

Is This Answer Correct ?

35 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is record type in pl sql?

553

What does seeding a database mean?

531

How to add a column ‘salary’ to a table employee_details?

595

How many primary keys can a table have?

534

give the syntax of grant and revoke commands? : Sql dba

619

What are the two different parts of the pl/sql packages?

570

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

571

What are some predefined exceptions in pl/sql?

553

How does a covering index work?

535

What is sql lookup?

516

What is sqlca in powerbuilder?

574

Is pl sql a programming language?

551

Explain autonomous transaction.

640

How to make a copy values from one column to another in sql?

582

What is the need of merge statement?

557