Re: update two oracle tables with single SQL Query?

On 16 abr, 13:17, "sybrandb" <sybra...@xxxxxxxxx> wrote:
On Apr 16, 12:49 pm, "Mahesh" <registered.h...@xxxxxxxxx> wrote:

Hi All
I just need to know is it possibel to update two different tables in a
single SQL Query??

Thanks in advance
Maheshkumar

You can update inline views

update (select empno, ename, deptno, dname
from emp, dept
where emp.deptno = dept.deptno)
set

etc.

--
Sybrand Bakker
Senior Oracle DBA

Sybrand.

Sure you can, but you can only update ONE of the underlying tables at
a time.

(ORA-01776: cannot modify more than one base table through a join
view)

Cheers.

Carlos

.

Relevant Pages

  • Re: update two oracle tables with single SQL Query?
    ... single SQL Query?? ... You can update inline views ... update (select empno, ename, deptno, dname ...
    (comp.databases.oracle.misc)
  • Re: Run a Query from a Form
    ... EmpNo is a number. ... that particular record and display the rest of the fields in proper textboxes ... should i create a query in the QBE or i can simple write some code ... When you add a command button to a form, the Wizard gives you several ...
    (microsoft.public.access.queries)
  • RE: Replace Parentheses with Bracket in Subquery
    ... Prevent it by not using subqueries in that way. ... queries and use those queries as the input "tables" to the main query. ... INNER JOIN ... FROM HardwareSales GROUP BY EmpNo) AS H ...
    (microsoft.public.access.queries)
  • RE: Replace Parentheses with Bracket in Subquery
    ... may have multiple entries in the HardwareSales and SoftwareSales tables. ... probably accomplish what you need with a straight summary query. ... FROM HardwareSales GROUP BY EmpNo) AS H ...
    (microsoft.public.access.queries)
  • Re: Run a Query from a Form
    ... the easiest way is to create a form (FrmFindEmployee) based on your ... When the Wizard kicks in, choose Form Operations, Open ... In the right hand, choose EmpNo ... should i create a query in the QBE or i can simple write some ...
    (microsoft.public.access.queries)
Loading