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 12618How 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 15827i 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 13884using 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 12172sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8343Post New Fidelity SQL PLSQL Interview Questions
How to delete a column in an existing table in oracle?
how convert the spiral model to prototype model ?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What was the hardest class in engineering you had to take?
How many hours does a python sleep?
What about the master repository?
What is linq syntax in c#?
Explain what is sslpeer in ibm websphere mq?
What are the four Oracle system processes that must always be up and running for the database to be useable?
how Hadoop is different from other data processing tools?
How many mechanical engineers work with you at your place of employment?
What are the roles and responsibilities on a current mobile application you are testing?
What is microsoft excel and its functions?
What is a chasm trap?
What is the canvas element in html5?