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

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

Explain 1st, 2nd, 3rd normalization form of data base

3 Answers   KH, Thermotech,

---

Can the query output be sorted by multiple columns in oracle?

0 Answers  

---

DBMS vs. RDBMS

2 Answers   TCS,

---

What is a OUTER JOIN?

1 Answers  

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

0 Answers   TCS,

---

How to build data dictionary view an new database?

0 Answers  

---

Where are the settings stored for each instance in oracle?

0 Answers  

---

What are the Characteristics of Data Files ?

3 Answers  

---

When do you get a .pll extension in oracle?

0 Answers  

---

Difference between an implicit & an explicit cursor.?

2 Answers  

---

What are the general rules on data consistency?

0 Answers  

---