'other'
end as desc
from star.kills;
quit;
The same syntax does not work in SQL*Plus for Oracle 8. Can someone point
me to the correct syntax?
Secondly, any URLs for this kind of information would be most appreciated.
Regards,
Harry
--
Please see the official ORACL
Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 07, 2002 3:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL and case st
ith Oracle )?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
ore suited to a developer ( been in
the business for 20 years, but 2 weeks with Oracle )?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
And the answer to the question posed below is 'yes'.
peter
edinburgh
> -Original Message-
> From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]]
> Sent: 07 October 2002 23:59
n!!,
if an Oracle list exists that is developer oriented rather than DBA
oriented.
TIA for your answers.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
d.
TIA for your answers.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Droogendyk, Harry
Sent: Friday, January 23, 2004 12:40 PM
To: Multiple recipients of list ORACLE-L
Folks:
>From what I gather, Oracle stores dates as the number of elapsed days
since
Jan 1, 1968. When I query a column of type
select date_fld - to_date('01Jan1960','ddmon') as sas_date
Thanks for your time and help.
-Original Message-
Sent: January 23, 2004 3:32 PM
To: '[EMAIL PROTECTED]'
Cc: Droogendyk, Harry
Harry,
Look at the to_char function in Oracle. It will convert a date
se see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
can I do to get the raw internal value of the date? i.e. today is
13172.
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Droogendyk, Harry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
12 matches
Mail list logo