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
- 6055 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 |
What is a deadlock in SQL? How can you prevent it?
how to get second highest sal of emp table
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to store only time; not date and time?
what is the output of select * from emp where null=null & select * from emp where 1=1
What is a table index?
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
what is null value?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to define a cusotmer as a supplier in ORACLE R12
When do I need to use a semicolon vs a slash in oracle sql?
What are the composite date types in oracle?
Oracle General 
