You are here:

Computer Certification

Recent Answers

2016-09-22 SAS - Do Loop:

Hi Carol,    I am sorry for the delay in replying. From your question it is not clear what is exactly you are trying to achieve...can you please elaborate.    What are these "2016-09-01" , "2016-10-01"

2016-08-01 Oracle - diff between instance,schema,database:

Hi Santhosh,    In Oracle (since inception), a schema is a collection of objects managed under a user account.    In a default Oracle installation, you can choose to install the sample user SCOTT which

2016-07-28 Oracle - Invalid Number Error:

Hi Kevin,    When you run the select statement,    SELECT TO_NUMBER(BB.mileage) Mileage1   FROM BB;    do you still get an error?     In your CREATE TABLE statement, are you trying to reproduce table BB

2016-07-26 Oracle - union and intersect:

Hi Santhosreddy,    In SQL (in this case ORACLE SQL) the UNION operator is used to combine the result sets of 2 or more Oracle SELECT statements. It removes duplicate rows between the various SELECT statements

2016-07-21 SAS - SAS (convert date to a number):

Dear Carol,    I am sorry, could not reply earlier than today. I think you are looking for something like this    %let today = %sysfunc( TODAY());  %let Mymonth = %sysfunc(month(&today));    %put mymonth

Categories

Browse Alphabetically

©2016 About.com. All rights reserved.