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
- 11729 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 do I know if oracle client is installed on windows?
What is concurrency in oracle?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
definition of cluster and non-clustered index?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the difference between truncate & delete command?
How to define a variable of a specific record type?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What types of joins are used in writing subqueries?
What are the factors causing the reparsing of SQL statements in SGA?
what are the diffeenes between oracle 9i,oracle 10g
How to create a new table in your schema?
Oracle General 
