Re: HELP - TRIGGERS !?! (Post msg)

jcrupi_at_mystech.mystech.com (John Crupi) writes:
>
>I am unable to create a trigger in sql/plus.
>
>Can someone please give me the syntax
>on creating a trigger which INSERTS a value
>into a COLUMN of a newly created RECORD.
>
>By the way I want to insert a SEQUENCE.nextval
>into the COLUMN.

*blush* Sorry! My last posting assumed SQL*Forms, too.

I executed this SQL successfully. Hope it helps.

OPS$RZX2122 SQL> DESC INOUG_MEMBERS

 Name                            Null?    Type
 ------------------------------- -------- ----
 MEM_ID                          NOT NULL NUMBER
 MEM_LAST_NAME                            CHAR(30)
 MEM_FIRST_NAME                           CHAR(30)
 MEM_MIDDLE_NAME                          CHAR(30)
 MEM_TITLE                                CHAR(50)
 MEM_COM_ID                               NUMBER
 MEM_ADD_ID                               NUMBER
 MEM_PHONE                                CHAR(20)
 MEM_FAX                                  CHAR(20)
 MEM_TYPE                                 CHAR(1)
 MEM_MAILING_LIST                         CHAR(1)

OPS$RZX2122 SQL> R
  1 INSERT INTO INOUG_MEMBERS
  2 SELECT INOUG_MEMBERS_S.NEXTVAL, 'CRUPI', 'JOHN', NULL,   3 'jcrupi_at_mystech.mystech.com', NULL, NULL, NULL, NULL, 'G', 'Y'   4* FROM DUAL 1 row created.

                                            chicago ,--------+  detroit
Tom Harleman                                        |        |
INOUG Committee Member                              |Indiana |
Paradigm Consulting, Inc.                 st.       | Oracle |
11080 Willowmere Drive                    louis     |  Users |
Indianapolis, IN  46280                             |   Group|
USA                                                 |        |
                                                    |      _,+cincinnati
INTERNET:   72072.2122_at_compuserve.com               /   _,'
Compuserve: 72072,2122                             /_,-'louisville
                                                   `