I want to write a stored procedure in oracle 8 that will return the columns above to a DataReader object in vb.net that I will place in a DataTAble and then bind to a datagrid. Since oracle stores the date and time together, I would first have to determine all the unique Date values and all the unique time values that I have. Is there a sql statement that does this? Could I then store all the date values in a kind of date-array and the time values in a time-array to use in my logic below:
ForEach Date in (Select Date from Date-array order by Date ascending)
Select values from <Table_Above>
where Time is (Select Time from Time-array order by Time ascending)
How would I write this in oracle as I don't know oracle that well?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.