Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2283


What is the general format of function in sas? : sas-grid-administration

917


Give an example where SAS fails to convert character value to numeric value automatically?

1026


Explain the difference between nodup and nodupkey options?

962


what are the benefits of data integration? : Sas-di

1022


Difference between nodup and nodupkey options?

1110


What are the automatic variables for macro? : sas-macro

1140


Explain data_null_?

1002


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

960


Are you involved in writing the inferential analysis plan? Tables specifications?

3898


what is sas application server? : Sas-di

997


Explain what is the use of proc gplot?

1123


what is enterprise guide? What is the use of it? : Sas programming

948


What is the difference between reading data from an external file and reading data from an existing data set?

1122


What is the use of the %include statement?

1084