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
- 11903 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answer Posted / obulesu
select length(regexp_replace('s,a,d,abc',','))
countofcharecter from dual
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a table index?
What is the difference between postgresql and oracle?
Can you drop an index associated with a unique or primary key constraint?
How to rebuild an index in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain the use of file option in exp command.
How to rename a tablespace in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to get a list of all user accounts in the database?
How to drop an index in oracle?
what is the scenario where you take the database to NoArchivelog mode?
Is a rollback possible to any savepoint?
Is there an oracle sql query that aggregates multiple rows into one row?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
