Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 20th, 2003, 10:06 PM
Registered User
 
Join Date: Oct 2003
Location: Singapore, Singapore, Singapore.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Oracle 8i inner join and left join problem

i receive this error when i try to execute my query:
ORA-00933: SQL command not properly ended
Can someone help me... I'm using Oracle 8i. I know that Oracle 8i does not support inner join so how can i modify my query so that it can be use in Oracle 8i.
Below is my query:
SELECT TOPS.VESSEL_CALL.VSL_NM, TOPS.VESSEL_CALL.IN_VOY_NBR, TOPS.VESSEL_CALL.VSL_BERTH_DTTM, TOPS.CNTR.CNTR_NBR, TOPS.CNTR.DISC_SLOT_OPR_CD, TOPS.CNTR.CNTR_OPR_CD, TOPS.CNTR.PURP_CD, TOPS.CNTR.ISO_SIZE_TYPE_CD, TOPS.CNTR.SIZE_FT, TOPS.CNTR.STATUS, TOPS.CNTR.SPECIAL_DETAILS, TOPS.CNTR.PLOAD, TOPS.CNTR.PDISC1, TOPS.CNTR.PDEST, TOPS.CNTR.DECLR_WT, TOPS.NOMINATED_VSL.VSL_NM, TOPS.NOMINATED_VSL.OUT_VOY_NBR, TOPS.NOMINATED_VSL.ETB_DTTM, TOPS.VESSEL_CALL.VSL_ETD_DTTM, TOPS.CNTR.CREATE_DTTM, TOPS.CNTR.CREATE_ORG_CD
FROM TOPS.CNTR INNER JOIN TOPS.VESSEL_CALL ON TOPS.CNTR.DISC_VV_CD = TOPS.VESSEL_CALL.VV_CD LEFT JOIN TOPS.NOMINATED_VSL ON TOPS.CNTR.NOM_LOAD_VV_CD = TOPS.NOMINATED_VSL.NOM_VV_CD;

Thanks in advance.

  #2 (permalink)  
Old October 27th, 2003, 09:48 PM
Authorized User
 
Join Date: Aug 2003
Location: , , Malaysia.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm not sure this one can help you or not but try to use
field_name1 (+) = field_name2 or
field_name1 = field_name2(+)
or maybe you can use this statement below

select a,b,c
from xyz
minus/union/intersact
select t,y,u
from abc

  #3 (permalink)  
Old August 19th, 2004, 07:14 AM
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sandeepshivathaya
Default



Hi,



I am Sandeep working in Iflexsolutions

When searching internet to get the solution for the error ORA-00933 I found you are also faced this error.

I have got a problem.

I am using ORACLE at backend and VB.NET at front end.

I am executing following SQL

Select REF_NO, CHANGE_TYPE, CODE, CONSEQ from TB_MASTER

where OBJECT_TYPE='TABLE' and OBJECT_NAME='TABLE2' and PROJECTNAME='SANDEEP'

and relname='FCC' order by SUBSTR(REF_NO,2,1) DESC, REF_NO ASC



I am using following code in front end

Dim Connect As New OracleConnection()

            Dim Comm As New OracleCommand()

            Dim DAdapter As New OracleDataAdapter()

            Dim RowCounter As Integer = 0

            Dim param1, Param2, Param3, Param4, Param5, Param6 As OracleParameter

            Dim i As Object

            Dim Dr As OracleDataReader

            Dim Rs As New DataSet()

            Dim Rs1 As New DataSet()



            Comm.CommandText = _

                            " Select REF_NO, CHANGE_TYPE, CODE, CONSEQ from TB_MASTER " & _

                            " where OBJECT_TYPE = '" & p_type & "' and OBJECT_NAME = '" & _

                            l_objname & "' and PROJECTNAME = '" & p_projname & "' and relname = '" & _

                            p_relname & "' order by SUBSTR(REF_NO,2,1) DESC, REF_NO ASC "

                        Comm.Connection = Connect

                        Comm.Prepare()

                        DAdapter.SelectCommand = Comm

                        DAdapter.Fill(Rs1)



Line DAdapter.Fill(Rs1) Corresponds to 400 Line.



Here is the error I am getting



CoreLab.Oracle.OracleException: ORA-06550: line 2, column 209:

PL/SQL: ORA-00933: SQL command not properly ended

ORA-06550: line 2, column 4:

PL/SQL: SQL Statement ignored

   at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, Int32 A_1, Boolean A_2, Int32 A_3, Int32 A_4, Int32& A_5)

   at CoreLab.Oracle.OracleCommand.ExecuteReader(Command Behavior behavior)

   at CoreLab.Oracle.OracleCommand.c(CommandBehavior A_0)

   at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Flexmart.Flexmart.ClsFlex.fn_call_conv(String p_path, String p_projname, String p_relname, String p_type, String conn) in D:\Flexmart\Flexmart_VB\Flexmart.NET Uaing ODBC\Flexmart.vb:line 400





Can I get any help regarding this.



Thanks in Advance.

Regards,

Sandeep



Similar Threads
Thread Thread Starter Forum Replies Last Post
Got problem when combine 2 tables using left join wkm1925 MySQL 1 March 27th, 2007 04:02 PM
left outer join keyvanjan Classic ASP Basics 1 April 15th, 2006 05:37 AM
Why doesn't this LEFT JOIN work? harg7769 Access 2 April 13th, 2005 04:49 AM
left join msrnivas Classic ASP Databases 2 October 15th, 2004 07:37 AM
Left Join error mariakovacs Access ASP 2 October 13th, 2003 04:16 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.