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 flashback Query ? And Use ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
when do u go for hash partitioning?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
How to end the current transaction in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is a Segment ?
What is the function of Optimizer ?
What is a connect identifier?
What WHERE CURRENT OF clause does in a cursor?