Which software is used for pl sql programming?
What is mdb stand for?
what tools available for managing mysql server? : Sql dba
Explain the difference between triggers and constraints?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
What trigger means?
Why we use join in sql?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
How to call the function and Procedure in trigger?
What is foreign key in sql with example?
What does the hierarchical profiler does?