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

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2135

How to delete a column in an existing table?

1070

What is the usage of merge statement?

1140

Point the difference between translate and replace?

1081

What is raw datatype?

1132

How to synchronize 2 schema's objects?

2164

How to define a cusotmer as a supplier in ORACLE R12

2224

What is oracle datasource?

980

Differentiate between translate and replace?

1102

Give the advantages and disadvantages of clusters.

1048

how do u setup a replication site?

1974

Will you be able to store pictures in the database?

1112

What is primefaces used for?

1045

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2351

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2099