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
- 4518 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
Please explain oracle data types with examples?
What is translate in oracle?
What is a table index?
How to do clean up if create database failed?
What is the difference between PFILE and SPFILE in Oracle?
what are bitmap indexes? How does they work?
List out the difference between commit, rollback, and savepoint?
How to assign a table row to a record variable?
Explain the difference between sql and oracle?
Explain self joins in oracle?
What is oracle thin client?
How do I know if oracle is installed on windows?
Why use resource manager in Oracle?
What is a schema in oracle?
What do you understand by a database object? Can you list a few of them?
