How to repeate records in view? (SQL)
From: Anna Szmigielska <anna.szmigielska_at_quantum.pl>
Date: Tue, 31 Jul 2001 12:37:56 +0200
Message-ID: <996575854.653319_at_kwark.quantum.pl>
Date: Tue, 31 Jul 2001 12:37:56 +0200
Message-ID: <996575854.653319_at_kwark.quantum.pl>
(Oracle 8i)
Is that possible in SQL to repeate records in view? (View can be only READ).
I need such view, that every record from VIEW2 is repeated _n_ times, where
_n_ is value: VIEW2.column1.
It's possible, if I e.g. create new table with only one column (values in
records are: 1,2,3,4,5.....) to join it to my view... has anyone more simple
solution?
Regards
Anna Szmigielska
Received on Tue Jul 31 2001 - 12:37:56 CEST