Home » Other » Training & Certification » Create trigger
Create trigger [message #281573] Sun, 18 November 2007 07:49 Go to next message
Messages: 1
Registered: October 2007
Location: Pune
Junior Member

I have assigned the task given below.please guide me in approaching the solution.Help will be highly appreciated.

Thanks& Regards

Create a table emp1 with columns eid datatype number,ename datatype charecter constraints primary key on eid.

Create sequence to generate the eid which start with 1000 and increase with 1

Create procedure and insert the eid(get the value from sequence) and ename as a constant
e.g mallikarjun

Create trigger (before insert) on emp1 table wich will call the another procedure(in Step:5)

create procedure which is having in out parameter as type emp1.ename
display the ename before inserting
change the ename to mallikarjun kotturu
display the ename after insert.

The final data should be 1000 as eid and mallikarju kotturu as ename in the table.

Re: Create trigger [message #281576 is a reply to message #281573] Sun, 18 November 2007 08:28 Go to previous messageGo to next message
Messages: 2818
Registered: May 2007
Location: Scotland
Senior Member
And what have you tried? Or do you expect us to do your homework for you?
Re: Create trigger [message #281578 is a reply to message #281573] Sun, 18 November 2007 08:31 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference

SQL Reference

Previous Topic: DB CACHE
Next Topic: procedures
Goto Forum:

Current Time: Sat Oct 22 02:23:01 CDT 2016

Total time taken to generate the page: 0.14065 seconds