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


Please Help Members By Posting Answers For Below Questions

What are the difference between ceil and floor functions in sas?

954


explain what is factor analysis? : Sas-administrator

742


Have you ever used the SAS Debugger?

1393


what is the use of proc contents and proc print in sas? : Sas-administrator

770


What makes sas stand out to be the best over other data analytics tools?

741






How many data types are there in SAS?

766


what is sas application server? : Sas-di

660


What can be the size of largest dataset in SAS?

885


what is the difference between infile and input? : Sas-administrator

788


What does P-value signify about the statistical data?

1028


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1960


What is SAS?

756


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

748


What function CATX syntax does?

825


how do you test for missing values? : Sas programming

720