Re: Oracle SQLPlus 8.0 --Need Help
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Thu, 12 Aug 1999 11:11:35 GMT
Message-ID: <HZxs3.1521$9K.951_at_news.rdc1.nj.home.com>
Date: Thu, 12 Aug 1999 11:11:35 GMT
Message-ID: <HZxs3.1521$9K.951_at_news.rdc1.nj.home.com>
First, I would suggest that you buy a couple of books: Oracle, The Complete Reference (Oracle Press) PL/SQL Programming (Get both the Oracle Press and O'Reilly Books)
Answers to your questions are below:
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223Received on Thu Aug 12 1999 - 13:11:35 CEST
>1) Can you add a variable of type Number to a date variable, and then
>compare this to the sysdate, in order to find the out whether or not the
>the amount of days is greater that the sysdate????
>
>eg. 23-Oct-1999 + 2days, should equal 25-Oct-1999. Can this type of
>calculation be done??
yes, but be careful. Dates in Oracle are stored to the nearest second.
>
>2)Having trouble with the MAX function, in a SQL statement, is the correct
>systax as follows??
>
>SELECT MAX(value) AS "Maximum"
>FROM tablename;
No, the syntax is SELECT MAX(value) Maximum FROM tablename;
>
>Thanks to the person who help me out, Whoever you may be !!!!
>Daniel
>
>>>> SEND REPLY TO : danielh_at_satlink.com.au