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 the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1082


which features do you use to check the data validations and errors? : Sas-administrator

1049


how to change the execute of macro

2305


Describe the function and utility of the most difficult SAS macro that you have written?

2556


How would you identify a macro variable?

1085


what is intially documentation in sas?

5037


What is the maximum length of the macro variable? : sas-macro

1087


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2071


Give e an example of..

2094


how can you create zero observation dataset? : Sas programming

1141


What does PROC print, and PROC contents do?

1226


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1166


Explain what is the use of proc gplot?

1191


What are the ways in which macro variables can be created in sas programming?

1099


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

1098