mzladyd
Last Activity: Feb 11 '08, 09:42 PM
Joined: Jun 8 '07
Location:
-
Numbers and Nulls
I am loading data to an Oracle table with Informatica. There are six fields set to number format. The data includes nulls that shows in the table as zeros. How do I make the zeros show as blanks in the Oracle table? -
Convert LONG format to DATE or CHAR
The source table has tbldate formated as long and I want it to be date.
I've created another table and set the correct format and have tried to convert to date or char, but I continue to get error messages when I execute my Insert SQL.
TO_DATE(TBLDATE ) gives me this message.
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
TO_CHAR(TBLDATE ) gives me this
ORA-00932: inconsistent... -
My apology, I didn't fully explain what I am trying to do.
I have a set of data of employee numbers, events, and close_dates. The data includes several months of data. I only want to extract the most recent 3 dates for each employee. such as
1001 event1 06/25/2007
1001 event2 05/31/2006
1001 event3 04/02/2006
2002 event1 06/18/2006
2002 event2 06/11/2005
2002 event3 03/02/2005
... -
Extract the 3 most recent dates
I'm trying to create a view by selecting the 3 most recent dates from a table of dates. Is it possible to do this with max case? Sample code is very much appreciated.
Thanks! -
Converting rows to clumns (max case)
This forum has been so helpful to me. Mr Moderator, I know I should at least attempt this myself before asking for help, but I don't know where to begin. My max case 'sql' works fine, but I my 'when' statement needs to be dynamic. I am extracting a set of data from Teradata (current year and 2 previous years) and loading it into an Oracle table. The data is in 3 columns so I max case to pivot the table to:
EMPNO YEAR1 RATING1 YEAR2...
No activity results to display
Leave a comment: