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 the database name in oracle?
What is a dynamic performance view in oracle?
What is oracle server autotrace in oracle?
How do we get field details of a table?
How to call a trigger inside a stored procedure?Give an example.
What is MTTR advisor in Oracle?
Is oracle a language?
What are the different approaches used by Optimizer in choosing an execution plan ?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain view?
Can we create trigger on materialized view in oracle?