why you need store procedure ? where do we use it in a Java
project? can you get the code for as store procedure using in
Java?
Answer / guest
Stored procedure nothing but the set of SQLs which is
executed an controlled by database itself.Its useful when
you want to use the data from tables to be access
frequently.yes, we can get the same SQLs in java code as
well. Infact using Callable , stored procedures can be called.
Is This Answer Correct ? | 20 Yes | 1 No |
What is procedure overloading in oracle?
What is the purpose of a cluster?
What are various joins used while writing SUBQUERIES?
Explain table?
How does oracle handle read consistency?
Is it possible to insert comments into sql statements return in the data model editor ?
What are the components of logical database structure in oracle database?
Explain database link?
What is the difference between implicit index and explicit index?
What are the advantages of oracle 12c?
what is reindexing?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.