•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 332,649 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,328 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 227 | Replies: 5 | Solved
 |
•
•
Join Date: Apr 2008
Posts: 33
Reputation: 
Rep Power: 1
Solved Threads: 0
Light Poster
Hi,
I need a trigger;
- to find number 1 from "ID" column and
- update "AVAILABILITY" column from Yes to No
in "PRODUCT" table.
Thanks
I need a trigger;
- to find number 1 from "ID" column and
- update "AVAILABILITY" column from Yes to No
in "PRODUCT" table.
Thanks
•
•
Join Date: Apr 2008
Posts: 33
Reputation:
Rep Power: 1
Solved Threads: 0
Light 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
Shortly; Insert data into "ORDER" table and then things get updated in "PRODUCT" table as i required in first message.
Thanks again
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 8
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
Nige
•
•
Join Date: Apr 2008
Posts: 33
Reputation:
Rep Power: 1
Solved Threads: 0
Light 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.
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 8
Junior Poster in Training
You could always have Googled and found something like
http://www.oracle.com/technology/pub...uecks_sps.html
Nige
http://www.oracle.com/technology/pub...uecks_sps.html
Nige
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
Similar Threads
- Trigger help (MS SQL)
- problem with trigger (MS SQL)
- SQL trigger based on a true/false field value (MS SQL)
- Computed column in view VS trigger on update (MS SQL)
- Hi - how do you trigger a macro to run when a cell is updated in Excel? (Windows Software)
- Trigger onChange manually (HTML and CSS)
Other Threads in the Oracle Forum
- Previous Thread: How to insert files into Database using Struts2 + Spring + persistence
- Next Thread: Sysdate check
