what is the difference between table and veiw?
Answers were Sorted based on User's Feedback
Answer / rinku kharkia
table is physical presentation of database but view is
logicl presentation of database
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / udayah shankar dokku
Table: A table is defined as set of rows, a table
describes an entity.
View : view is a logical table ,which is defined as one or
more tables,a view is never stored in to database, when we
define view a view definition is stored in to dase
table,views are mainly used for security & information hiding
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / prasanna
Table will display the all columns,The table will be stored
in database. where as View is a virtual table that will not
stored in the database.The columns will be hiden while
giving the report to the users.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sanjay kumar
View is a virtual presentation of data of a one or more tables and view is strongly recommended about the security purpose but table has own space in database and present data as physically existence .
Is This Answer Correct ? | 1 Yes | 0 No |
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How do I recompile a procedure in oracle?
Can the query output be sorted by multiple columns in oracle?
How to estimate disk space needed for an export job?
Explain the different normalization forms?
Define Transaction ?
Explain an exception and its types?
What happens to the current transaction if the session is ended?
What to do if dba lost the system password?
How to define a variable to match a table column data type?
Explain the use of parfile option in exp command.
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.