What is the use of nvl function?

0 Answers  

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

How do you write an index?

0 Answers  

---

What is delete command in sql?

0 Answers  

---

How does an execution block start and end in pl sql?

0 Answers  

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

What are the different dcl commands in sql?

0 Answers  

---

Explain scalar functions in sql?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

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,

---