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

Why does for update in oracle 8 cause an ora-01002 error?

1050

How to drop an index in oracle?

1120

Explain index?

1314

How can Oracle users be audited?

1172

what are actual and formal parameters?

1159

How to connect to oracle using service name instead of sid?

1072

How do I recompile a procedure in oracle?

1018

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2344

What are the attributes of cursor?

1104

Explain the difference between sql and oracle?

1127

What is the difference between a primary key & a unique key?

1141

How do I start tns listener?

1099

Differentiate between function and procedure in oracle.

1154

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

1932

How to create a table index?

1230