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 Posted / 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 |
Post New Answer View All Answers
Is there any function in oracle similar like group_concat of mysql?
What happens to the current transaction if a ddl statement is executed?
What are the different types of record groups in oracle? Explain each of them
How to use "if" statements on multiple conditions?
what is the difference between data migration and production migration.
What is the recommended interval at which to run statspack snapshots, and why?
How to declare a local variable?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to use subqueries in the from clause in oracle?
Can we create trigger on materialized view in oracle?
Explain the use of log option in exp command.
What do you mean by merge in oracle?
What is data block in Oracle?
Explain the use of analyse option in exp command.
What are the varoius components of physical database structure of oracle database?