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
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Whether any commands are used for months calculation? If so, what are they?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to assign data of the deleted row to variables?
What is a cursor in oracle?
Explain oracle’s server parameter file.
What is sharded cluster?
How do I call oracle stored procedures that take no parameters?
What is the usage of analyze command in oracle?
How a database is related to tablespaces?
What are the uses of linked server and explain it in detail?
What do database buffers contain?
Give the constructs of a package, function or a procedure.
What is hot backup and logical backup?
How a tablespace is related to data files?