Recent content by mdl2

I am getting ORA-01417: a table may be outer joined to at most one other table AND CA.CASE_ID = CEYS.CASE_ID (+) AND RPT.HRE_REPORTS_ID = CEYS.HRE_REPORTS_ID (+) AND CA.CASE_ID = ICS.CASE_ID (+) AND RPT.HRE_REPORTS_ID = ICS.HRE_REPORTS_ID (+) What I am...

I am getting ORA-01417: a table may be outer joined to at most one other table AND CA.CASE_ID = CEYS.CASE_ID (+) AND RPT.HRE_REPORTS_ID = CEYS.HRE_REPORTS_ID (+) AND CA.CASE_ID = ICS.CASE_ID (+) AND RPT.HRE_REPORTS_ID = ICS.HRE_REPORTS_ID (+) What I am...

Do you have a subreport that uses the parameter theat you haven't linked?

I am just wondering if anyone knows if there is a performance difference between the extract and to_char functions to get the month or year from a date variable or is there another function to simply parse the month. I am trying to calculate the fiscal year based on a march 31 year end. This is...

Select all of the text boxes and Align left This should line up your boxes in a column

Not sure if this is what you mean: You need to use the align not size option. Select them all then right click align bottoms, middle etc.

Oracle 9i Should your most restrictive clause be the last clause in your where statement or does it matter? I thought oracle processed from the last clause back but my colleague thinks the most restrictive should be the first. I have searched google but have not found an answer. Any Thoughts?

why not suppress those results where{TBL_Team_Departments.Reports_to}="Joe Zaczyk"

i'M NOT SURE AS i USE oRACLE DATABASES BUT i WOULD ASSUME IT IS THE SAME FOR EXCEL Under The database option select set location and enter the location of your network drive

This is part of a 5 part union where I am trying to count the number of unique people and the amount of money spent in 3 program areas. If a person is in program a, I want them counted in program A but not counted in B or C. If they are in B and not A then I want them counted in b and if they...

Thanks a lot -- it worked Just in case someone else wants to run it -- I had problems in toad 9.1 creating the function with shift f9 -- for some unknown reason it gave me a sql error but when I pressed the execute statement button it worked Thanks again !!!!!

Hi I want to know how to find all view in our system that have the function to_char I tried select owner,view_name,text from all_views where text like '%to_char%' got inconsistent datatypes text is defined as long does anyone know of a way for me to get this info Thanks

SELECT ROWNUM, ('TO_CHAR(' || COLUMN_NAME || ') AS FIELD' || ROWNUM) AS COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME LIKE V_TABLE ORDER BY ROWNUM The previous statement is not consistant across databases (production versus test -- field1 on test may be field 5 on production) I was...

I need to create a flat file of case information in fixed columns from an oracle database. There will be one output record per case. I may have to output up to 5 dependents on 1 record for a case -- Simplified version Table 1 table 2 case name...

I am writing a procedure that reads in a flat file where the numbers are defined as s9(9). Is there a format that can read an overpunch numeric. Thanks MDL