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

Explain the use of parfile option in exp command.

985

How does Oracle guarantee data integrity of data changes?

2330

In which language oracle has been developed?

1013

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2071

how to join query for one source type is oracle another source type is sql server ?

2375

Explain do view contain data?

938

How to test null values?

1039

What is object data modeling?

901

How to export data with a field delimiter?

969

Explain user account with reference to oracle.

926

How do I know if oracle is installed on windows?

873

What is not equal to in oracle?

947

Explain the use of constraints option in exp command.

988

What is a Garbage Collection? and what is full recursive Garbage collection?

2839

How to change user password in oracle?

973