nice hint! I must say.... :D BR Sonty
On Jun 26, 6:08 am, Rob Wolfe <wolfe....@gmail.com> wrote: > Not going to give the actual answer to this but I will say that the > quick and dirty way i would do it involves the use of "union all". > That should be enough of a hint if you have access to the > documentation. > > if you do not have it handy, it is all available online > athttp://tahiti.oracle.com > > Come back if you need more of a hint but I think that you should be > able to get it. > > On Jun 25, 9:00 pm, shaunak <shaunak.adgaon...@gmail.com> wrote: > > > > > Guys this is a very basic question but i am not able to find the > > solution. Hope somebody comes up with solution for me. > > > My requirement is to add the counts of two tables. > > > select count(*) from table1 ; it returns 20 > > select count(*) from table2; it returns 30 > > > Now i want to have result in single query as 50 > > > Can this be done in single query ? how ? can somebody help me > > > Thanks- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
