Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 10907 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
Please explain oracle data types with examples?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Why does oracle 9i treat an empty string as null?
Explain integrity constraints?
How to generate query output in html format?
What are the restrictions in a oracle read only transaction?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to invoke the data pump import utility?
Describe an oracle table?
What is oracle datasource?
How to define a variable to match a table column data type?
How to get a create statement for an existing table?
How to use windows user to connect to the server?
What is ordinary table in oracle?
How to retrieve data from an cursor to a record?
