Recent content by rboscia

I am using Oracle I did try using UNION which gives me the results I need, but then I'm not sure how to get each one of the queries grouped , so my output shows Tickets Open 5-30 days xx xxx xxxx xxx Tickets Open 31-60 days xx xxx xxxx xxx etc., I DO NOT know scripting, so...

I am trying to query a table and find tickets that are open between 5 -30 days, 31-60 days & 61-90 days. I want all 3 queries in one report and I would like them totaled at the bottom. My query so far is select tabletwo.ticket "Ticket ", tabletwo.datecreated "Date &quot...

I am VERY new at Oracle and have not yet been at any classes except SQL/SQL Plus & PL/SQL so please bear with me. ( I did not build the database or tables and unfortunately no one that still works here did, so all the documentation is not there.) I am looking for a field in a table. Is there...

I no longer need this information. No need to reply to this post. Thanks

Randy, That was SO easy! Thanks so much for your help

the post from sanjay works, however now i have one more question... the users also want to be able to enter a date range to get their duplicates that occurred between that date range. i add this to the where clause and a.date >= :P_firstdate and a.date <= :P_enddate and this is what the output...

Yes, the post from sanjay mamgain worked! Thanks so much Robin

I am a newbie that needs help. (I also posted this to the Oracle Reports, hoping I would get an answer somewhere) I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates (and only...

I am a newbie that needs help. I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates (and only the duplicates) of those telephone numbers by ticket #. My output should look like...

I am a newbie and I see several posts for dups but none that seem to work for my tables. I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates of those telephone numbers by ticket...