Interested to Buy Any Domain ? << Click Here >> for more details...
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES?
WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
- 3 Answers
- 10015 Views
- Accenture, Novartis, I also Faced
- E-Mail Answers
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
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
how to generate the test data in sas without input data? : Sas-administrator
How do you use the do loop if you don’t know how many times you should execute the do loop?
Explain why double trailing @@ is used in input statement?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What does PROC print, and PROC contents do?
what is sas metadata repository? : Sas-bi
name several ways to achieve efficiency in your program? : Sas programming
What does proc print, and proc contents are used for?
What are pdv and it functions?
How do you add a number to a macro variable? : sas-macro
What does P-value signify about the statistical data?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
why is sas considered self-documenting? : Sas programming
Did you used proc test? when?
