Which certification is best for sql?

0 Answers  

---

how many tupples can insert in 1 second in sql

1 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is having clause in sql?

0 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

Can we use commit inside a trigger?

0 Answers  

---

How do we accept inputs from user during runtime?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

How do I partition in sql?

0 Answers  

---

How will you distinguish a global variable with a local variable in pl/sql?

0 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,

---