What is the diffrence between select single * and Select
upto 1 row?
Answer Posted / chittidi
select single f1 f2 f3 ... into <wa> from <dbtab> where
<condition>. this where condition is important to fetch
exact record from database . for thsi purpose we provide
entire primary key combination in whrere conditon.
by using this statement to read exact information .
select f1 f2 f3 .... into <wa> from <dbtab> up to 1 rows
where <condition>
endselect.
it reads the first record found which may not be exact .
the where condition can be part of primary key combination.
it is mainly used to validate the INPUT.
IF WE ARE NOT PASSING ENTIRE COMBINATION OF PRIMARY KEY
IN SELET * SINGLE IT SIMPLY ACTS AS SELECT * UP TO 1 ROWS.
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Hi my dear friends,Please give the answers for the following link http://www.saptechnical.com/InterviewQ/interviewQ.htm
What is the project you are currently working and work that you are doing
What is the difference between internal tables and extract datasets? : abap modularization
What are the different abap editors? What is the used of different editors in abap?
How will you link form with the event driven in sap scripts?
What is the t-code to display batch input sessions? : abap bdc
What is gui status? How to create /edit gui status?
What are the field and chain statements?
How to creat transactions? : abap data dictionary
What is meant by payscale structure? How did you configure pay scale structure? : sap abap hr
Different types of luws. What are they?
What is singleton pattern in OOPS?
What are the functional areas? User groups?
What is bdc programming in sap?
What functions does a data dictionary perform ?