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 are the components of Physical database structure of Oracle Database?

4 Answers  

---

What is oracle data type?

0 Answers  

---

How to set up autotrace for a user account?

0 Answers  

---

How to find out what privileges a user currently has in oracle?

1 Answers  

---

Can objects of the same Schema reside in different tablespaces.?

3 Answers  

---

---

what are views?

8 Answers   TCS,

---

What is analyze command used for?

0 Answers  

---

how to get the index id?

1 Answers   Cognizant, TCS,

---

How to get the Installed Oracle Version Information ?

0 Answers   MCN Solutions,

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

can u plz provide me oca sql dumps please i need them

0 Answers  

---