what are date and time data types in mysql? : Sql dba

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What are string functions in sql?

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,

---

What is foreign key in sql with example?

0 Answers  

---

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

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 acid property in database? : Sql dba

0 Answers  

---

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

7 Answers   HP,

---

Why do we create stored procedures & functions in pl/sql and how are they different?

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,

---

How can you create Cursor with parametres ?

3 Answers  

---