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
What is the quickest way to export a table to a flat file?
How to initialize variables with default values?
What is max rowid in oracle?
How do we display rows from the table without duplicates?
6. Display the client name and order date for all orders using the traditional method.
How to save query output to a local file?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to synchronize 2 schema's objects?
What is a package ? What are the advantages of package ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to establish administrator authentication to the server?
What are the execution control statements?
Can we store pictures in the database and if so, how it can be done?
How many categories of data types in oracle?
What is a nested table and how is it different from a normal table?