Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and table ?
- 13 Answers
- 74596 Views
- Deloitte, Renault Nissan, I also Faced
- E-Mail Answers
Answer Posted / baskar
VIRTUAL is an important word to be used that matches for
defining a VIEW. View just holds a pre-compiled query which
pulls records from a table or combination of joined tables.
A view can also be used to query which can then be used in a
view. So to define, A VIEW is a virtual representation of
data from real tables/views which is pre-compiled and
secured. The retrieval of records would be quicker in a view
than a table based query. The main usage of view is to hide
few columns from the table which you may not want to share
with the users who wants only the required and relevant data.
TABLE is a normal real time table which really hold data in
the database.
Functionality wise, we may not pass variables in a view and
order by clause cannot be used in a view.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
In sap scripts, how will you link form with the event driven?
What is roll area?
What is a help view? : abap data dictionary
What is PS structure
How can we set the tablespaces and extent sizes ?
How do you write manual bdc session method? : abap bdc
What is the maximum number of structures that can be included in a table or structure : abap data dictionary
What are the features of abap/4 dictionary? : abap data dictionary
What are the different modes of processing batch input sessions? : abap bdc
hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks
5) How to rereive text elements in SF and script?
Explain the uses of the simple maintenance interface? : sap abap hr
How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?
What is the significance of hide?
What are the advantages of logical databases?
