Getting all tables from Oracle

[STOJA]

What is the best way to see all my tables in Oracle data base as a sas data sets?

Thanks

[Cynthia_sas]

Hi:
This is not a BASE SAS or Reporting Procedure (PRINT, REPORT, TABULATE) question.

Your best bet for help with this question is to contact SAS Tech Support. To contact Tech Support go to: http://support.sas.com and on the left-hand navigation area, look for the link entitled "Submit a Problem".

cynthia

[david2010]

The best way is to use the ORACLE libname statement.

libname oracle_db ORACLE USER='ASB" PASSWORD='123";
RUN;

All the tables should now be accessible.

This will give you the name of all the tables.

proc datasets library=oracle_db;quit;