Answer / ml

select level from dual connect by level < 11;

Answer / arunkumar t

select rownum from dual connect by rownum <=10

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

Answer / nihar ranjan nath

SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;

How are extents allocated to a segment?

0 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

---

Explain what are clusters?

0 Answers  

---

How do we represent comments in oracle?

0 Answers  

---

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

Explain compound trigger in oracle?

0 Answers  

---

How to see the table columns used in an index?

0 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---