Hi All,
I have been tasked to move all the legacy code to PLSQL packages.
Question: Is it possible to move the table creation scripts to a package procedure and is it best practice.
I see that the legacy code logic drops and recreates this table before applying some processing logic and inserts data into these tables.
I am not concerned about best practices in regards to usage of temporary tables and want to just replicate the legacy logic as is due to project time constraints.
Thanks