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
11743 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 the data pump import utility?

1040

is there a tool to trace queries, like profiler for sql server?

1147

How many categories of data types in oracle?

1035

Is oracle a language?

953

What happens to the current transaction if the session is ended?

1100

What is clustered table in Oracle?

1204

What is oracle latest version?

1102

What do you understand by a database object? Can you list a few of them?

1020

What is translate in oracle?

1105

What are the advantages of oracle 12c?

1182

What are the differences between lov and list item?

1075

How to Truncate Table in Oracle

1165

How different is ms access and oracle?

1048

In which language oracle has been developed?

1081

What are the various oracle database objects?

1148