Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can anyone help me?
Hi, Joe.
The only thing that jumps out at me is there is no TRANSACTION_DATE field in the view.
HTH... On Thu, 21 Oct 1999 13:55:36 -0400, "Joe D" <joed_at_icoms.com> wrote:
>can you find the syntax error here? I can't but sqlplus tells me that:
>--------------------------------------------------------------------------
>CREATE VIEW REPORT_TRANSACTION_VIEW AS
>*
>ORA-00933: SQL command not properly ended
>
>--------------------------------------------------------
>here is the query that I ran. I did not write it. someone else did but I
>still can't find the syntax error. Hopefully a fresh pair of eyes will help.
>
>select * from REPORT_TRANSACTION_VIEW
>where TRANSACTION_DATE >= :lStarttime and TRANSACTION_DATE <= :lEndtime
>and STORE_ID =
>(select store_id from STORE SS where SS.KEY_STORE_SEQID =
>(select V.KEY_STORE_SEQID from REPORT_STORES_VIEW V where NAME =
>:szMerchant))
>
>
>CREATE VIEW REPORT_TRANSACTION_VIEW AS
> select I.INVOICE_NUMBER, T.CURRENCY_CODE, T.SALES_AMOUNT, T.ORDER_NUMBER,
> I.INVOICE_DATE, T.ORDER_DATE, I.SALES_AMOUNT, I.TRANSPORT_COST,
>I.INVOICE_TYPE,
> T.STORE_ID
>from INVOICE I, TXORDER T
>where T.TXORDER_ID = I.TXORDER_ID;
>
>
>
>TIA,
>Joe
>
>
>
Received on Thu Oct 21 1999 - 12:59:45 CDT