Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anil siddi
We cannot update the view directly if the viw define with
more than one table(objects).By using Instead of triggers we
can do that
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
what is msql? : Sql dba
Can you inner join the same table?
What is a primary key? Explain
How do I start pl sql?
Describe types of sql statements?
How does sql store data?
What are the most important ddl statements in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do you pronounce sql?
Why commit is not used in triggers?
What is the difference between partitioning and sharding?
What is range partitioning?
What is substitution variable?
What is the process of debugging?
What are sql built in functions?
