Member Avatar for veledrom

Hi,

I need a trigger;
- to find number 1 from "ID" column and
- update "AVAILABILITY" column from Yes to No
in "PRODUCT" table.

Thanks

  • 2 Contributors
  • 5 Replies
  • 113 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for veledrom

Let me add; above process will be done after an insert into in "ORDER" table.

Shortly; Insert data into "ORDER" table and then things get updated in "PRODUCT" table as i required in first message.

Thanks again

Member Avatar for Nige Ridd

Not sure triggers are the best way to do this. BUT if you want to stick with triggers, you'll also have to write update and delete triggers ( If you delete an order for an item it's availability would increase, updating an order could affect it either way ).
Nige

Member Avatar for veledrom

How i send data from php to stored procedure and process it? I can't find it. I am new in oracle as well. I need a very simple example to give me an idea.

Member Avatar for veledrom

i know i can use insert into in the trigers but, can i use update or delete table set...where id=1 in any trigger?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.