HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
Answer Posted / santosh
A> %let orapath (user=testuser password=testpass
buffsize=100
path='myorapath');
proc sql;
connect to oracle (&orapath);
select * from connection to oracle
(select * from <Table name>);
Where dept =’Sales’;
Disconnect from oracle
Quit;
Run;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
What is the general format of function in sas? : sas-grid-administration
Give an example where SAS fails to convert character value to numeric value automatically?
Explain the difference between nodup and nodupkey options?
what are the benefits of data integration? : Sas-di
Difference between nodup and nodupkey options?
What are the automatic variables for macro? : sas-macro
Explain data_null_?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
what is sas application server? : Sas-di
Explain what is the use of proc gplot?
what is enterprise guide? What is the use of it? : Sas programming
What is the difference between reading data from an external file and reading data from an existing data set?
What is the use of the %include statement?