Because the CONNECT statement is omitted, an implicit connection, that uses the default database, is made to Oracle Rdb. proc sql; execute (grant update, insert on orders to [qa,testuser]) by rdb; ...

Breaking the computational tasks of running a database management system from the SQL processing against data stored in ... a testament to how these machines are built specifically to run Oracle ...

proc sql; connect to oracle (user=testuser pass=testpass); create view myview as select * from connection to oracle (select "Amount Budgeted$", "Amount Spent$" from mytable); quit; proc contents ...