HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
Answer Posted / chaitanya
Two ways that I know to retrieve data from oracle tables are
1. Libname Facility:
Example:
libname mydblib oracle user=testuser password=testpass path=hrdept_002;
proc print data=mydblib.employees;
where dept='CSR010';
run;
2. Passthrough Facility:
Example :
proc sql;
connect to oracle as dbcon
(user=testuser password=testpass buffsize=100
path='myorapath');
select *
from connection to dbcon
(select * from customers
where customer like '1%');
disconnect from oracle;
quit;
b. Oracle Clinical:
Oracle Clinical (OC) is the software package that is widely used in the pharmaceutical environment as a data entry
and storage tool. It captures the data entered from CRF (Case Report Form) and stores the data in its database
system.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the difference between ceil and floor functions in sas?
explain what is factor analysis? : Sas-administrator
Have you ever used the SAS Debugger?
what is the use of proc contents and proc print in sas? : Sas-administrator
What makes sas stand out to be the best over other data analytics tools?
How many data types are there in SAS?
what is sas application server? : Sas-di
What can be the size of largest dataset in SAS?
what is the difference between infile and input? : Sas-administrator
What does P-value signify about the statistical data?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What is SAS?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
What function CATX syntax does?
how do you test for missing values? : Sas programming