1:-select length('apple') from dual; o/p:-5 2:-select rownum

write a query to count number of alphabets in given string
for example "APPLE"

write a query to generate sequence from 50 to 100

write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

Question Posted / ajit nayak

7 Answers
11466 Views
British Telecom BT, I also Faced
E-Mail Answers

Answer Posted / ajit nayak

1:-select length('apple')
from dual;
o/p:-5

2:-select rownum
from dual
connect by level between 50 and 100;

3:-select replace ('ABCD,EFGH,IJKL,PQRS',',')
from dual;

Is This Answer Correct ?

4 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is format trigger?

2011

Is oracle a language?

895

When do you get a .pll extension in oracle?

1076

Explain oracle left join with an example?

952

What is Data Dictionary Cache in Oracle?

1116

master table and child table performances and comparisons in Oracle ?

2065

What is set operator oracle?

920

What are the four Oracle system processes that must always be up and running for the database to be useable?

953

Can multiple columns be used in group by in oracle?

925

Explain integrity constraint?

1104

Does oracle database need java?

939

What is the recommended interval at which to run statspack snapshots, and why?

2860

How do I manually create a database in oracle?

953

How view is different from a table?

966

How to check the oracle tns settings?

988