How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
2 12511How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
4 15672i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
6 13675using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
4 12016sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8270Post New Fidelity SQL PLSQL Interview Questions
We have a variety of career paths available at Apple. What kind of growth would you like to see here?
What are the problems faced by users by using soap?
State the difference between strings and arrays.
Explain the 3 types of properties in c# with an example?
pharmacovigilance opportunities in Hyderabad
How would you differentiate between cluster and grid?
What are the internal and external faults?
What are enantimorphs and diastereomers ?
Explain the use of 'auto' keyword
What is the servletconfig object?
Is postgres distributed?
What is query image?
How can you access the properties and controls of master pages from content pages?
"A" has two divisions of "B" and "c".In our system we have two vendor accounts of B&C.We have received one Non PO invoice of B and posted wrongly in C and its got paid.While reconciling the account we got this error is happend.We contacted the C and asked for refund.But C said,he transfer internally the amount directly to B and he will not refund the amount.How we will settle this entry in our books. If we reverse the entry...there is one invoice needs to be reverse and payment doc needs to be reverse..how we can settle this in our books...
Explain how to import oracle sequence into informatica?