how to produce numbers from 1 to 10 using dual table
Answers were Sorted based on User's Feedback
Answer / arunkumar t
select rownum from dual connect by rownum <=10
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anil kumar prajapati
The DUAL is special one row, one column table present by
default in all Oracle databases. The owner of DUAL is SYS
(SYS owns the data dictionary, therefore DUAL is part of the
data dictionary.) but DUAL can be accessed by every user.
The table has a single VARCHAR2(1) column called DUMMY that
has a value of 'X'. MySQL allows DUAL to be specified as a
table in queries that do not need data from any tables. In
SQL Server DUAL table does not exist, but you could create
one.
The DUAL table was created by Charles Weiss of Oracle
corporation to provide a table for joining in internal
views.
Example
Select Row r
From dual
Connect By Row <= :100
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nihar ranjan nath
SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;
Is This Answer Correct ? | 0 Yes | 0 No |
How would you extract DDL of a table without using a GUI tool?
What is an oracle user role?
How do I find the database name in oracle?
How to retrieve data from an cursor to a record?
what are stored procedures?
How to work with data objects interactively?
How to write a left outer join with the where clause in oracle?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Is there an oracle sql query that aggregates multiple rows into one row?
How to get last row id?
How to update a table row with a record?
Can you drop an index associated with a unique or primary key constraint?