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
- 11482 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of grant option in exp command.
How to drop an index in oracle?
How to define a cusotmer as a supplier in ORACLE R12
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to view all columns in an existing table?
How can windows applications connect to oracle servers?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Please explain drop constraint oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the benefits of ordbms?
What is a partition in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What happens in oracle commit?
Is oracle an operator?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
