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


Please Help Members By Posting Answers For Below Questions

How to define an explicit cursor in oracle?

603


1) Does oracle have any table which contain all the exceptions and it's code internally?

1282


Explain oracle data types with examples?

577


How do I start tns listener?

542


How do I reset a sequence in oracle?

596






How to export several tables together?

568


Briefly explain what is literal? Give an example where it can be used?

543


What is an index associated with a constraint?

550


What is the data pump import utility?

584


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

612


why dont we assign not null constraint as table level constraint.

2253


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1788


What is the difference between "as" and "is" in an oracle stored procedure?

540


Explain alias?

714


How do I escape a reserved word in oracle?

630