Answer / anil

select * from table_name where dept='Marketing'

Answer / guneetinder singh

select ename from emp where deptname = 'Marketing'

ename = employee name.
deptname= department name

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

How to create a table index?

0 Answers  

---

What is private procedure oracle?

0 Answers  

---

how to select second mauximum value in a given table under salary column

6 Answers   Sapient,

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

What is oracle rownum?

0 Answers  

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

0 Answers  

---

What is null value in oracle?

0 Answers  

---

What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,

---

How to view the dropped tables in your recycle bin?

1 Answers  

---

What are synonyms used for ?

3 Answers  

---

Explain what are the characteristics of data files?

0 Answers  

---