This may be just a general ORacle Question or maybe not. I cannot seem to find any answers anywhere.
I want a simple query “select *” with a where clause that has a variable or Parameter. So when I execute the code I can plug in a value and all statements with that variable/parameter return the results. Like the example below.
Decalare &somevaraible := ‘somevalue’;
Select * from table1 where keyvalue = &somevariable;
Select * from table2 where keyvalue = &somevariable;
Select * from table3 where keyvalue = &somevariable;