Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #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

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.