how many ways to get the current time? : Sql dba

0 Answers  

---

What is trigger with example?

0 Answers  

---

Is sql an operating system?

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,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is memory optimized?

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

What is scalar function in sql?

0 Answers  

---

What is compound trigger?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---