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"
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
How to test null values?
Explain the use of Merge statement in oracle 11g
What happens if the imported table already exists?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is execute immediate in oracle?
definition of cluster and non-clustered index?
How to convert numbers to characters in oracle?
Why do we use coalesce function in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How do we display rows from the table without duplicates?
How does Oracle guarantee data integrity of data changes?
What is an Oracle index?
What is redo log?
How to export data with a field delimiter?
How to turn on or off recycle bin for the session?