Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 10770 Views
- Genpact, I also Faced
- E-Mail Answers
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 |
Explain the features of oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is dictionary cache ?
how to get the no employee in each department including the dept which has 0 employee
what is null value?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain the difference between sap and oracle?
What are the attributes that are found in a cursor?
List the parts of a database trigger.
Oracle General 
