User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,580 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 3,386 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.
Join our community!
Please support our Oracle advertiser: Programming Forums
Views: 733 | Replies: 5 | Solved
Reply
•
•
Join Date: Apr 2008
Posts: 195
Reputation: veledrom is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
veledrom veledrom is offline Offline
Junior Poster

Trigger help

  #1  
May 2nd, 2008
Hi,

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

Thanks
AddThis Social Bookmark Button
Reply With Quote  
•
•
Join Date: Apr 2008
Posts: 195
Reputation: veledrom is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
veledrom veledrom is offline Offline
Junior Poster

Re: Trigger help

  #2  
May 2nd, 2008
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
Reply With Quote  
•
•
Join Date: Nov 2007
Posts: 51
Reputation: Nige Ridd is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 9
Nige Ridd Nige Ridd is offline Offline
Junior Poster in Training

Re: Trigger help

  #3  
May 2nd, 2008
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
Reply With Quote  
•
•
Join Date: Apr 2008
Posts: 195
Reputation: veledrom is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
veledrom veledrom is offline Offline
Junior Poster

Re: Trigger help

  #4  
May 2nd, 2008
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.
Reply With Quote  
•
•
Join Date: Nov 2007
Posts: 51
Reputation: Nige Ridd is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 9
Nige Ridd Nige Ridd is offline Offline
Junior Poster in Training

Re: Trigger help

  #5  
May 2nd, 2008
You could always have Googled and found something like
http://www.oracle.com/technology/pub...uecks_sps.html

Nige
Reply With Quote  
•
•
Join Date: Apr 2008
Posts: 195
Reputation: veledrom is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
veledrom veledrom is offline Offline
Junior Poster

Re: Trigger help

  #6  
May 3rd, 2008
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?
Reply With Quote  
Reply

•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode

Similar Threads
Other Threads in the Oracle Forum

Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 7:30 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC