Can we relate two different tables from two different users
in ORACLE,PL/SQL?
- 4 Answers
- 8996 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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))
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we join tables without foreign key?
what is the syntax used for partition in tsql? : Transact sql
what tools available for managing mysql server? : Sql dba
What is trigger explain with example?
What are the different ways to optimize a sql query?
What is where clause in sql?
What is on delete restrict?
How do I view a sql trace file?
Does sql view stored data?
What's the difference between a primary key and a clustered index?
Which is faster count (*) or count 1?
What do you mean by stored procedures?
what are all types of user defined functions? : Sql dba
How to place comments in pl/sql?
What are joins in sql?
