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
11561 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 do you mean by cdb and pdb in oracle 12c?

1034

Is postgres faster than oracle?

988

what are actual and formal parameters?

1069

What happens if the update subquery returns multiple rows?

1070

What is merge in oracle?

1012

Can we save images in a database and if yes, how?

1015

Explain how you would restore a database using RMAN to Point in Time?

2116

How do I connect to oracle database?

1055

What is a select query statement in oracle?

923

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4492

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2113

Explain index?

1222

How to write date and time literals in oracle?

968

What is MTTR advisor in Oracle?

1058

What are oracle functions?

1000