what is 'mysqld'? : Sql dba

0 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

What is cross join sql?

0 Answers  

---

what is a control file ? : Sql dba

0 Answers  

---

Why join is faster than subquery?

0 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

What is pivot query?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

How do I start sql profiler?

0 Answers  

---

What is sql query limit?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---