Find all employees in Dept “Marketing”.

Answer Posted / anil

select * from table_name where dept='Marketing'

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an index in oracle?

609


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1705


Query to retrieve record for a many to many relationship ?

2081


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

546


How to define an oracle cursor variable?

569






1) Does oracle have any table which contain all the exceptions and it's code internally?

1282


List out the difference between commit, rollback, and savepoint?

622


How to use in conditions in oracle?

560


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1622


How does one get the view definition of fixed views/tables?

606


Does oracle database need java?

525


Who developed oracle & when?

574


What is key preserved table?

568


Explain an extent?

661


How to create lov dynamically at runtime & attach to text field?

665