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 use of rank function?

1 Answers  

---

How many file formats are supported to export data?

0 Answers  

---

definition of cluster and non-clustered index?

0 Answers   CSS,

---

Explain an exception?

0 Answers  

---

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,

---

---

Explain the use of analyse option in exp command.

0 Answers  

---

What privilege is needed for a user to connect to oracle server?

0 Answers  

---

Which is faster join or subquery in oracle?

0 Answers  

---

How to create an oracle database?

0 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

how to get count of tables in particular database in Oracle?

3 Answers  

---

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---