Hi,
I need a trigger;
- to find number 1 from "ID" column and
- update "AVAILABILITY" column from Yes to No
in "PRODUCT" table.
Thanks
veledrom
32
Master Poster
Recommended Answers
Jump to PostNot 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
Jump to PostYou could always have Googled and found something like
http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_sps.htmlNige
All 5 Replies
veledrom
32
Master Poster
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
Nige Ridd
0
Junior Poster in Training
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
veledrom
32
Master Poster
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.
Nige Ridd
0
Junior Poster in Training
You could always have Googled and found something like
http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_sps.html
Nige
veledrom
32
Master Poster
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.