Duplicate a record

Hi,

I need to duplicate the records from a query i.e. each record should be printed twice.

Below is my query:

SELECT
case when substr(tblstaticmasterfunds.HIPORTFOLIOFUNDCODE,1,4)='L048' then 'L048AW'
       when substr(tblstaticmasterfunds.HIPORTFOLIOFUNDCODE,1,4)='L050' then 'L050'
       else tblstaticmasterfunds.HIPORTFOLIOFUNDCODE end ||
       To_char(PriceDate, 'YYMMDD') || '04'
       IDX_TEXT
FROM
      (
            select date_ as boxdate,pricedate as pricedate,date_ as morleydate,nextdate as nextdate from
            tblstaticboxdates where boxdatemkr=-1
      ), tblXactInterfund,tblstaticmasterfunds ,tblStaticAssetFunds,tblStaticCurrencies ,tblXactExchange
      WHERE ASSETFUNDID=INVESTEDFUNDID  
      AND  FUNDID=INVESTEDFUNDID
    AND to_date(DateTimeStamp,'DD-MM-RRRR')=to_date(Boxdate,'DD-MM-RRRR')
      AND tblStaticCurrencies.CurrencyID=BoxGroupID
      AND tblXactExchange.CurrencyID=BoxGroupID  
      AND TO_DATE(tblXactExchange.DATE_,'DD-MM-RRRR')=TO_DATE(BoxDate, 'DD-MM-RRRR')
      AND ASSETFUNDID=FUNDID
      AND MorleyFund = 0

and below is its result.

IDX_TEXT
------------------------
E501YA08082204
E500YA08082205
E500YA08082206


The output should be in such a way that each record is printed twice.

IDX_TEXT
-----------------------
E501YA08082204
E501YA08082204
E500YA08082205
E500YA08082205
E500YA08082206
E500YA08082206

Please suggest the best and easist way to achieve this with examples..

This final query should be easily maintainable so that anyone wishing to change this should be able to it easily.

Thanks !

Start Free Trial