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
- 4492 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 are the different types of failures that occur in Oracle database?
structural difference between bitmap and btree index ?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
Select the Nth lowest value from a table?
What are the data types in oracle?
Respected sir, Please send me technical questions related to oracle apps..
Explain constraining triggers.
Why do you use stored procedures and state some of its disadvantages?
Where do you use decode and case statements?
What are inner join and outer join?
What is the difference between substr and instr?
how may join possible between (requisition with purchase order)
Oracle General 
