we would like to create a dynamic search function for the whole database
begin
:global.variabele := '=';
select person_name
into :test
from persones
where person_id ||:global.variabele|| 1;
end;
How to make a select statement dynamically ( >,<,=)?
does anyone has an idea for searching all tables of a database at the same time ?
begin
:global.variabele := '=';
select person_name
into :test
from persones
where person_id ||:global.variabele|| 1;
end;
How to make a select statement dynamically ( >,<,=)?
does anyone has an idea for searching all tables of a database at the same time ?