select a.表名,a.主键,a.添加人,b.日期 from tableA a,tableB b where a.主键=b.井号试下这个SQL
select a.表名, a.主键, a.添加人, b.日期 from tableA a,TESTDAT b where a.表名 = 'TESTDAT' and a.主键 = 'jh=''' || b.井号 || ''''
可以通过存储过程实现,传入A表名称,要先建立一个游标类型(我这省了) create or replace function(tableA varchar2,cur cursorType) return number is result number:=0; sql varchar2(512); tableB varchar2(50); BPK varvhar2(20); begin open cur for select 表名,主键 from tableA; fetch cur into tableB,BPK; if cur%found then sql='select '||tableA||'.*,'||tableB||'.日期 from '||tableA||','||tableB||'where '||tableA||'.主键='||BPK; close cur; end if; open cur for sql; end;
select a.表名, a.主键, a.添加人, b.日期
from tableA a,TESTDAT b
where a.表名 = 'TESTDAT'
and a.主键 = 'jh=''' || b.井号 || ''''
create or replace function(tableA varchar2,cur cursorType) return number
is
result number:=0;
sql varchar2(512);
tableB varchar2(50);
BPK varvhar2(20);
begin
open cur for select 表名,主键 from tableA;
fetch cur into tableB,BPK;
if cur%found then
sql='select '||tableA||'.*,'||tableB||'.日期 from '||tableA||','||tableB||'where '||tableA||'.主键='||BPK;
close cur;
end if;
open cur for sql;
end;