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

what is the difference between table and veiw?

4 Answers   IBM,

---

What is an oracle function?

0 Answers  

---

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,

---

What is a trigger and what are its types in oracle?

0 Answers  

---

What are temporal data types in oracle?

0 Answers  

---

What operating systems are supported by oracle database 10g xe?

0 Answers  

---

What happens if you set the sga too low in oracle?

0 Answers  

---

What is catalog in Oracle?

0 Answers   MCN Solutions,

---

What is oracle database 10g express edition?

0 Answers  

---

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

What is an Extent ?

3 Answers  

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

0 Answers  

---