Oracle Text (MOSC)

MOSC Banner

Problem with Oracle Text query

edited Jun 5, 2009 2:24AM in Oracle Text (MOSC) 2 comments
 I have the following sql query:
SELECT  
 chg.chg_id, chg.datetime,
 chgtxtun.text user_name,   chgtxtco.text user_comment, 
 chg.operation,  chg.bnumber,
 chg.status,  chgtxtrn.text,
 chg.param1,  chg.param2,
 chg.role_type,  chg.bsk
 FROM 
    (changelog chg
      left outer join text_values chgtxtun on chg.tid_user_name=chgtxtun.id    
      left outer join text_values chgtxtco on chg.tid_user_comment=chgtxtco.id   
      left outer join text_values chgtxtrn on chg.tid_resource=chgtxtrn.id)
-------
  LEFT OUTER JOIN
-------
    (customer cus
    left outer join text_values custxt on cus.tid_name=custxt.id )
  ON cus.bsk=chg.bsk

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center