PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:25 PM
Subject: Re: [SQL] Create function statement with insert statement
I can select from this table although the output is slightly
different:
lanname | lanispl | lanpltrusted | lanplcallfoid
Hello Susan,
The relevant code for creating the hexorders table (and associated
constraints) is:
DROP TABLE HEXORDERS ;
DROP SEQUENCE HEXORDERS_SEQ ;
CREATE SEQUENCE HEXORDERS_SEQ START 1 ;
CREATE TABLE HEXORDERS
I think the language needs to be in quotes ...
...
' language 'sql';
Jon Griffin [EMAIL PROTECTED] 03/12/03 11:59AM
You need to put your aliases in:
value1 alias for $1;
etc.
Hello,
I am trying to create a database trigger which inserts into a second
table. I have created the following