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
- 4477 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to use in conditions in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the different normalization forms?
How much memory your 10g xe server is using?
What privilege is needed for a user to connect to oracle server?
How can Oracle users be audited?
Explain the use of record option in exp command.
why dont we assign not null constraint as table level constraint.
How to change program global area (pga) in oracle?
Can we commit inside a function in oracle?
Can a formula column referred to columns in higher group ?
does the query needs a hint to access a materialized view?
Explain what are the advantages of views?
Explain the types of exception?
