how to produce numbers from 1 to 10 using dual table
Answer Posted / arunkumar t
select rownum from dual connect by rownum <=10
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to create an oracle database manually?
What is the usage of save points in oracle database?
Can we protect our pl/sql source code?
List out the difference between commit, rollback, and savepoint?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is a package in oracle?
What is dynamic proxy?
How to select some columns from a table in oracle?
What is meant by joins?
What is a proxy class?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how can db_files > maxdatafiles since db_files is for instance and the later is for database
what is insert all statement in sql
What is a sub query and what are the different types of subqueries?
Difference between cartesian join and cross join?