I am importing data from MySQL ver 5 to Oracle. I would like to use a script to filter the data that is imported. I have written a SELECT script that includes a variable to emulate ROWNUMBER that returns what I want when run from editor. When I apply the script in the Import Wizard it imports the entire MySql table, not just the filtered data. It appears that the script is ignored except for the FROM clause.
SELECT t.* FROM
(SELECT
@row_number:=CASE
WHEN @site_no = SITE
THEN @row_number + 1
ELSE 1
END AS num,
@site_no:=SITE SITE,
AGE,
STATUS,
MARKET
FROM my_table
ORDER BY SITE ASC, AGE DESC) t
WHERE num = 1;
Toad Data Point 5.1.6.206 (64 bit)