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 Posted / 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 |
Post New Answer View All Answers
What are the different types of failures that occur in Oracle database?
Explain a data segment?
does the query needs a hint to access a materialized view?
What is control file used for?
How to export several tables together?
Write a trigger example in oracle?
What is oracle update statement with inner join ?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the usage of synonyms?
What the is the diff between local index and global index. give some example.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Explain enable novalidate constraint.
Explain the function of optimizer in oracle?
How to export data to a csv file?