1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

oracle, triggers, updating

Discussion in 'General' started by monkey, Apr 24, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    Please, if someone finds me an exampel easy enought for triggers when updating data (one update causeing another update).
    I am searching for the template, trying but still did not google anythign usegfull enough!
    many thanks!!!
     
  2. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
  3. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Dear All!
    Please, what is that line actually doing?
    dbms_output.put

    is it printing (folowint text) on the screen or?
    Many thanks!!!
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    begin
    dbms_output.put('Hi this just Put');
    end;

    Output:
    No data.

    begin
    dbms_output.put('Hi this just Put');
    dbms_output.put_line('Hi this Put Line');
    end;

    Output:

    Hi this just PutHi this Put Line

    I think now u will realize the meaning of those statements...
     
  5. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!:)thumbup)
    Probably in first example instead "No data" should stand ""Hi this just Put".

    (really sorry, just in mess, probelm is each dot is important, i DO FIND explanations for big issues, but I miss details and all drops to water...)
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO