what is the difference between trigger and storedprocedures16 17872
What are the default Oracle triggers??2 11364
What is the difference between DELETE and TRUNCATE?15 12495
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 4578
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 4320
how do you count the duplicate records in a table9 9825
how u can find the n row from a table?19 14616
what is the difference between implicit and explicit trigger2 12174
can we delete the trigger in a view? if yes why if not why?5 9020
What is mutating trigger?How to avoid it??3 8456
what is the difference between cursor FETCH and FOR LOOP ?3 16442
What is a mutating table4 5242
Write a procedure to return the month and the number of developers joined in each month (cursor )2 5371
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 4624
what is the configuration steps of letter of credit?
What is the diffrent job&project accounting?
I had completed my diploma in electronics and communication. Currently am working with a pvt. ltd. (with two years of experiences) company which makes panel using plc, VFD(drivers) and scada monitoring system. so should i get supervisor licence for my supervisor post???
sir i m preparing for BARC but i am not getting any papers to prepare for this exam so please send me some sample papers to my i.d for the preparation of barc.
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
in govt polytechnic lecturers tell me what is the expected cut off for ece after the interview list announced
What is Response time of a thermocouple and a PT 100
What is ferro-resonance in electrical system? Why it occurs and what are measures to prevent it?
Relation between LOD and tablet compression
what value is returned to operating system after program execution?
Whata are the types of Cables?
Diff b/w Crossproduct and Outerjoin?
what are the test requirment fot protocol testing (for SS7,SIP)
why should i select to you foe the college?