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
- 11507 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 |
what are different types of deletes?
What are the commands youd issue to show the explain plan for select
What is a table index in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
Which is faster join or subquery in oracle?
How to create a new tablespace in oracle?
How to upsert (update or insert into a table)?
What is a cursor in oracle?
difference between truncate and delete ,drop?
How to use "startup" command to start default instance?
What is an UTL_FILE.What are different procedures and functions associated with it?
Oracle General 
