Answer / kiran r

Triggers are classified as follows
1. Based on Trigger level
Row level Trigger and Statement level trigger
2. Based on time
Before, after, Instead
3. Based on Event
DDL, DML,Database Trigger

Is primary key clustered or nonclustered?

0 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

How to read xml file in oracle pl sql?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

What are the components of a PL/SQL block ?

3 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

Where is all the data on the internet stored?

0 Answers  

---

What is count * in sql?

0 Answers  

---

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

---