what is the difference between trigger and storedprocedures16 21352
What are the default Oracle triggers??2 14300
What is the difference between DELETE and TRUNCATE?15 15694
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?4 6005
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )2 5586
how do you count the duplicate records in a table10 12941
how u can find the n row from a table?19 18242
what is the difference between implicit and explicit trigger2 16499
can we delete the trigger in a view? if yes why if not why?5 11443
What is mutating trigger?How to avoid it??3 10198
what is the difference between cursor FETCH and FOR LOOP ?3 21168
What is a mutating table5 6913
Write a procedure to return the month and the number of developers joined in each month (cursor )2 7138
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 8000
Do you have experience using a customer relationship management program? : insurance sales
I know that in version ECC6 exists the functionality of document splitting like this: If an Invoice is for 11,000/-.Then we write the GL as : vendor A/C Dr XXXX to Purchase 1 XXX to Purchase 2 XXX to Tax XX But through Document Splitting we can write it based on the %age of sharing as 80 : 20%.. Vendor A/c 8,800(DR) Purchase A/C 8,000(Cr) Tax 800 (Cr) Vendor A/C 2,200 (Dr) Purchase 2000(Cr) Tax 200(Cr) This is called Document Splitting But when you talk about tax, you mean a line item created manually like tax or a document where you complete the tax code and the line is created automatically? Thanks a lot in advance. REgards,Lorena
What is Sqoop?
Assuming that you are selected, what will be your strategy for next 60 days
What is empty tag?
What is conditional formatting excel?
How do I view a jsp file?
What are filtered views?
How to Execute a Package in PL/SQL.?
What is difference between web api and web services?
What do you mean by context initialization parameters?
Can you use Spark to access and analyse data stored in Cassandra databases?
Where is autoshape in word?
Explain briefly different instance modes in wcf?
How do I combine multiple workbooks into one?