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

Can we use bind variables in oracle stored procedure?

899

What is a dynamic performance view in oracle?

949

How do I uninstall oracle 11g?

1044

how to handle exceptions in post production

1362

Is rowid unique in oracle?

939

How do I find my oracle client driver version?

973

How to assign data of the deleted row to variables?

1015

How to create an oracle testing table?

1010

What is the quickest way to fetch the data from a table?

1001

How to start your 10g xe server from command line?

1001

master table and child table performances and comparisons in Oracle ?

2071

What are internal user account in oracle?

950

Explain the use of analyse option in exp command.

1067

does the query needs a hint to access a materialized view?

1817

How to define a variable of a specific record type?

1022