Hello everyone,
After I submited sql in SAS to created table in Oracle I want to check table status,I find the code below using dbms_stats.gather_table_stats:
proc sql; &connectToOracle; execute by oracle ( begin dbms_stats.gather_table_stats('user', 'mytable', degree => 15); end;);
In this code, where/what is the output table I can find the table's information?
Thanks!
1. I reckon this question would be best answered in an Oracle forum
2. My understanding is that the results of gather_table_stats are used by Oracle to optimise queries by using the information collected rather than for human consumption.
That doesn't look like the type of command that would actually return anything, but perhaps you can try using the TABLE() function to convert what it does return into something that looks like a table you can query?
select * from connection to oracle
(
select * from table( dbms_stats.gather_table_stats('user', 'mytable', degree => 15) )
);
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: