SQL and case structure

'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

RE: SQL and case structure

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

RE: ORA-472 DBWR terminated

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

Oracle list more suited to a developer?

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,

RE: SQL and case structure

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

Oracle list for developers ??

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,

Thanks - Oracle list for developers ??

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

RE: internal date value

. 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

RE: internal date value

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

RE: internal date value

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 ---

internal date value

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

internal date format

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 -