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
- 4576 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 |
How many types of table in Oracle?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Please explain drop constraint oracle?
What happens to the current transaction if a ddl statement is executed?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to define a procedure inside another procedure?
What are the differences between interval year to month and interval day to second?
What is the difference between sharding and replication?
Explain the use of indexes option in exp command.
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Explain the blob datatype?
Oracle General 
