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
Can we insert delete data in view?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is the most common sql injection tool?
How to know the last executed procedure?
How do I send sql query results to excel?
What are the string functions in sql?
What is trigger and how to use it in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
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
Explain the uses of database trigger.
Should I use mbr or gpt?
What is rtm in testing?
What is the difference between nested table and varray?
What does the hierarchical profiler does?
What are secondary keys?