I have a question about something that is driving me nuts
What I want to do is create a procedure or whatever you want to call
it to return me a result set of a select statement that has one
parameter, a date, that will do a join on 2 tables and filter it by
the date i specify.
I would like to use the resultset from this select statement in 3rd
party apps, such as Microsoft Access or Crystal Reports, so i don't
want to simply cut and paste the Select statement into these apps
using their query builders, I want some sort of procedure that will
take the date parameter and spit me out my resultset.
Is this possible in Oracle, version 8.1.5
I've thought of using a View, but i don't think i can create a view
inside a procedure from what i've read.