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!

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

Recent content by Gator25

  1. Gator25

    SQL Plus 10.0

    Thanks.
  2. Gator25

    SQL Plus 10.0

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

    SQL Plus 10.0

    dagon, Could you illustrate what you mean. Thanks
  4. Gator25

    SQL Plus 10.0

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

    SQL Plus 10.0

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

    SQL Plus 10.0

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

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

    SqlPlus 10.0 Oracle 10g
  13. Gator25

    DECODE in SQL Plus version 10

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

    DECODE in SQL Plus version 10

    Thanks
  15. Gator25

    DECODE in SQL Plus version 10

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

Part and Inventory Search

Back
Top