Search results for query: *

Using the Enterprise Manager. First click on the Table on the tree and creating a table. Open the relationship and trying to add the table in the relationship ,it gives an error message CoIntialize has not been Called. How to correct this error and why is the error occuring.

create trigger <trigger-Name> before delete on <any table namae other than the employee> for each row begin check_delete(:old.emp_no,:old.emp_sysdate); end; You should make emp_no as a primary key and then do the following: Create a temp table so that you have two field(the parameters which...

drop trigger t; create trigger t before insert on temp1 for each row declare name varchar2(20); begin select empname into name from temp where emp_id=:new.emp_id; if (lower( name))='man' then raise_application_error(20,'sdfdfds'); end if; end;

HI ALL! I have a problem in creating a trigger. I have got two tables as follows: create table temp ( EMP_ID number(5) Primary Key, ENAME varchar2(10) ); create table temp2 ( EMP_ID number(5) references temp(EMP_ID), salary number(5) ); I am suppose to create a trigger which will not allow...