Funny oracle character... 2005-01-20 - By Ruth Gramolini
Good morning all,
One of my developers asked me to find out what the strange symbol I have put
in bold in this line is:days_in_2000 := begin_2001 ? begin_2000;
He had seen it several times in the documentation. I can't reproduce it to
do a search.
Anyone know about this?
Thanks in advance,
Ruth
-- --Original Message-- --
From: Stephen Peterson [mailto:speterson@(protected)]
Sent: Wednesday, January 19, 2005 4:14 PM
To: Ruth Gramolini
Subject: Funny oracle character...
http://www.oracle.com/technology/oramag/oracle/02-nov/o62sql_online.html
Using Intervals
Intervals can be used for many things, but in this article I'm going to
focus on datetime arithmetic. If you think about it, intervals are really
nothing new. Consider the following code, which computes the difference
between two dates in order to come up with the number of days in the year
2000:
DECLARE
begin_2000 DATE := TO_DATE('1-Jan-2000','dd-Mon-yyyy');
begin_2001 DATE := TO_DATE('1-Jan-2001','dd-Mon-yyyy');
days_in_2000 NUMBER;
BEGIN
days_in_2000 := begin_2001 ? begin_2000;
END;
/
Stephen C. Peterson
System Developer II
Vermont Department of Taxes
109 State St
Montpelier VT, 05602
W: 802-828-3747
E: speterson@(protected)
--
http://www.freelists.org/webpage/oracle-l
|
|
