what is the difference between trigger and storedprocedures16 18793
What are the default Oracle triggers??2 12304
What is the difference between DELETE and TRUNCATE?15 13242
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 5007
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 4694
how do you count the duplicate records in a table9 10604
how u can find the n row from a table?19 15583
what is the difference between implicit and explicit trigger2 13439
can we delete the trigger in a view? if yes why if not why?5 9796
What is mutating trigger?How to avoid it??3 8990
what is the difference between cursor FETCH and FOR LOOP ?3 17920
What is a mutating table4 5699
Write a procedure to return the month and the number of developers joined in each month (cursor )2 6017
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 6056
What is Alpha & Beta fctors related to Orifice Plate & its relation with flow?
what happens in the short circuited secondary transformer,if the resistance of the short circuit is increased gradually?
Please any one help me I preparing for the post of charge man in Indian ordinance factory please give me some guide line & book for this exam.my email. firstname.lastname@example.org
WHERE WE CAN USE VAT 5%,14.5%
Why do you want to join Virtual Command Centre (Work Force Management)
Someone wants to send a small quantity, say about 500 Kgs., of green coffee beans from Koraput Orissa to Bangalore for Roasting and Packaging of the same there. There will be a loss in weight of about 20% during the processing the green coffee beans into coffee powder, which will then be fit for human consumption. Now, after processing the green coffee beans at Bangalore, the person wants to sell simultaneously a part of the Roasted Coffee Powder to four persons; one of them is in Chandigarh (a registered Dealer in Punjab) and the other is in Mumbai (possibly he is a an individual and not a registered dealer), third one is a registered dealer in Bangalore and the last one is an individual consumer just like you and me, and is not a registered dealer and stays in Mysore. The person wishes to bring the rest of the packed Roasted Coffee Powder back to Koraput, Odisha. The planter is a registered dealer under VAT in Odisha and has produced (manufactured) the coffee beans in his own gardens, and has applied for a CST Number but is yet to obtain the Number. We want to know: As to whether he can send the coffee beans to Bangalore for roasting without obtaining a CST Number beforehand. Or as to whether it is mandatory for him to get the CST registration first, before sending the Coffee beans to outside the state; As to how the person can generate the Way Bills from here and to send these to the transport carriers, for his sales to Chandigarh, Mumbai, Bangalore and Mysore. Tell me as to how he can do the necessary paper works and as to how he can pay the tax collected thus, As to how he can bring the rest of the roasted coffee powder back to Koraput that he can sell afterwards in the state and outside; He shall be sending samples of the Roasted coffee to Philippines and elsewhere, from Bangalore itself. May be in a subsequent times he might export, for which he has to send the roasted coffee powder to Mumbai; If the person wants to send the parchment coffee to Kushal Nagar in Karnataka to do the Curing Pre-Roasting) there, as to how he can send the processed coffee to the Roster at Bangalore. During Curing there is a loss of weight of about 20% too. Until the roasting is done, there will be no transfer of ownership, at any point of time, in between.
what is aom and how to add object repository? i am very new to QTP please help me
hi i got i 20 from sacred heart university u.s.a.i got good tofel score and my gre is score is very poor.my university requirement is only tofel.i completed my b.pharmacy in 2009 so i got 1 year gap is their chances to reject visa?what i have to do i was very tensed.how to sought out my problem
I have an S Corporation called Trend Foods Inc. I would like to make a division of that company that services computers and call that Trend Computer Service. I do not want to set up another Corporation for Trend Computer Service. Can I just make a division of Trend Foods and what paperwork do I need to fill out to make that happen? Thanks for the help, Jim
Can any one give an example (Source Code) on virtual function implemetation in Java?
In Residential home construct footing,beam, column,lintel,rcc roofs which dia rod used how to self assumed
1. What is maximum permissible distance between smoke detectors ? 2. How do we decide number of smoke detectors required in a large office, warehouse, hall etc ? 3. What should be maximum height of smoke detectors ? 4. Where do we use heat detector, optical smoke detector, temperature sensitive detector ?
hi what is the difference between sap apo technical and functional?
what are the different types of codes in thread in windows os?
How many cylonders are there in 2stroke diesel engine?