Mac Forum / Applications / Mac Applications / August 2008

Hi, all,

I know how to connec to ODBC database (SQL server), the codes are as
follows:
/*************************************************/
proc sql;
connect to odbc (password=*** userid=*** dsn=);
select * from connection to odbc (select * from XXX); /**XXX is a
table name in SQL server, usually, it will be like the
dbo.tablename;**/
quit;
/***********************************************/

But now I have to retrieve data from Oracle database.
I tried to use the following codes:
/**********************************************/
proc sql;
connect to oracle (password=*** userid=*** path='PPPPP');
select * from connection to odbc (select * from YYY);
quit;
/**********************************************/
Here I have three questions:
1. Are the above codes good enough for a simple query?
2. What should be the path? How I can find out the path?
3. what's the convention for the Oracle table name YYY?

Thanks a lot.
Lucy