write a qurey for finding the length of the sting.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what are the benefits of pl/sql packages?

731


What is the difference between null value, zero, and blank space?

759


How do I run a pl sql procedure in sql developer?

691


What does desc stand for?

784


What is #table in sql?

704






How exception is different from error?

761


What language is oracle sql developer?

711


What is primary and foreign key?

802


What is the least restrictive isolation level? : Transact sql

761


How do I view a procedure in sql?

723


What does closing a cursor do?

982


Where not exists in sql?

668


What is bind variable in pl sql?

719


What is sql character function?

709


How many types of triggers are there in pl sql?

776