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 get execution statistics reports on query statements?
What privilege is needed for a user to connect to oracle server?
How to create a new table in oracle?
what are the default admin accounts in Oracle 10g ?
How to count duplicated values in a column in oracle?
How to load excel data sheet to oracle database
How to assign a table row to a record variable?
In what script is snap$ created? In what script is the scott/tiger schema created?
What are the differences between primary key and unique key?
What is the relationship among database, tablespace and data file?
What is null value in oracle?
can u plz provide me oca sql dumps please i need them
What is oracle datasource?
Explain the use of indexes option in imp command.
What is the data type of dual table?