>Then now, I am just a little more confused.

Oracle forms is a primitive tool. It's simple and easy. And Oracle PL-SQL better from Microsoft's. You don't have to learn complex inner outer join commands. Just do it:

select a.name,b.salary from personal a,salaries b where (+) a.code=b.code

You see. You just use (+) instead of inner/outer join keywords. It's more clear and easy. Oracle has a lot of better keywords from MS-SQL. But I have to accept that you cannot find an equivalent of MS-SQL's bookonline. Bookonline is excellent...