Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 10723 Views
- Genpact, I also Faced
- E-Mail Answers
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 |
Explain the use of parfile option in exp command.
Difference between oracle's plus (+) notation and ansi join notation?
How do I connect to oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What is a parameter file in oracle?
What is sharded cluster?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How do I spool to a csv formatted file using sqlplus?
What are the different types of partitions in oracle?
Can objects of the same Schema reside in different tablespaces.?
How to create an oracle testing table?
What is dictionary cache ?
Oracle General 
