Igor, thank you very much!
BTW, yes, the schema is 'as is' and i have to convert it, but how to converts rows to columns and add to other columns? ;-) Regards, e. Цитат на писмо от Igor Tandetnik <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > it there a way to execute a SQL query generated by > SELECT ? > > for eg. : > > select 'insert into plan (personid, curseid, statid) > select > > tbl.excelid, ' || id || ',status.id from tbl, status > where > > tbl.' || fldname || ' = status.name ;' from curses; > > No, not really. You have a rather unusual database > schema, what with one > table storing field names from another table. I'd > reconsider this > design. > > Assuming you insist on this structure, you can do > something like this: > > insert into plan (personid, curseid, statid) > select tbl.excelid, curses.id, status.id > from tbl, status, curses > where > (case curses.fldname > when 'fld1' then tbl.fld1 > when 'fld2' then tbl.fld2 > when 'fld3' then tbl.fld3 > ... > end) = status.name; > > Igor Tandetnik > > >
