I am a Oracle PL/SQL developer and use TOAD everyday at work.
I have a question regarding a TOAD feature which might or might not be there.
Does TOAD have any feature which may suggest Outer Join automatically while joining the two tables which do not have all the matching key values for join columns ?
so that developers can have good control over the result set rather than discovering later that some of the records are missing or there is a mismatch.
I think this should save some time and gives surety towards the expected result set prediction for developers.
Sometimes it becomes difficult debugging the possible reason of data not being returned from a query with multiple tables in spite of almost being sure that the query should return rows and later finding out that one of the tables do not have the matching values for the join columns and there is Inner join on that.