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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to convert characters to dates in oracle?
Respected sir, Please send me technical questions related to oracle apps..
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is system global area (sga) in oracle?
How to use fetch statement in a loop?
Use of an integrity constraint is better to validate data. Explain
How to define an anonymous block?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Explain coalesce function?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain integrity constraints?
What is control file used for?
What are the varoius components of physical database structure of oracle database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?