Update on the (date)

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Fri, 30 May 2008 3:36 pm

Guys I'm trying to make an update in a field (date) listing but I'm not getting tables dus can someone give me a force?
Look update: ORACLE UPDATE B SET T304_ERR b. DATENT_MIE = (SELECT DISTINCT a. DATENT_MME FROM the T303 WHERE b. NUMDOC_MIE = a. NUMDOC_MME AND CODEMP_MIE = 1 AND CODFIL_MIE = 60 AND ANOREF_MIE = 2005 AND MESREF_MIE = 11) abs,
dfreire
Location: são paulo

Poston Fri, 30 May 2008 4:24 pm

Brother, Displays some error or does not perform the Update.
If not run, verify that your subquerie returns something.
Anything, send it to us.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: No registered users and 2 guests