what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
2 6888Write a procedure to return the month and the number of developers joined in each month (cursor )
2 8438Practice 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 10501Post New Tech Mahindra SQL PLSQL Interview Questions
what do you know that m20,m25
Tell me how does the interrupts handle by using the threads?
What is purpose of getCurrentPosition() method of geolocation object of HTML5?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
List of Test Management Tools??Is Quality Center Test Management tools
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
What does db2 plan contain?
Situation - you want to revert payroll run for one employee. How would you do that?
What is a context in java?
What is sap-project system?
Design a divide-by-3 sequential circuit with 50% duty circle now?
What is the main control parameter for settlement?
Which heating value is indicated by a calorimeter and why ?
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
What is starvation and aging?