:: 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                      
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 (181)
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 
 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
# 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

Other Oracle General Interview Questions
  Question Asked @ Answers
Difference between sub query and nested query ? Keane-India-Ltd 17
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks. Excel 9
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??   1
how many triggers we can create on a table TCS 11
What are the factors causing the reparsing of SQL statements in SGA?   1
what are the different types of cursors? explain?   4
Who i will insert 1 lacks record in a Database table TCS 4
What is Private Database Link ?   1
what is the use of rank function?   1
which language is used to develop the oracle........? Infosys 4
What is an Index Segment ?   1
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X   1
For more Oracle General Interview Questions Click Here 

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