Is anyone of you know SAS LANGUAGE

Is the

Proc sql innobs=1 ; is the statement who let the user request to get the only one rows from the Oracle SQL REQUEST or for the SAS DATA SET only one row

for instance table 1 has got 50000 rows

when we do

proc sql innobs=1 ;
proc sql;
select * from table 1 ;
quit ;

Does SAS make the entire CURSOR for 5000 rows and place the all rows in the SASWORK and take the only one row for the display of the result ??

Or Does SAS make place the one row in the SAS WORK ???

Thanks for the reply