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 NUL
-------------------
I'm not fully capable to write PL/SQL I just started last week howeve
I am a very compitent student. If I need to write a trigger could yo
lead me in the right direction
-
singhji
-----------------------------------------------------------------------
Posted via
http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread:
http://www.webservertalk.com/message173341.htm