Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 7 Answers
- 11905 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ramya
select replace ('ABCD,EFGH,IJKL,PQRS',',','') from Customers;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / obulesu
select length(regexp_replace('s,a,d,abc',','))
countofcharecter from dual
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ajit nayak
1:-select length('apple')
from dual;
o/p:-5
2:-select rownum
from dual
connect by level between 50 and 100;
3:-select replace ('ABCD,EFGH,IJKL,PQRS',',')
from dual;
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / chiranjeevi
select level+49 from dual connect by level<=100
| Is This Answer Correct ? | 2 Yes | 3 No |
How to create a new tablespace in oracle?
What are operators in oracle?
What is a proxy class?
What is a Data Dictionary ?
Explain the use of indexes option in imp command.
What are the components of physical database structure in the Oracle database?
What are Schema Objects ?
How to get a create statement for an existing table?
How to create a stored function in oracle?
what is a Nested Loop join?
What is an Oracle sequence?
17. Display the order number and average item cost for each order.
Oracle General 
