Answer / sakthi santhanam.a

yes, we can do that... in oracle using GRANT command..
" GRANT select on table_name to nextuser(2nd user)"
this is the query...
wish you all the success
sakthi.A

Answer / shilpa.oracle

Yes, we can relate tables of different schemas provided we
should have privileges on that table

create table test_emp
(empno number(5),deptno number(5),constraint dept_ref
foreign key (deptno) references schema.dept(deptno))

Answer / sakthi santhanam.a

yes, we can do that... in oracle using GRANT command..
" GRANT select on table_name to nextuser(2nd user)"
this is the query...
wish you all the success
sakthi.A

Answer / 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.

Which is better join or inner query?

1 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

Which nosql database is best?

1 Answers  

---

What are sql indexes?

1 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What are different types of keys?

1 Answers  

---

Can we join two tables without common column?

1 Answers  

---

What is materialised View?

2 Answers   IBM,

---

How to know the last executed procedure?

1 Answers  

---

What are the types of triggers in sql?

1 Answers  

---

How do I add a database to sql?

1 Answers  

---

Which join is like an inner join?

1 Answers  

---