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 |
How to use null as conditions in oracle?
What is Library Cache in Oracle?
Does oracle partitioning improve performance?
What is the use of file param in imp command?
Does facebook use oracle?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
Define Normalization with example?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
what is Single Byte Overhead...?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
When a form is invoked with call_form, Does oracle forms issues a save point ?
how to hide the stored procedure inside a package