Hi everyone,
I'm working in a PL/SQL and I'd like to use the same PL for 2 kinds of tables... I have "valepag" and "valerec" both tables have the same columns, but one is for debit and the other one is for credit, the PL will work for both cases with the unique diference for the name of the table... So I thought to use something like this: ... For rSql in select a.adiant, a.desc_per from case when cTip='P' then valapag else valerec end where cod=2 Loop ... But it just dont work... does some one have other solution for this case ? Thanks guys. -- Grato, Mauricio Cruz Sygecom Informática [1] 51 3442-3975 / 3442-2345 Links: ------ [1] http://www.sygecom.com.br
