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 |
Can you assign multiple query result rows to a variable?
What is the usage of save points in oracle database?
Explain the difference between replace() and translate() functions in oracle?
What privilege is needed for a user to query tables in another schema?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
how to unbreak sequence numbers during intereptions
How would you go about verifying the network name that the local_listener is currently using?
How to define an anonymous procedure without variables?
Define the terms primary key foreign key and also the difference between primary and the unique key
Explain what are the type of synonyms?
What are triggers in oracle?
When do you get a .pll extension in oracle? Explain its importance