Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Oracle

Status
Not open for further replies.

SQLScholar

Programmer
Aug 21, 2002
2,127
GB
Hey all,

I have a query which worked through sql plus which i have adapted to put into SSIS.

I am getting an error though. the code is:

Code:
SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(fes_uins_instance_code || '-' || calocc_occurrence_code,'(',''),')',''),'&',''),'+',''),'/',''),' ','') as COURSE_ID,    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(fes_uins_instance_code || '-' || calocc_occurrence_code,'(',''),')',''),'&',''),'+',''),'/',''),' ','') as EXTERNAL_COURSE_KEY,
    REPLACE(unit_instances.fes_long_description,'|','')|| '-' || calocc_occurrence_code as COURSE_NAME,
    REPLACE(unit_instance_occurrences.long_description,'|','')|| '-' || calocc_occurrence_code as [DESCRIPTION],
to_char(unit_instance_occurrences.fes_end_date,'mm/dd/yyyy') as [END_DATE],
to_char(unit_instance_occurrences.fes_start_date,'mm/dd/yyyy') as [START_DATE]
FROM
    unit_instances@ebslive,
    unit_instance_occurrences@ebslive 
WHERE     
fes_unit_instance_code = fes_uins_instance_code and unit_instance_occurrences.fes_end_date >= (SYSDATE-30)

The error is FROM keyword not where expected.

If i remove the cols up to and including DESCRIPTION it works.

Any ideas

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------
 
sorry just relised i was being silly. Doesnt like the []
DOH!

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top