Answer / santosh pachauri

Triggers are the precompiled statement stored in the
database and fired by the server when you want to
insert,delete,update record.

Show the cursor attributes of pl/sql.

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

Which table is left in left join?

0 Answers  

---

What is sqlcommand?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

What is rownum and rowid?

0 Answers  

---

how can i create a user defined datatype

3 Answers  

---

what is overloading procedure or overloading function ?

3 Answers   Genpact,

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---