what is the difference between trigger and storedprocedures16 20793
What are the default Oracle triggers??2 13973
What is the difference between DELETE and TRUNCATE?15 15090
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 5824
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 5443
how do you count the duplicate records in a table10 12383
how u can find the n row from a table?19 17522
what is the difference between implicit and explicit trigger2 15898
can we delete the trigger in a view? if yes why if not why?5 11136
What is mutating trigger?How to avoid it??3 9916
what is the difference between cursor FETCH and FOR LOOP ?3 20683
What is a mutating table5 6677
Write a procedure to return the month and the number of developers joined in each month (cursor )2 6987
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 7663
diffrence betveen base rate and bplr
If we have to feed a housing complex having load 8MVA, than what would be the better option, either we first step down 33kv supply into 11kv & than 430v or we proposed no of 33/.44 kv transformer, also which option is economical?
What is an SEO package?
What combiners is and when you should use a combiner in a MapReduce Job?
What is the difference between use and require in perl programming?
What is the state if the RED LED is glowing on PWSx card What is the state if the YELLOW LED is glowing on PWSx card
which two statements about device fonts are true? : Adobe flash
What is the difference between logistics and transport?
what is mathematics-based operations?
interview questions and answers for hr trainee position
What is the purpose of using data modem.
Is dna organic?
What are the PPC tools would you suggest to a PPC fresher?
Explain the three Level Architecture of the Database System
Car tyres are usually made of ?