tell us something about heap tables. : Sql dba

0 Answers  

---

What is the difference between rollback and rollback to statements?

0 Answers  

---

What is set serveroutput on?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

Can one improve the performance of sql*loader? : aql loader

0 Answers  

---

what are the authentication modes in sql server? : Sql dba

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

What is on delete set null?

0 Answers  

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

What do we need to check in database testing?

0 Answers  

---

Where the Pre_defined_exceptions are stored ?

2 Answers  

---