Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.



Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im ..

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

Post New Answer

More Oracle General Interview Questions

20. Using a set operator, display the client number of all clients who have never placed an order.

0 Answers   Wipro,


How to define and use table alias names in oracle?

0 Answers  


what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,


Explain 1st, 2nd, 3rd normalization form of data base

3 Answers   KH, Thermotech,


How to loop through data rows in the implicit cursor?

0 Answers  


What is the difference between alert log file and trace file ?

1 Answers  


What is Trace File ?

4 Answers   Thermotech,


How to change user password in oracle?

0 Answers  


Explain about achiever in sql?

0 Answers  


Is there a function to split a string in plsql?

0 Answers  


what is the use of rank function?

1 Answers  


What is autonomous transaction?

6 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)