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 a trigger oracle?

0 Answers  

---

what is host string in sql plus? how does it related to database?

1 Answers  

---

What is use of oracle?

2 Answers   Satyam,

---

How many data types are supported?

0 Answers  

---

what is the syntax of DROP command?

10 Answers  

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,

---

How to retrieve values from data fields in record variables?

0 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

can a view be updated?

3 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

How to import one table back from a dump file?

0 Answers  

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---