So I have a query that selects records based on few conditions aswell as date condition..
In my .net project I write a long select statement ( like 40 lines or so ).
So I've been asked to create a view of it and just in my code : select * from view..
Once I create a view with my query it will always have the same dates which makes it be a same result over and over.
Been exploring a little and I know theres that SYS_REFCURSOR aswell as materialized view and table function... but man... Im barely pulling simple queries;/
Im really confused on how I can achieve that. ( my oracle/sql knowledge isnt good to say the least, sorry about that)
Trying aswell to understand which of the approaches u'd choose, why, and which are simpler for beginners
Have a nice day