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
- 4475 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 to use attributes of the implicit cursor in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is object data modeling?
11. Display the client number and name and the client number and name of the person who referred that client.
What is a trigger oracle?
What is rowid and rownum in oracle?
how to find out second largest value in the table
How to Truncate Table in Oracle
How can I create database in oracle?
Can group functions be used in the order by clause in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
Oracle General 
