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

Can you call pl/sql package functions from within a fast formula?

0 Answers  

---

What is dcl in sql?

0 Answers  

---

How do you truncate?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

what is explain plan?

4 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

How to get second highest salary from a table

3 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is the plv (pl/vision) package offers?

0 Answers  

---