select * from table_name where dept='Marketing'

Find all employees in Dept “Marketing”.

Question Posted / anil

Answer Posted / anil

Is This Answer Correct ?

10 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to delete an existing row from a table in oracle?

1049

Explain the blob datatype?

1057

How to load data through external tables?

1117

What is ADDM Advisor in Oracle?

1154

What is truncate oracle?

957

What is control file used for?

1174

Explain the features of oracle?

1020

What is a cognitive schema?

943

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4542

How to check the oracle tns settings?

1025

is there a tool to trace queries, like profiler for sql server?

1128

Why does oracle 9i treat an empty string as null?

1031

What is a data dictionary and how can it be created?

1114

How to set a transaction to be read only in oracle?

1074

How can you use check constraints for self referential integrity?

947