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
- 3810 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 |
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
what are the database links ?
How to insert a record into a table?
Briefly explain what is literal? Give an example where it can be used?
What is meant by raw datatype?
Explain the use of rows option in imp command.
how to select second mauximum value in a given table under salary column
Please explan Why static query is more faster than dynamic query ?
How to call a stored procedure inside a trigger? Give an example.
what are steps for interface? where is exchange rate defined in which table?
Can you tell me how to add new column in existing views?how?How is possible?
Explain an index segment?
Oracle General 
