what is the difference between trigger and storedprocedures16 20612
What are the default Oracle triggers??2 13860
What is the difference between DELETE and TRUNCATE?15 14889
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 5772
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 5373
how do you count the duplicate records in a table10 12181
how u can find the n row from a table?19 17305
what is the difference between implicit and explicit trigger2 15712
can we delete the trigger in a view? if yes why if not why?5 11061
What is mutating trigger?How to avoid it??3 9850
what is the difference between cursor FETCH and FOR LOOP ?3 20533
What is a mutating table4 6537
Write a procedure to return the month and the number of developers joined in each month (cursor )2 6937
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 7556
What are events in C#?
what is span of shares
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Can a view be mutating? If yes, then how?
What is one of the problems with project management software? A. The project manager manages the software instead of the project B. Project duration calculations are sometimes approximate. C. You cannot override the project management software decisions regarding schedules. D. It’s expensive and difficult to use.
Explain about RSA algorithm? How secure is this algorithm?
I am going to add images into a tag. How will it resize itself in adobe flex actionscript?
why not null is not allowed at table level
If specific gravity of cement is less than 3.15 what is the cause?
full form of flry b
What is null queue?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Can we migrate code from Java to Kotlin?
How often DataNode send heartbeat to NameNode in Hadoop?
please send me previous year questions of jspl through which i could prepare myself for the test.