Recent content by Gator25

Thanks.

OK, copied it over to a new file and got this error... ERROR at line 9: ORA-00904: "GL"."DEBIT_AMOUNT": invalid identifier This deals with the DECODE

dagon, Could you illustrate what you mean. Thanks

Dagon, Added your suggestion(s) and now get this error Line 12 AT"."ENTRY_USER": invalid identifier ?

Yes, I was attempting my first try with an inline view. Thanks for the quick response. Will apply your suggestions and let you know.

The following script tells me invalid table name. I'm confused as this is defined. I'm trying to count all the claims and money by biller and show a total for everything. Here is the code. ------CLRK_DAILY8 set verify off set linesize 80 set pagesize 60 INPUT ACCEPT EDATE ENTRY_DATE PROMPT...

LKBrwnDBA, Your replies to the ansi thread have been deleted. I know no other way to correspond. Could you tell me how ? Thanks

Dagon, We have a working script. I addded your change to the B.Bill_Date and B.Enc_Date and I changed the last 4 lines to read........... HAVING SUM ( DECODE(substr( TRANS_CD,1,1)'U',G.Credit_Amount, 0)) !=0) G Where B.Bill_Date Between Trunc(Sysdate) -232 And Trunc(Sysdate) -120 And G.Cntrl_No...

I get this error "G"."ENC_DATE": invalid identifier

I had tried the above changes but I also had gone to the B alias and added the B.Bill_Date and B.Enc_Date. I thought they had to be part of the first select. Where G.Enc_Date Between Trunc(Sysdate) -210 And Trunc(Sysdate) -120 Should not the G become a B since the ENC_Date is part of the...

The one you submitted on 19 Aug 2008 @9:01 I need to replace those G statements for the Bill_Date and Trans_Date and the G.Entry_Date. The Bill_Date becomes B.Bill_Date and the Trans_Date becomes B.ENC_Date and also Entry_Date becomes B.ENC_Date I made a mistake in the original using the...

SqlPlus 10.0 Oracle 10g

Dagon, Last glitch. I need to exchange two fields. G.Bill_Date,---> becomes b.bill_Date, G.Trans_Date,---> becomes b.Enc_Date, and then the final change is Where G.Entry_Date Between Trunc(Sysdate) -210 And Trunc(Sysdate) -120 G.Entry_Date becomes B.Enc_date When I do these changes then I get...

Thanks

Ok, so how would that be applied to your answer on the 19th Here is what you said on the 19th.................. At the moment I'm probably suggesting something along the lines of: CODE Select To_Char (Sysdate, 'Mm/Dd/Yy Hh24mi') Todays_Date, B.Ins_Co_Name, B.Ins_Co_Address2...