About recreate triggers
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: About recreate triggers

  1. #1
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    About queston (sqlscript):
    If someboby ask forum "how i can include single special symbol in my select?"
    It's OK, He/she usually get aswer very quickly, without problems.
    This question not so simple as previous example!

    Mr. Pravin, did u try to write script for reingeneering trigger's code,
    all types of triggers( object triggers, db event triggers, dml event triggers,
    trigger on views ...) ?

    Structure on dba_triggers is'n simple, like dba_tables.
    field TRIGGER_BODY keep only body:
    declare
    ..
    begin
    ..
    end;
    and u must recreate trigger header from another field, and type of this process
    depend from type of trigger.
    because u can't use field DESCRIPTION directly, u must check type of
    trigger and type of base trigger object and rebuild field DESCRIPTION in script.
    and so on....

    About documentation:
    In documentation u can't find no one word about values of each field in
    dba_triggers table, but u can't write good script without values of fields
    in this particulate situation.
    U have to research this topic youself from real database.

    I'm sorry about this my post .

    NOTE: THIS IS RIGHT DECISION OF MODERATORS TO CLOCE THAT (kavithared) POST.
    I ASK TO CLOCE MY POST TOO.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    The Question was "to display all the triggers" Not to extract the source I Guess. People gets on this forum to answer and to get answered. The reason the thread was closed is to stop the quotes... but not answers. Moderators assumed that the question was answered and thread is going off topic...

    Shestakov,

    Let me tell you, go back a day and see the thread that member posted and the reason member gives when someone asked "can't you get it from documentation?". Thats what "Pando" meant by saying "Lazy People get what they deserve"

    Its little annoying when forum threads flooded with quotes... you know! Here I'm not supporting/discouraging anybody, but trying to encourage "kavithared" to take the advantage of available resources on the web prior to seeking help from others... If people misunderstand... nobody can help 'em...

    You have all the information that you wanted to know about the triggers if you follow the link I have provided and search with the string I have mentioned in kavithared "sqlscript" thread.

    [Edited by sreddy on 07-10-2002 at 01:16 PM]
    Reddy,Sam

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if someone ask

    give me create table syntax
    give me create database link syntax
    give me create user syntax
    give me select syntax
    give .. etc etc etc

    if we first tell him/her
    go to tahiti.oracle.com and he still keep on asking these kind of questions or he says "I am too busy with my job schedule to look that" then of course he gets what he deserves

    What's faster? Post a question and wait for replay or enter a word in tahiti and get a good nice result set in 1 minute?

    I would understand if someone searched for the syntax and the syntax does not work (which is doubtful because Orace doco is probably one of best application documents avaibale with over 25000 pages)

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Sam.
    U showed another problem of forum (not only this forum, all forums).
    "If you going to get right answer, ask right question".

    The Question "... to display all the triggers" and
    The Question "... to display list of all triggers"
    may be the same question may be different questions.

    I gess "... to display all the triggers" --> "... to display source code of all triggers"
    You gess "... to display all the triggers" --> "... to display list of all triggers"
    that is it.

    And this is the problem.

    -----------------------------------------------------------------------------------
    Pando.
    I agree, that Oracle docs one of the best technical documentation.
    (may be just best).
    Some times this is very good, sometimes not.
    I remember my first weeks, when i begun to work with oracle docs.
    (it was oracle 5 and 6, and internet doesn't exists like now)
    Only thru 3-5 monthes i could search needed to me topics in it quicly.

    [Edited by Shestakov on 07-10-2002 at 02:29 PM]

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Shestakov,

    I have just assumed that kavithared wanted to know the list of triggers in the schema.( Basically a view which lists the triggers) Its very unusall one wanted all the source of the triggers ( and Just triggers ) in a schema.

    Anyway, its good for a member to spend 2 to 3 minutes on the docs rather wait 5 minutes to get question answered here.

    Whenever we(you, me and all) post the links here, what do we do ? don't we search ? or what ?

    I just go by "Your effort is much more worth than somebody's effort for you"
    Reddy,Sam

  6. #6
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    shestakov that was really hard and offending for me on ur part

    The sql script thread was closed because QUOTES thing started it was leading to unknown destination, so jeff did a good thing of closing that thread, few days back when i posted question , quotes started and it was diverting from the topic, it is quite annoying when somebody answers in QUOTES and it goes on and on leaving actual answers behind .

    Now

    To read is the base of knowledge
    The nature of questions ALWAYS asked by kavitathared ( as of date ) in the support forums are very basic dba questions. (Query, syntax , concepts, tables ).
    One should make own attempts/ take pains first in finding the answers , also the dba support thread is grown very much , so if one does a search he/she might get a answer to that.

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  7. #7
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Well said... The forums are not for homework answers or for those who do NOT perform initial research on their own. Forums should be utilized when someone exhausts their searches and is still unable to correct the problem. Whenever a thread is posted, reseach is usually performed by the individual responding (Although they might know the answer) to ensure correct information.

  8. #8
    Join Date
    May 2002
    Posts
    219
    There is no other way of guarding oneself against flattery than by letting men understand that they will not offend you by speaking the truth; but when everyone can tell you the truth, you lose their respect.
    Niccolo Machiavelli (1469 - 1527), The Prince
    yodaDBA@hotmail.com

  9. #9
    Join Date
    Dec 2001
    Posts
    50
    Shestakov what u said is right

  10. #10
    Join Date
    Apr 2002
    Posts
    2
    I am reading on this forum regularlyfor quite some time(more than 6 months). So far i did not post any question or reply. But I gained/learned so much by reading thru other posts and searching thru the links.
    I noticed Kavithared is posting all basic questions for which ans can be obtained easily
    thru simple search. May we should use forums to get the ans which we dont know, that does not mean
    jump onto the forum and post the question immediately for everything. I dont think guys answering in this forum are dont have any work to do. If any one posts silly questions again and again, he/she should be ready to get all kind of ans.
    --------------------------------------
    Gayatri: Shestakov what u said is right
    ---------------------------------------
    I dont know what people like Gayathri doing in this technical forum??????
    I never seen any tech reply/post by her.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width