Re: SQL query question

Disco wrote:

> CREATE TABLE "TARGET"(
> "ID" NUMBER(11),
> "NOTETITLE" VARCHAR2(254),
> "DESCRIPTION" VARCHAR2(254),
> "RELNOTES" VARCHAR2(254),
> "IMPLEMENT" VARCHAR2(254),
> "COMMENTS" VARCHAR2(254),
> CONSTRAINT "ID" PRIMARY KEY(
> "ID" ))

<snipped>

>
> ...So, for each TARGET record, there will be four notes records. Each one
> expecting data from different columns.

CREATE OR REPLACE VIEW targetnote AS
SELECT
  id ID,
  'Description' NOTE_TYPE,
  description NOTE
FROM target
UNION ALL
SELECT
  id,
  'Release Notes',
  relnotes
FROM target
UNION ALL
SELECT
  id,
  'Implementation',
  implement
FROM target
UNION ALL
SELECT
  id,
  'Comments',
  relnotes
FROM target

--
Billy