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
- 4652 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 are the restrictions on external table columns?
Name the three major set of files on disk that compose a database in Oracle?
How to load a large xml file?
How many categories of data types in oracle?
what happened to the global index when I truncate the data in one of the partition?
What are the data types in oracle?
Can multiple cursors being opened at the same time?
Explain integrity constraint?
What operating systems are supported by oracle database 10g xe?
Explain the use of record option in exp command.
How can windows applications connect to oracle servers?
How do you bind variables in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are the tools for Oracle ?
