Re: Oracle Problem 1: Please Help

From: singhjih <singhjih.14axu7_at_mail.webservertalk.com>
Date: Tue, 6 Apr 2004 12:33:26 -0500
Message-ID: <singhjih.14axu7@mail.webservertalk.com>

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

Received on Tue Apr 06 2004 - 12:33:26 CDT