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 are the different pseudo commands? Explain in general?
How do I connect to oracle database?
How to drop an index?
What is the difference between 10g OEM and 11g OEM?
Why does for update in oracle 8 cause an ora-01002 error?
Explain database link?
How do we create privileges in oracle?
what is the difference between rollback & commit? can a foreign key has null value?
How to retrieve values from data fields in record variables?
What is a trigger and what are its types in oracle?
what is the difference between simple view and complex view?
What is the function of Optimizer ?