| Oracle 10G [message #321502] |
Tue, 20 May 2008 08:56  |
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 #321571 is a reply to message #321502] |
Tue, 20 May 2008 14:14  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
