What are joins..how many types of joins are there?
Answer Posted / guruswamy
join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins
| Is This Answer Correct ? | 15 Yes | 21 No |
Post New Answer View All Answers
How to display employee records who gets more salary than the average salary in the department?
What is the sid in oracle?
Differentiate between translate and replace?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What happens if the imported table already exists?
How to export data to a csv file?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Is postgres faster than oracle?
What is oracle update statement with inner join ?
What is the dynamic sql in oracle?
What privilege is needed for a user to connect to oracle server?
How to define an anonymous procedure without variables?
How do we represent comments in oracle?
what are the default admin accounts in Oracle 10g ?
What is a nested table?