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
- 3766 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
Describe an oracle table?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is the string concatenation operator in oracle?
What are synonyms used for ?
what are the default admin accounts in Oracle 10g ?
How do we switch from init.ora file to asp file?
what is the difference between functional dependecy and multilevel dependency?
What is ordinary table in oracle?
What are the various oracle database objects?
13. Display the second to fifth characters in each client name.
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What to do if the binary spfile is wrong for the default instance?
Oracle General 
