Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 10724 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
What is pragma autonomous transaction in oracle?
Explain table?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is integrity and what is constraint??Explain with example
What is using clause and give example?
What are the extensions used by oracle reports?
What is a table in oracle?
How to view all columns in an existing table?
Explain the use of full option in exp command.
Describe varray?
What is the difference between $oracle_base and $oracle_home?
How would you begin to troubleshoot an ORA-3113 error?
What is a directory object?
Why is oracle used?
What is the maximum limit on the number of columns in a table?
