Thread: Write text file with utl_file and file must meet certain rules

what meaning for CG$? Case-Generator. If I recall well: 'C'omputer 'A'ided 'S'ystem 'E'ngineering -> Designer 'G'enerates it. It's a 'Designer-ism'. And I still think you're using Headstart as well...but I might be wrong.

Hi, Thanks for posting the CREATE TABLE and INSERT statements; that's very helpful. Don't forget to post the results you want from that data. Sorry, it's not at all clear from your description. To find the latest shipmentdate in the current month or any of the 10 previous months: MAX ( CASE WHEN shipmentdate >= TRUNC ( ADD_MONTHS (SYSDATE, -10) , 'MONTH' ) AND shipmentdate < TRUNC ( ADD_MONTHS (SYSDATE,...

Change this way: and QUOTD_QUOTH_no(+) = 7 Max

user8865857 wrote: I want just one on the top corner . how Can I do this ? Top left or top right? Please post desired output. From where you know polish word? Ja nie rozmawia ale rozumiem. SY.

"Trying to understand what you want to achieve with this query...." Explain what you're doing.... Post sample data... Explain what the difficulty is... ... or maybe start yet another thread with the same, obscure question...

Deleted.... Cheers!!! Bhushan Edited by: Buga on Dec 3, 2009 3:44 PM

I recommend reading the links below and gathering the data while it's "slow" and when it's "fast" and posting it here. When your query takes too long ... HOW TO: Post a SQL statement tuning request - template posting

Read the oracle document. But dont forget to remember that its a very sharp knife. Use it carefully. Read the link provided above.

1) Your NEXT definition is incorrect. If you want the refresh to happen every day at 1:00 PM, you'd want TRUNC(sysdate+1) + 13/24. SYSDATE + 13/24 is 13 hours later, so you'd have refreshes at 1 PM, 2 AM, 3 PM, 4 AM, etc. 2) When you query DBA_JOBS for this job, what do you see for NEXT_DATE, NEXT_SEC, LAST_DATE, LAST_SEC, FAILURES, and BROKEN? Justin

Hi Alex, Maybe select trunc(36/12)/2 from dual Full example: SQL> with your_data as (select 10 x from dual union all select 12 x from dual union all select 24 x from dual union all select 25 x from dual union all select 34 x from dual union all select 36 x from dual union all select 37 x from dual union all select 72 x from dual union all select 70 x from dual) -- end of test data select x, trunc(x/12)/2 number_of_days from your_data...