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
- 10530 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
What is union and union all keyword in sql?
What are predefined functions in sql?
What is the use of index in hive?
What is the basic structure of an sql?
What is oracle and pl sql?
is it possible to pass an object or table to a procedure as an argument?
How do you modify a trigger?
what is timestamp in mysql? : Sql dba
How can check sql version from command line?
What is procedure explain with example?
What is sql constant?
What are primary key and foreign key and how they work?
How many developers work on postgresql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Why sql query is slow?
