Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    13

    Database concept

    I would like to ask that err... for trigger.. does every database uses the same scripts? i mean can i use just one script to run on different databases? like informix, SQL Sever, Sybase, Oracle .. etc?? thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Database concept

    Originally posted by mfkow
    I would like to ask that err... for trigger.. does every database uses the same scripts? i mean can i use just one script to run on different databases? like informix, SQL Sever, Sybase, Oracle .. etc?? thanks
    No, the CREATE TRIGGER syntax may be similar but the trigger code will not be. For example, Oracle's triggers are written in Oracle's own PL/SQL language.

  3. #3
    Join Date
    Jun 2003
    Posts
    13
    ic.. so means that there is no other solution except create a new set of trigger for each database? thanks

Posting Permissions

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