If you have a program written in C - would it compile with Pascal compiler?
MSSQL and Oracle are two completely different databases and their internal
programming languages are different: Transact-SQL in MSSQL and PL/SQL in
Oracle. Seems like a visit to http://docs.oracle.com is due...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Rich D" <rdalfonso_at_nyc.rr.com> wrote in message
news:196cd325.0209181223.2907c569_at_posting.google.com...
> I have a bunch of triggers in SQl Server that I need to move over to
> Oracle 8i.
>
> But when I run it in Sql Plus I get nowhere. Any thoughts on why this
> doesn;t work or general syntax differences (declaring variables, etc)
> between SQl Server and Oracle
>
> my trigger is:
>
> CREATE TRIGGER InsertSeries ON dbo.Survey_Series
> FOR INSERT
> AS
> DECLARE
> @Prevmax_id int,
> @Survey_series_id int
>
> SELECT @Prevmax_id = 0
>
> SELECT @Survey_series_id = Survey_series_id FROM inserted
>
> SELECT @Prevmax_id = MAX(Survey_Series.Survey_series_sequence_id)
> FROM Survey_Series
>
> UPDATE Survey_Series SET
> Survey_series_sequence_id = @Prevmax_id + 1,
> Update_datetime = getdate() ,
> Update_username = app_name()
> WHERE Survey_series_id = @Survey_series_id
>
> Thanks,
> rdalfonso_at_nyc.rr.com
Received on Thu Sep 19 2002 - 01:07:51 CDT
