GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  SQR
Go To First  |  Previous Question  |  Next Question 
 SQR  |  Question 11 of 27    Print  
Difference between Prepared statement and Statement?

  
Total Answers and Comments: 2 Last Update: November 21, 2006     Asked by: Surya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 27, 2005 04:43:48   #1  
padma        

RE: Difference between Prepered statement and Statemen...

1) PREPARED statements r already pre-compiled whereas for STATEMENT each and every statement has to be compiled all the time..

2) If u want to execute a single SQL statement multiple number of times then go for PREPARED statement or else v can use STATEMENT.


 
Is this answer useful? Yes | No
November 21, 2006 10:56:31   #2  
Rajasekar        

RE: Difference between Prepered statement and Statemen...

Statement

Fixed parameter value

Execute every time

Prepared Statement

Can supply parameter value at execution time

Execute once for n parameter value

Callable Statement

To execute stored procedure like pl/sql


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : very good answer shakthivel.. ...

Latest Answer : StatementFixed parameter valueExecute every timePrepared StatementCan supply parameter value at execution timeExecute once for ‘n’ parameter valueCallable StatementTo execute stored procedure like pl/sql ...
Read Answers (2) | Asked by : Surya

Latest Answer : Inner join:  It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.Outerjoin:  This type of join returns all rows from one table and only those rows from a secondary table where ...
Read Answers (2) | Asked by : Ymai

Latest Answer : (1) Load-lookup:----------------------- 1) Load-lookup will be populated at compilation time 2) We can adjust the size of load-lookup 3) It is only for text datatype 4) We can only select two fields, but by string cancatnation we can select ...
Read Answers (3) | Asked by : Vikrant

Latest Answer : AE is very systematic as it is structured as Section, step and Action. While SQR is not systematic. AE flow is easy to read and understand, while SQR is not that easy. AE is easy to debug as you can do line by line debugging. With SQR it’s not ...
Read Answers (5) | Asked by : sheril

Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other? 
Latest Answer : Translate Table:            Translate table is a special kind of table that is limited to  validating data of four characters or less.The tranlate table serves as a universal prompt table and ...
Read Answers (1) | Asked by : mriaz


 Sponsored Links

 
Related Articles

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

What are the limitations with switch statement?

Switch statement is a powerful statement used to handle many alternatives and provides good presentation for C program. But there are some limitations with switch statement which are given below: Logical operators cannot be used with switch statement. For instance case k>=20: is not allowe
 

goto Statement

Why to avoid goto in C C has goto statement but one must ensure not to use too much of goto statement in their program because its functionality is limited and it is only recommended as a last resort if structured solutions are much more complicated. First let us understand the goto statement, its
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Difference between Scholarship and Grant

Difference between Scholarship and Grant While both scholarships and grants allow students to pay for their tuition without having to pay the money back there are a number of key differences between the two Knowing the difference between grants and scholarship will make it much easier for students t
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape