1:-select length('apple')from dual; 2:-select level+50 from

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 / phani kumar

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

Answer Posted / phani kumar

1:-select length('apple')from dual;

2:-select level+50 from dual connect by level<=51;

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

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to write date and time literals in oracle?

1002

Explain the types of exception?

1147

How to create a stored function in oracle?

1111

Can we use bind variables in oracle stored procedure?

957

How to bring a tablespace online?

1081

definition of cluster and non-clustered index?

3035

Explain what are clusters?

1113

What are advantages of dateset in datastage?

2264

What is oracle in java?

977

State some uses of redo log files?

1014

What is a table index in oracle?

1131

What is the difference between I and G in Oracle?

1099

What is a system tablespace and when it is created?

975

Explain user account with reference to oracle.

994

What is a tns service name?

1009