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

How to delete a user account in oracle?

1021

Explain temporal data types in oracle

1133

What is Trigger in Oracle?

1238

What happens if recursive calls get out of control?

1136

What is an oracle function?

1239

How to define a variable of a specific record type?

1112

What is a tns service name?

1054

How to test null values?

1154

Explain an integrity constrains?

1190

What is rowid and rownum in oracle?

1063

How many types of segments in Oracle?

1114

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

2559

Explain what are clusters?

1155

State some uses of redo log files?

1064

What is oracle rownum?

1014