what are the forced views

Answer Posted / lakshmi

creates a view whether or not base table exists

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert delete data in view?

542


what is a trigger in mysql? Define different types of trigger. : Sql dba

548


What is the most common sql injection tool?

543


How to know the last executed procedure?

586


How do I send sql query results to excel?

577






What are the string functions in sql?

528


What is trigger and how to use it in sql?

536


What does the base_object_type column shows in the user.triggers data dictionary view?

572


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

1774


Explain the uses of database trigger.

650


Should I use mbr or gpt?

544


What is rtm in testing?

572


What is the difference between nested table and varray?

516


What does the hierarchical profiler does?

566


What are secondary keys?

559