how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

What is an intersect?

0 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

Are subqueries better than joins?

0 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

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,

---

Is sql a case sensitive language?

0 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

What is the use of function "module procedure" in pl/sql?

0 Answers  

---

What is sequence in sql?

0 Answers  

---

What is sqlexception in java?

0 Answers  

---

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

---