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
- 10493 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
Can we delete column in sql?
What is the difference between pl and sql?
What pl/sql package consists of?
What is rownum?
How to start the command-line sql*plus?
What is data control language (dcl)?
Is sql between inclusive?
How do you rank data in sql?
Difference between global and parameter variables?
What is the usage of nvl function?
how to drop an existing index in mysql? : Sql dba
What is a primary key? Explain
What is offset and limit in sql?
Are subqueries faster than joins?
what is the difference between truncate and delete statement? : Transact sql
