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

Explain an index segment?

0 Answers  

---

What is an oracle?

0 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

what is the difference between restoring and recovering?

0 Answers   MCN Solutions,

---

What is Reduced List of Values?

0 Answers   iFlex,

---

What is oracle join syntax?

0 Answers  

---

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

1 Answers  

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

---

What is a deadlock ? Explain .

1 Answers  

---

what r tyhe major differences between oracle 9i & 10g?

6 Answers  

---