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;

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

How to connect the oracle server as sysdba?

0 Answers  

---

What is the difference between a primary key & a unique key?

0 Answers  

---

what are archived logs?

0 Answers  

---

What is Private Database Link ?

1 Answers  

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

0 Answers   Intelligroup,

---

Where is the export dump file located?

0 Answers  

---

Explain oracle’s system global area (sga).

0 Answers  

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

how to get last monday of a month?

2 Answers   Multifonds,

---