Re: can anyone help me?

I didn't go through your SQL but you often see this error when cutting and pasting scripts from say, notepad to SQL*Plus. If no one comes up with an answer try making sure there is a space after the end of each line

Van

Joe D <joed_at_icoms.com> wrote in message news:380f5332_at_News.Destek.net...
> 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 - 18:38:33 CDT