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

how to generate the test data in sas without input data? : Sas-administrator

687


Tell e how how dealt with..

1859


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1461


what is the purpose of _error_? : Sas programming

712


How do dates work in SAS data?

779






Give some ways by which you can define the variables to produce the summary report (using proc report)?

702


Describe a time when you were really stuck on a problem and how you solved it?

2287


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

884


what does the run statement do? : Sas programming

651


describe the interaction table in sas di? : Sas-di

692


What is the length assigned to the target variable by the scan function?

772


What do the put and input function do?

680


What are the differences between sum function and using “+” operator?

683


how are numeric and character missing values represented internally? : Sas programming

725


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

809