Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sunitha
View is a logical representation of subset of data.
there are simple,complex and materialized views.
View does't take any space in database.
view are used for security purpose.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
what is sql in mysql? : Sql dba
Can we insert delete data in view?
Can cursors be part of a trigger body?
how to shutdown mysql server? : Sql dba
How many databases can sql express handle?
Can we rollback delete command?
What is database sql?
What is the use of desc in sql?
what is the difference difference between procedure and packages
How do I find sql profiler?
how to calculate the difference between two dates? : Sql dba
How do I tune a sql query?
What is spool?
what is datawarehouse? : Sql dba
