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

Answer Posted / kamala k n

+ will give matching rows from table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1676


Why do we use coalesce function in oracle?

633


How to create a stored procedure in oracle?

577


Explain what are the characteristics of data files?

631


What is oracle data type?

555






What is a view and how is it different from a table?

574


What is meant by raw datatype?

573


How do we get field detail of a table?

628


How to update values on multiple rows in oracle?

602


What is the max number of columns in an oracle table?

517


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2067


In oracle there is column command, how will you explain that?

554


Explain the use of record option in exp command.

539


what is the difference between restoring and recovering?

558


How to work with data objects interactively?

558