Search results for query: *

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...

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...

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?

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...

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

Can you process a running total sum (of the maximum of group 1 ) for group 2 i.e voucher 123a 10000 123a 5000 max 10000 124b 30000 124b 50000 max 50000 we want a result of 60000

Hi: I have a report which is grouped by region, program, activity and project. Each project has multiple detail lines spanning multiple years. The cash flow budget amount is a fixed amount for a given year. I want to sum the total cash flow amount for the current year for each project over the...

Is there a way to set the default view to full page instead of 100% when viewing a report through VB?

How do I set a fixed length text column in excel. I want first name and last name to export as 30 characters each regardless if there are less charaters entered. Thanks

I am downloading information from an ibm mainframe session. Does anyone know how to read a flat file containing s9(7)v99 numbers? I've tried microsoft text driver (float)9 for the field definition but it does not pick up the numbers correctly. Any help would be appreciated. Thanks

I am trying to get records where an insurance expiry date has expired based on a parameter date or when insurance is required but no data has been entered in the insurance date field. ( {?date_expire} > {CONTRACT.CGL_INS} or {?date_expire} > {CONTRACT.AUTO_LIA_INS} or {?date_expire} >...