Loading ...
Sorry, an error occurred while loading the content.

179Re: Join Problem

Expand Messages
  • dieleichtemuh
    Sep 2, 2004
    • 0 Attachment
      Thank's a lot

      I'am new too but OWB is a funny thing :-)

      --- In OracleWarehouseBuilder@yahoogroups.com, dfp1294
      <no_reply@y...> wrote:
      > Hi, Since you are getting an invalid relational operator error, I
      am
      > thinking the problem may be in the operator. I am just beginning
      to
      > learn OWB, so only have ideas that you might could try. IT seems
      > that you may either have a compatiblitiy issue (are the columns the
      > same type and does the data match) or the SQL may not able to
      compare
      > the values using the equal symbol. Perhaps try the testing your
      SQL
      > outside of OWB and make sure the case statement works. Using LIKE
      > instead of = could be one reason for having the problem.
      >
      > --- In OracleWarehouseBuilder@yahoogroups.com, "dieleichtemuh"
      > <andreas.dernbauer@c...> wrote:
      > > No the query is exactly what you see. Do you mean that I should
      use
      > > like instead of = ??
      > > thx
      > > --- In OracleWarehouseBuilder@yahoogroups.com, dfp1294
      > > <no_reply@y...> wrote:
      > > > Have you tried using the keyword LIKE instead of the = sign?
      > > >
      > > > --- In OracleWarehouseBuilder@yahoogroups.com, "dieleichtemuh"
      > > > <andreas.dernbauer@c...> wrote:
      > > > > Hi
      > > > > I use the following join operation
      > > > >
      > > > > CASE WHEN COUNTRYIES_STG.CTRY_ISO =
      > > > COUNTRIES_STG.ISO_COU_ALPHA_TWO
      > > > > THEN
      > > > > COUNTRYIES_STG.CTRY_ISO
      > > > > ELSE
      > > > > COUNTRYIES_STG.CTRY_ISO
      > > > > END
      > > > >
      > > > > and receive the error
      > > > > Line 6, Col 5:
      > > > > PL/SQL: ORA-00920: invalid relational operator
      > > > > can u help please
    • Show all 7 messages in this topic