Dual function

[amitgoyal84]

Using only DUAL table, how can you display (with Select statement) multiple rows (at least 2 rows) ?

Example:

HELLO
--------------
1
1
1
1
1
1
1
1
1
1

[Ganon11]

WHat do you mean? What program are you talking about?

Perhaps this thread would be more appropriate in another forum...

[Motoma]

Using only DUAL table, how can you display (with Select statement) multiple rows (at least 2 rows) ?

Example:

HELLO
--------------
1
1
1
1
1
1
1
1
1
1

I think this thread belongs in the Oracle forum.

[AricC]

If your table is set up like this:
TTeams
intTeamID
strTeam

You can select all by:
SELECT * FROM TTeams

Or specify what you want the statement to return
SELECT strTeam FROM TTeams etc...