Interested to Buy Any Domain ? << Click Here >> for more details...
Can we relate two different tables from two different users
in ORACLE,PL/SQL?
- 4 Answers
- 10663 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
Yes we can relate two tables from 2 different users
E.g. if user A has table Ta and User B has Table Tb and
Table Tb is child table and needs foreign
key on A.Ta then
we need to grant "references" object privillege to User B
on table Ta.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Are stored procedures faster than queries?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How do I partition in sql?
What does t sql mean?
Compare sql & pl/sql
What is data type in sql?
How do I create an index in word?
what are the advantages a stored procedure? : Sql dba
Does sql*plus also have a pl/sql engine?
What is pl sql code?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What does count (*) mean?
How do you declare a user-defined exception?
What are instead of triggers?
