Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to join two tables, that are in two different
users (e.g. SCOTT and HR etc.),but im same database
(e.g. ORCL)?
If yes, then how it is possible?
Explain with step by step procedure.
- 1 Answers
- 4593 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / suresh babu
yes,it is possible.first create departments table in scott
user,the employees table located in HR user.
Step1:
create table departments as select * from HR.departments;
after execute this query:
select e.first_name,d.department_name from HR.employees
e,SCOTT.departments d where e.department_id = d.department_id;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is flashback in Oracle?
What are the differences between number and binary_float in oracle?
How to connect ms access to oracle servers?
How to list all indexes in your schema?
Explain the use of file option in exp command.
What is an oracle recycle bin?
What is Reduced List of Values?
Explain enable novalidate constraint.
How to define a sub function?
How many types of auditing in Oracle?
How to load data from external tables to regular tables?
How to compare dates in oracle sql?
what is Single Byte Overhead...?
What are group functions in oracle?
Why we use bulk collect in oracle?
