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 error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---

What are the advantages of pl sql?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

Explain the difference between triggers and constraints?

0 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---

Explain what is a field in a database and record in a database?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

---

what is an associative array with example?

1 Answers  

---