select ename from emp where deptname = 'Marketing' ename = emp

Find all employees in Dept “Marketing”.

Question Posted / guneetinder singh

Answer Posted / guneetinder singh

select ename from emp where deptname = 'Marketing'

ename = employee name.
deptname= department name

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of rows option in imp command.

1070

How to convert characters to times in oracle?

1003

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1015

How can windows applications connect to oracle servers?

1034

What is the data pump export utility?

1060

What is connection pool in oracle?

970

How to define a sub function?

1107

What is materialized view in Oracle?

1059

What is a static data dictionary in oracle?

1080

How to create a new table in oracle?

1132

How to pass a parameter to a cursor in oracle?

1154

How to rename an index?

1047

What is a system tablespace and when it is created?

956

What is a private synonym?

1559

What is tns entry?

1110