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 / chiranjeevi
select level+49 from dual connect by level<=100
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to view the data files in the current database?
What is rowid and rownum in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is a system tablespace?
List the parts of a database trigger.
does the query needs a hint to access a materialized view?
What happens to the indexes if a table is recovered?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What privilege is needed for a user to connect to oracle server?
How to generate query output in html format?
How to use "if" statements on multiple conditions?
What is the difference between sharding and partitioning?
How to define and use table alias names in oracle?
What are the differences between number and binary_float in oracle?
why dont we assign not null constraint as table level constraint.