what are date and time data types? : Sql dba

0 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

Can pl sql procedure have a return statement?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

Why do we use sql constraints?

0 Answers  

---

---

How to find the count of letter "L" in HELLO

7 Answers   HP,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

How do you write a complex sql query?

0 Answers  

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---

Explain clause in sql?

0 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,

---

How is pl sql different from sql?

0 Answers  

---