First, you specify a PROC SQL CONNECT statement to connect to a particular ORACLE database that resides on a remote server. You refer to the database with the alias MYDB. Then you list the columns ...

Database identification statements and column names are ... This value is inserted in the query, as if the query were written: select empid, lastname, firstnam from vlib.allemp where dept like &dept ...