how to produce numbers from 1 to 10 using dual table
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
What is a table index in oracle?
Whether any commands are used for months calculation? If so, what are they?
What is the difference between online and offline backups?
What is the max number of columns in an oracle table?
How to view all columns in an existing table?
What are the different types of record groups in oracle? Explain each of them
How to estimate disk space needed for an export job?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is hash cluster in oracle?
what are archived logs?
How a database is related to tablespaces?
Explain the blob datatype?
How to change user password in oracle?
What are joins, explain all types of joins?
What are the advantages of oracle 12c?