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"
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 define an explicit cursor in oracle?
How to display row numbers with the records?
Explain an exception?
How many types of database triggers exist?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Write a trigger example in oracle?
Why do we need oracle client?
What is a package in oracle?
How to open a cursor variable?
What is not equal to in oracle?
Can a Tablespace hold objects from different Schemes ?
What happens to indexes if you drop a table?