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 / ajit
select level+49 from dual connect by level<=51
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is recovery manager in Oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is a static data dictionary in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Explain the use of file option in exp command.
What is the difference between substr & instr functions?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is oracle rownum?
What are the restrictions on external table columns?
What is a trigger and what are its types?
How to use fetch statement in a loop?
Why cursor variables are easier to use than cursors?
how may join possible between (requisition with purchase order)