Re: Stored Procedures/Triggers Standards?

In article <1993May11.115842.438@gtewd.mtv.gtegsc.com>, davidsonj@gtewd.mtv.gtegsc.com writes: > In article <1993May11.132132.5553@pyra.co.uk>, graeme@pyra.co.uk > (Graeme Sargent) writes: > > > > stuff deleted.... > > > > Sybase has had triggers since the beginning. I don't think they have > > Stored Procedures yet, although I believe this is "imminent" in System > > 10. > > > > more stuff deleted.... > > > Sybase does have stored procedures as well as triggers and rules. I have no > idea how well they conform with any standards and again Sybase has their own > procedural language version of SQL called T/SQL (Transact SQL) that, I > expect, > is quite similar to Oracle's PL/SQL. (Rules specify legal ranges for values > - I am not sure if those values can be based on a query of another table). The nice thing about PL/SQL (Oracle's) that Transact SQL does not have is CURSORS. I am not sure with Sybase in its current version but when I was playing with it it did not have PRE-ACTION triggers eg PRE-INSERT or ON-INSERT triggers. Oracle have triggers for the following action against the table, INSERT, DELETE and UPDATE. Now that is PRE and POST triggers. This makes it 6 different triggers so far. On top of that they have trigger at TABLE or ROW level. So in total they have 12 different triggers. These trigger can call procedures as well. -- _____ ________ / ____ |Tony Jambu, Database Administrator /_ __ /_ __ / |Colonial Mutual Invest Mgmt,Aust (ACN004021809) /(_)/ ((_/ \\_/(///(/_)/_( |EMAIL: TJambu@cmutual.com.au \\_______/ |PHONE: +61-3-6418448 FAX: +61-3-6076198