I need to take a Varchar2 and a date from MyTable and place it into a two dimensional array in Oracle.
I know I can simulate this somehow with two associative arrays, but I dont know how I would
set it up or Insert from a table into it.
Also, once it is set up can I use it with an select * from myTable where mychar IN(Array) statement?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE