what is the difference between trigger and storedprocedures16 23164
What are the default Oracle triggers??3 15064
What is the difference between DELETE and TRUNCATE?15 17258
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 6581
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 6027
how do you count the duplicate records in a table10 14029
how u can find the n row from a table?19 20105
what is the difference between implicit and explicit trigger2 18319
can we delete the trigger in a view? if yes why if not why?5 12179
What is mutating trigger?How to avoid it??3 11067
what is the difference between cursor FETCH and FOR LOOP ?3 22335
What is a mutating table5 7557
Write a procedure to return the month and the number of developers joined in each month (cursor )2 7531
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.1 8811
How to read data in a table with "select" statements?
Explain some new features available in jdbc 4.0?
Tell me what http servers and java servlet engine combinations are supported with peopletools 8.4?
What is the difference between shadow dom and virtual dom?
What is SKM and when we will use this SKM?
Explain the difference between the stack and the heap?
Explain what is wrong with this statement? Myname = ?robin?;
Give an example of a directcast.
what is Modal plugin used for in Bootstrap?
What is beanpostprocessor in spring?
WHAT IS THE SIGNIFICANCE OF VECTOR GROUPS IN TRANSFORMER? WHAT WILL BE EFFECT WHEN PHASE DISPLACEMENT CHANGES IN TRANSFORMER?WHAT IS THE NEED TO BE PHASE SHIFT CHANGE BETWEEN THE PRIMARY AND SECONDARY WINDING
Explain ratio control system.
Without air traffic control, what is the minimum descent rate can descend the plane?
What are the different types of database testing?
Why is spark popular?