how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 9418 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / ml
select level from dual connect by level < 11;
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
How to use select statement to count the number of rows in oracle?
Can a parameter be passed to a cursor?
What are the parameters that we can pass through a stored procedure?
What are the tools for Oracle ?
How to create a server parameter file?
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 to resolve name conflicts between variables and columns?
How can we delete duplicate rows in a table?
How to load data through external tables?
What is the recommended interval at which to run statspack snapshots, and why?
what are archived logs?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Explain an integrity constrains?
Explain overloading. Can functions be overloaded?
How to get maxsal , minsal, ename department wise in single query
