Why is only one row returned

why does the query:

select a.value || b.value
from (select value from v$parameter where name = 'log_archive_dest') a,

   (select value from v$parameter where name = 'log_archive_format') b ;

return only one row? Even though a Comparison is not being used the query only returns one row.

For N joined tables you need at least N-1 equijoin conditions in the where clause to avoid a Cartesian product. Received on Mon Jun 02 2003 - 20:33:22 CEST