1.SELECT 'APPLE' STRING,LENGTH('APPLE') FROM DUAL; 2.S

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 / nishi.swain@gmail.com

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

Answer Posted / nishi.swain@gmail.com

1.SELECT 'APPLE' STRING,LENGTH('APPLE') FROM DUAL;
2.SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=100 MINUS SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=49;
3.SELECT 'ABCD,EFGH,IJKL,PQRS'STRING,
REPLACE('ABCD,EFGH,IJKL,PQRS',',') FROM DUAL;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use bind variables in oracle stored procedure?

952

How to define an oracle sub procedure?

1146

How to select some rows from a table in oracle?

1078

What is the usage of merge statement?

1154

how can we store any pdf file in oracle

2164

Can I create users through internet explorer in oracle 10g?

1084

How to rename a tablespace in oracle?

1087

What happens if variable names collide with table/column names?

1193

How to write a query with an inner join in oracle?

1042

What is Trigger in Oracle?

1176

Give the different types of rollback segments.

1031

can u plz provide me oca sql dumps please i need them

1951

What is translate in oracle?

1100

How to drop an index in oracle?

1076

What is a proxy object?

1067