Thanks all. The WHERE AND ToPS was a typo on my part, I have a huge stored procs, so i was cutting out just the parts that I needed help with so you did not have to strain to understand it all.
In any cause the (+)= on the other conditions did the trick. I am new to Oracle, and have been...
Ok. I am in the painstaking process of converting a bunch of reports with stored procs written in TSQL (MSSqlserver)
to PL/SQL.
I am having issues with one of my joins and getting it to work right in PL/SQL
IN TSQL its looks something like this:
SELECT
*
FROM ParticipantSegment PS
LEFT...
I work for a call center and need to create a report, that groups records by a time increment parameter entered at run-time. If run the report for the time frame of 8:00 AM to 10:00 AM with a time increment of 30 minutes, I need to tie my result set (which is coming from a stored procedure) to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.