Answer / kiran kumar v

Table comprises of rows and columns, columns representing
fields and rows containing the data or records.

View is a imaginay table which contains data at run time.

Answer / vani pushadapu

view is a virtual table based on the result-set of an SQL
statement.

A view contains rows and columns, just like a real table.
The fields in a view are fields from one or more real
tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a
view and present the data as if the data were coming from
one single table.

Answer / deepa

View is a virtual table. Like table it contains fields but
it does not contain any data.In run time it contains the
data and after that it gets free.But table stores the datas
in database occupy some space.

Answer / sana sharma

we cant have a views without having a table but we can have
a table without having a views.

views is a stored query where as table contain actual data

Answer / 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.

Answer / nagaraj

view is a imaginary table ,only view at runtime

Answer / sanjeev

View is a virtual table. It is similar to table. It
contains Fields like Table but it doesnot contain data.It
Contains the data at runtime only...

Table is nothing but a collection records(ie., collection
of rows and column)

Answer / guest

Table comprises of rows and columns, columns representing
fields and rows containing the data or records.

View is a imaginay table which contains data at run time.

Answer / tuhiram singh mca

table is collection of rows and columns it physical exist in
memory but view is aso collection of rows and columns in not
physical exiest in the memory it create at the run time .it
like as tempory table

Answer / hafiz ansari

A View is virtual base table database object which is
depend on the base table written in sql statements.

What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization

0 Answers  

what is advantages and disadvantages in call by value and call by reference

10 Answers   College School Exams Tests, Wipro,

hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

0 Answers  

what is the main use of package(in user exits ,in SMOD user can provide the package name for the purpose of to find out all user-exits,that package use iam asking)?

1 Answers   Intelligroup,

Difference between .Include and .append?

0 Answers  

​​What is amdp (abap managed data procedures)?​​

0 Answers  

What are the dynamic actions and how to configure it? : sap abap hr

0 Answers  

How to creat transactions? : abap data dictionary

0 Answers  

Which is the best institute for abap in ameerpet

7 Answers  

i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

0 Answers   NTT Data,

Normally how many and what files get created when a transaction program is written? what is the XXXXXTOP program?

0 Answers  

What are secondary indexes. How can we know which index is being used in a select query?

0 Answers   Infosys,