Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5524 Views
- Ardee Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / dinesh
Yes We can update base table through complex view
Using "Instead of trigger"
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are different types of triggers?
What does bitemporal mean?
Explain the insert into statements in sql?
what are sequences
How do you explain an index number?
What is cursor and why it is required?
Can we debug stored procedure?
What is the usage of nvl function?
Is crud a cuss word?
What are the types of variables use in pl sql?
Can primary key be changed?
What is trigger with example?
What does := mean in pl sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the difference between left and left outer join?
