Can we relate two different tables from two different users
in ORACLE,PL/SQL?
- 4 Answers
- 9725 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
What is sql injection owasp?
What is the use of <> sql?
How to prepare for oracle pl sql certification?
How do you declare a variable in pl sql?
What does where 1 1 mean in sql?
what is oltp (online transaction processing)? : Sql dba
What are transaction and its controls?
How subquery works in sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What does the argument [or replace] do?
How to change sql*plus system settings?
What is the need of merge statement?
What are database links used for?
How do I view tables in mysql?
