Re: Oracle Problem 1: Please Help

The table looks like the following:

Code:

  INSTRUCTOR_ID(PK)    NUMBER(8,0)     NOT NULL
  SALUTATION     VARCHAR2(5)    NULL
  FIRST_NAME     VARCHAR2(25)  NULL
  LAST_NAME     VARCHAR2(25)  NULL
  STREET_ADDRESS     VARCHAR2(50)   NULL
  ZIP(FK)     VARCHAR2(5)    NOT NULL
  PHONE      VARCHAR2(15)
  CREATED_BY      VARCHAR(3)
  CREATED_DATE      DATE                NOT NULL


--------------------

I'm not fully capable to write PL/SQL I just started last week however I am a very compitent student. If I need to write a trigger could you lead me in the right direction.

--
singhjih


------------------------------------------------------------------------


Posted via http://www.webservertalk.com


------------------------------------------------------------------------


View this thread: http://www.webservertalk.com/message173341.html