What is sql analyzer?

0 Answers  

---

How many joins in sql?

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

Why use subqueries instead of joins?

0 Answers  

---

Which tcp/ip port does sql server run?

0 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

What is sqlerrd?

0 Answers  

---

Is sql between inclusive?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---