how to produce numbers from 1 to 10 using dual table
Answers were Sorted based on User's Feedback
Answer / arunkumar t
select rownum from dual connect by rownum <=10
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / nihar ranjan nath
SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;
Is This Answer Correct ? | 0 Yes | 0 No |
How to write a query with a full outer join in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How data locks are respected in oracle?
WHT ARE THE AGGREATE FUNCTIONS?
How do I limit the number of rows returned by an oracle query after ordering?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to add a new column to an existing table in oracle?
25. Display the client number and the value of the highest value order placed by that client.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
waht is referencial integrity?
What is difference between sid and service name in oracle?