storing data horizontal vs vertical using pl/sql

From: raja rao <raja4list_at_yahoo.com>
Date: Wed, 18 Jan 2006 07:59:19 -0800 (PST)
Message-ID: <20060118155919.75782.qmail@web31408.mail.mud.yahoo.com>

Hi Team,

Can someone help me in moving the data from one table into multiple tables.

The situation is:
I have a table called hospital that contains the below columns:

acct#, medrec#, diagnosis(dx1), dx2,dx3,dx4.... dxN

Right now i have everythign in one table called hospital. But management requires this data to be split into 2 tbales.

1 is the header table which should contain only acct#,medrec# 2. the second table(line items) should be able to hold the diagnosis information.

the second table strucure is like this:

  desc ICD9_DX
  acct# number,
mr# number,
dx number
position number

the hospital table (main table) will hold data like this for diagnosis: 101.1, 980.0, 7878.1, 7484.1, 5734.4 ..............

But this diagnosis should store like this in the ICD_9_DX table:

diagnosis position

101.1         1
980.0         2
7878.1        3
7484.1        4
5734.4        5

can someone give me some hint how this can be achieved with pl/sql.

Thakns in advance,
Raj

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 18 2006 - 10:01:34 CST