HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

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 %type in pl sql?

0 Answers  

---

What is sqlcommand?

0 Answers  

---

How to assign sql query results to pl sql variables?

0 Answers  

---

Where can I learn sql for free?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

Is not equal in sql?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---