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
- 4503 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 |
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
what is the use of system.effective.date variable in oracle?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Can you have more than one content canvas view attached with a window ?
What are the uses of synonyms?
Explain constraining triggers.
What is an oracle wallet?
how to create a new database in oracle?
what is difference between where clause and having clause?
Display the number value in Words?
Will you be able to store pictures in the database?
What are the basic element of Base configuration of an oracle Database ?
Oracle General 
