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
- 11462 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
Please explain compound trigger in oracle?
What is not equal to in oracle?
How are extents allocated to a segment?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to use windows user to connect to the server?
What are the attributes of cursor?
How do we display rows from the table without duplicates?
How to use existing values in update statements using oracle?
Why do we use coalesce function in oracle?
How can I introduce multiple conditions in like operator?
What are data pump export and import modes?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What are set operators?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Which environment variables are absolutely critical in order to run the OUI?
