What does select * from mean in sql?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

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 Suneel Reddy

6 Answers   Target,

---

Why do we go for stored procedures?

0 Answers  

---

---

What is execution plan in sql?

0 Answers  

---

how to delete an existing column in a table? : Sql dba

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

what is global variable in package

3 Answers   Polaris,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---