VERY VERY COMPLEX QUERY [message #315749] |
Tue, 22 April 2008 10:53  |
DRASTANT
Messages: 21 Registered: July 2007 Location: KENYA
|
Junior Member |
|
|
HI ALL I HAVE AN EXCEL SHEET WITH FOLLOWING COLUMNS
ITEM, QTY SOLD, DATE,STORE
I WANT A QUERY TO EXTRACT FOR ME SOMETHING LIKE THIS
ITEM, QTY IN OCTOBERM, QTY IN NOVEMBER
I WANT TO ADD THE QTY STORE WISE FIRST AND THEN TO DISPLAY AS STATED ABOVE IT IS BEYOND MY SCOPE
PLEASE HELP
|
|
|
|
|
Re: VERY VERY COMPLEX QUERY [message #316120 is a reply to message #316039] |
Wed, 23 April 2008 16:30  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
There's, actually, nothing "very, very complex" in this assignment.
Save Excel file as a CSV file and use it as an external table (or load into Oracle database using SQL*Loader). Once data is in an Oracle table, query is really a simple one; for example
-- quantity in November
SELECT quantitry
FROM this_table
WHERE to_char(month_column, 'mm') = '11';
|
|
|