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

How do we display rows from the table without duplicates?

542


How to create a server parameter file?

571


What is enter substitution variable in oracle?

570


What are the different types of synonyms?

590


What is an oracle and why it is used?

619






For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1554


What is the difference between sharding and replication?

475


How would you best determine why your MVIEW couldnt FAST REFRESH?

1432


What is a schema in oracle?

536


Please explain compound trigger in oracle?

594


How to use existing values in update statements using oracle?

545


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1801


Explain a segment?

613


How to rollback the current transaction in oracle?

536


How to convert raw data type into text in oracle? Explain

599