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
11895 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

What is an oracle function?

1239

What is BBED in Oracle?

1196

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2143

What is background process in Oracle?

1136

How to Truncate Table in Oracle

1209

Differentiate between function and procedure in oracle.

1149

How to create a new table by selecting rows from another table?

1145

what are the advantages of running a database in archive log mode?

2252

Explain the use of constraints option in exp command.

1079

How to use subqueries with the exists operator in oracle?

1065

Why does oracle 9i treat an empty string as null?

1124

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

1996

Is insert autocommit in oracle?

1128

How to use fetch statement in a loop?

1066

What is Java Pool in Oracle?

1234