Version:11.2
create table test1 (name1 varchar2(10));
insert into test1 values ('JUPITER');
insert into test1 values ('EARTH');
insert into test1 values ('MARS');
insert into test1 values ('VENUS');
commit;
SQL> select * from test1;
NAME1
----------
JUPITER
EARTH
MARS
VENUS
For each values of this table, I want three rows to be returned with the string
JUPITER is a planet
JUPITER is almost round
JUPITER revolves around the sun
EARTH is a planet
EARTH is almost round
EARTH revolves around the sun
MARS is a planet
MARS is almost round
MARS revolves around the sun
.
.
.
Any idea how I could do this ?