ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (718)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (264)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (180)
Question
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?
 Question Submitted By :: Krishna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1
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
Guest
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
how to retrieve 1st and last row of table without using group functions??   5
How do we know whether an index is created on a table ??? TCS 1
what is integrity constrains?   3
which statement is running fastly ie insert or delete? Oracle 13
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?   2
What is a Temporary Segment ?   2
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings   2
What is meant by recursive hints ?   1
what is host string in sql plus? how does it related to database?   1
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.   3
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ? Satyam 3
what is foreign key?   5
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com