Member Avatar for vinaysrk919

use of trigger in asp.net, show me with coding.......in oracle 10g

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

A trigger to do what? Its hard to give a code example when its not clear what you want. The basic trigger statement looks like this:

CREATE TRIGGER schema.trigger_name 
    BEFORE or AFTER or INSTEAD OF
    DELETE OR INSERT OR UPDATE 
    ON schema.table_name 
    ...

if you intend you use asp.Net to create the trigger send it to the database using executeNonQuery

Hope that helps,

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.