var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is it possible to write a query for this ?
I have 2 database tables:
ID LOCATIONS More columns
Every item in the comma separeted list in row LOCATIONS of the table A
ID NAME More Columns
is a key in the row ID of the table B
My problem is, that I need a SQL or PL/SQL query, which produce
Has someone an idea ?
Thanks for you help
PS.: The best solution is to redesign the whole database model, but this is
not an option.
moving thread to oracle forum
william, that's a lovely page, i'll be linking to it in an article i'm writing next week (see http://r937.com/sqlate.cfm)
One issue was not addressed. having a number of keys stored in a single varchar2 field is a bad database design. You should be using three tables
Table A person_ID More columns
Table B location_ID NAME More Columns
Table C person_ID location_id
You do not need a parachute to skydive. You only need a parachute to skydive twice.
I know that this is a bad design, but it is too expensive to change the design.
i think you will find that in the long run it is too expensive to stay with that design, and the sooner you change it, the less it will hurt you
Originally Posted by heikow
as for your immediate problem -- write a program
you need to read both tables into memory -- if they'll fit!! -- and do the matching yourself