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

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is full join?

0 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

How many triggers can be applied on a table?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

What does pl sql developer do?

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What is group by in sql?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

What is cursor and its types?

0 Answers  

---