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
- 10310 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
How do I truncate a sql log file?
when MSQL8.0 is in market
What is materialized view. What are different methods of refresh?
What is varchar example?
What are the ddl commands?
what is the syntax used for partition in tsql? : Transact sql
What is difference between pls_integer and integer?
What is %type in pl sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is an example of translating a date into julian format?
what are null values? : Sql dba
How can you load microsoft excel data into oracle? : aql loader
what is the difference between delete and truncate statement in sql? : Sql dba
Explain locks? : Transact sql
I need a function for a train ticket reservation please answer it thanks in advance
