Home » Other » Training & Certification » Oracle 10G (Help Me On Triggers urgent........)
Oracle 10G [message #321502] Tue, 20 May 2008 08:56 Go to next message
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
Member
I want to write a trigger on view which depends on tables emp.
emp
------
empno
name
dept
desig
dob

empsal
------
empno
basic
hra
da


create or replace view empview
as
select e.*,s.* from emp e, empsal s
where e.empno = s.empno;

1) Want to insert bulk of records to the view as below

Insert into empview
select * from emplot where dept = 'sales';

2)Need to
a) delete records which are not available in emp table
b) insert new records into emp
c) update existing records
Re: Oracle 10G [message #321504 is a reply to message #321502] Tue, 20 May 2008 09:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to urgently:
- read OraFAQ Forum Guide, what is said about words like "urgent"
- read OraFAQ Forum Guide, "How to format your post?" section.
- read OraFAQ Forum Guide, "Posting guidelines/Practice" section
- Post what you tried

Regards
Michel
Re: Oracle 10G [message #321571 is a reply to message #321502] Tue, 20 May 2008 14:14 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
rangan.s wrote on Tue, 20 May 2008 15:56

I want to write a trigger on view ...
1) Want to insert bulk of records ...
2) Need to ...


Your requests sound as if you wanted someone of Forum members to do that job instead of you. Unfortunately, that's not the way this Forum works - it is YOUR task and you should do it.

I don't expect that it will work at once (otherwise, you wouldn't ask for help). However, you must write that trigger by yourself and - once it is properly written (i.e. without syntax errors and similar trivial problems) but it still doesn't work as you'd expect it to - do come back, post what you've done and ask for help on a specific problem. I'm sure that someone will take a look and provide assistance.
Previous Topic: The practice files of 1Z0-141(Oracle 9i Forms Developer: Build Internet Application)
Next Topic: Create a procedure to increase
Goto Forum:
  


Current Time: Fri Mar 29 05:55:53 CDT 2024