SQL CURSOR

From: Mattias Malmgren <a2matmal_at_ulmo.stud.slu.se>
Date: Wed, 01 Jul 1998 16:02:21 +0200
Message-ID: <359A416C.6721D5DF@ulmo.stud.slu.se>

I have got 2 tables

doc:
id head-line
1 head 1
2 head 2

doc_text
fk_doc order text

1       1       part 1 of doc 1
1       2       part 2 of doc 1
2       1       part 1 of doc 2

I need to return a CURSOR that is:

id head-line concat_text

1  head 1     part 1 of doc 1 part 2 of doc 1
2  head 2     part 1 of doc 2

Can anyone help me to create a select-statement or a PL/SQL block that would
create a CURSOR like that.

Thanx in advance! / Mattias Received on Wed Jul 01 1998 - 09:02:21 CDT