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
- 11540 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain do view contain data?
How to assign values to variables?
What is an anonymous block?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is meant by recursive hints in oracle?
How to rebuild an index in oracle?
What are the differences between char and varchar2 in oracle?
When system tablespace is created?
Where do you use decode and case statements?
How do I spool in oracle?
does the query needs a hint to access a materialized view?
what is Single Byte Overhead...?
What's dateware house and what's clustor with practicle example
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are internal user account in oracle?
