What is the use of procedures?

0 Answers  

---

What is faster join or subquery?

0 Answers  

---

What is a file delimiter?

0 Answers  

---

what are different types of keys in sql?

0 Answers  

---

What is the purpose of the primary key?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What is join view in sql?

0 Answers  

---

Does sql*plus have a pl/sql engine?

0 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What is PL/SQL Records?

0 Answers  

---