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
- 4167 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 |
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
Give the different types of rollback segments.
Explain rename?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
is there a tool to trace queries, like profiler for sql server?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is oracle database client?
What is a data segment ?
How to create a new tablespace in oracle?
How to export data with a field delimiter?
How can you merge two tables in oracle?
Oracle General 
