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
- 4573 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
State and explain about oracle instance?
How view is different from a table?
What the is the diff between local index and global index. give some example.
How can we view last record added to a table?
How to build data dictionary view an new database?
Will you be able to store pictures in the database?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is archive log in Oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the attributes of cursor?
What is hot backup and logical backup?
How to connect the oracle server as sysdba?
What are data pump export and import modes?
Explain the use of control file?
How to list all tables in your schema?
