select level+49 from dual connect by level<=51

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

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

Answer Posted / ajit

select level+49 from dual connect by level<=51

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about the analyze command in oracle?

1010

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

933

What is an oracle data file?

1053

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1904

What is the difference between PFILE and SPFILE in Oracle?

1004

What is oracle in java?

923

How can I create database in oracle?

969

How to create a temporary table in oracle?

1213

How to assign a tablespace to a users in oracle?

1006

How to create a new user account in oracle?

973

Explain what are the advantages of views?

1021

How to connect ms access to oracle servers?

954

How to create additional tablespaces for an new database?

984

what is the use of system.effective.date variable in oracle?

1068

types of indexes and the rationale behind choosing a particular index for a situation.

2461