User Profile

Collapse

Profile Sidebar

Collapse
centeio69
centeio69
Last Activity: Jun 4 '08, 04:59 PM
Joined: Jun 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • centeio69
    replied to Query too long
    in Oracle
    Exactly. Problem is solved... thanks a lot....
    See more | Go to post

      Leave a comment:

    • centeio69
      started a topic Query too long
      in Oracle

      Query too long

      Hello everyone,

      I'm having some troubles displying this query in SQL Developer.I have 3 tables:
      MASTER_TRANSACT ION_HIST is a big table with millions of rows
      LOCAL and PLAFOND are small cardinality tables.

      select mt.LOCAL_ID, plf.SUBAGENT_ID , l.DESCRIPTION, to_char(min(mt. DATE_TRANS), 'dd-mm-yyyy')

      from ADM.MASTER_TRAN SACTION_HIST mt, ADM.LOCAL l, ADM.PLAFOND plf

      where mt.LOCAL_ID...
      See more | Go to post
      No activity results to display
      Show More
      Working...