Find all employees in Dept “Marketing”.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the minimum client footprint required to connect c# to an oracle database?

644


What suggestions do you have to reduce the network traffic?

631


Point out the difference between user tables and data dictionary?

623


What are the different types of synonyms?

678


How do we represent comments in oracle?

712






Explain oracle 12c new features for developers?

630


What is sharded cluster?

613


Whats the benefit of dbms_stats over analyze?

1586


How to use "for" statements in oracle?

675


Give the advantages and disadvantages of clusters.

663


How to connect to a remote server?

646


What language does oracle use?

713


Name the various constraints used in oracle?

665


How to delete a column in an existing table in oracle?

679


How to export your own schema?

661