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
- 4597 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 |
20. Using a set operator, display the client number of all clients who have never placed an order.
How to define and use table alias names in oracle?
what is the difference between authorization and authentication?
Explain 1st, 2nd, 3rd normalization form of data base
How to loop through data rows in the implicit cursor?
What is the difference between alert log file and trace file ?
What is Trace File ?
How to change user password in oracle?
Explain about achiever in sql?
Is there a function to split a string in plsql?
what is the use of rank function?
What is autonomous transaction?
Oracle General 
