What does `(+)` do in a where clause?

Question Posted / bhanu bhandula

1 Answers
1464 Views
I also Faced
E-Mail Answers

What does `(+)` do in a where clause?..

Answer / kamala k n

+ will give matching rows from table

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers TCS,

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers MasterCard,

What is BBED in Oracle?

0 Answers MCN Solutions,

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers IBM,

what is shell?

2 Answers Microsoft,

How to synchronize 2 schema's objects?

0 Answers Virtusa,

Can objects of the same Schema reside in different tablespaces.?

3 Answers

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

How do you ensure database security?

1 Answers

Differentiate between function and procedure in oracle.

0 Answers

Can anyone give me information about oracle certification

1 Answers

How can we delete duplicate rows in a table?

0 Answers

For more Oracle General Interview Questions Click Here