HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
- 3 Answers
- 9366 Views
- Accenture, Novartis, I also Faced
- E-Mail Answers
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 are the parameters of scan function?
How would you include common or reuse to be processed along with your statements?
What is proc sort?
what are validation tools that are used in sas? : Sas-administrator
What is a put statement?
What are all the problems you faced while validating tables and reports?
Explain how merging helps to combine data sets.
How do you test for missing values?
How many ways to overcome a missing values???
Have you ever used the SAS Debugger?
Explain the special input delimiters used in sas programming.
How we can call macros with in data step? : sas-macro
what is sas and what are the functions? : Sas-administrator
How you can read the variables that you need?
explain the key concept of sas? : Sas-administrator
