03-03-2016 12:46 AM - edited 03-03-2016 01:06 AM
I have an Oracle DB with some views and tables. I need to get the code for generating table T1. T1 is there in "all_tables" and "all_objects", but not in "all_views".
How do I get the code for T1? I need to see how different tables have been merged, combined etc. to get T1.
03-03-2016 01:01 AM
03-03-2016 01:10 AM
The input data is in Oracle, however all further processing is done in SAS. I'm trying to take a look at the Oracle query (for table T1) from SAS.
Unfortunately, I'm not an Oracle expert too
03-03-2016 02:22 AM