SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select * from tab1 tab2 (no commas between)??

649606Feb 3 2010 — edited Feb 3 2010

Hi Friends,

I have encountered a oracle report program from Oracle Apps, that looks like this

SELECT COL1,....more cols.... FROM TABLE1 TABLE2 where.....conditions....

The 2 tables are not separated by commas. I can not understand what logic does it try to bring out :(
I tried testing it with 2 tables but the output is nonsense.

Can you explain what is the purpose of this type of query pls.....

Thanks a lot

MsK

This post has been answered by 730428 on Feb 3 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2010

Added on Feb 3 2010

19 comments

4,709 views