Display date in oracle based on flag

From: sgupta <sugandha_g_at_yahoo.com>
Date: 16 Oct 2001 06:34:46 -0700
Message-ID: <62deede6.0110160534.597afdae_at_posting.google.com>

[Quoted] [Quoted] My apologies if this seems elementary but I am new . I have a oracle table with fields

Date sale # Flag_book Flag_audio Book Audio

XXX   1       Y          Y         3     1
XXX   2        Y         N         3     0

I want to use ap to display it as this on a webpage. Any help with queries is appreciated. Thanks in advance!

Date Sale # item_type no

XXX    1          book    3
XXX    1          audio   1
XXX    2         book     3

Thanks very much. Any help appreciated Received on Tue Oct 16 2001 - 15:34:46 CEST