Hi All,
1. Can we access data of GTT tables without useng synonym and without using harcoded schema name?
2. Can we create synonym for GTT tables ??
if Yes then how oracle access it?
because GTT tables are sesssion specific.
example:
We have
| schema name | x |
| procedure name | p1 |
| GTT table | g1 |
we are calling procedure in Y schema .
begin
p1;
end;
Thanks,