Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 11056 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to define and use table alias names in oracle?
Can select statements be used on views in oracle?
When do you get a .pll extension in oracle?
Explain do view contain data?
What is private procedure oracle?
How do I know if oracle client is installed on windows?
interview questions with answer for cts
What is an oracle user account?
What is a table index in oracle?
What is the Tune Query
How to assign a tablespace to a users in oracle?
What is the difference between postgresql and oracle?
What is the dynamic sql in oracle?
Which environment variables are absolutely critical in order to run the OUI?
How to convert dates to characters in oracle?
