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,

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What are sql built in functions?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

What is pl sql package?

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

How to Declare Fixed Length String Value In PL SQL

0 Answers  

---