Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 6038 Views
- Goldman Sachs, I also Faced
- E-Mail Answers
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 |
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How to call a stored function in oracle?
What is the difference between a hot backup and a cold backup in oracle?
Who i will insert 1 lacks record in a Database table
How do I connect to oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How do I limit the number of rows returned by an oracle query after ordering?
How to revoke create session privilege from a user in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is a Shared SQL pool ?
how to tune oracle sql queries pls tell me step by step. urgent pls
Oracle General 
