Answer / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

Answer / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join


oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

Answer / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

What are the disadvantages of file system?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

What is nvarchar in sql?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

What are the sql aggregate functions?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

Can a foreign key be null?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

what is subquery? : Sql dba

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

Where the Pre_defined_exceptions are stored ?

2 Answers  

---