Answer / swapna

stored procedures are subprogrammes stored in the database
and can be called & execute multiple times where in an
application procedure is the one being used for a
particular application same is the way for function.

Can you join a table to itself?

0 Answers  

---

What is a unique key and primary key and foreign key?

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  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is sql resultset?

0 Answers  

---

Is primary key is clustered index?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

What is trigger and types?

0 Answers  

---

What is on delete set null?

0 Answers  

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

What is pivot query?

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---