What is a View ?

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

  • Interview Candidate
  • 9
  • 2417

Showing Answers 1 - 9 of 9 Answers

sandeep vig

  • Oct 13th, 2005
 

a view is a just like a window so to acces specified data from a base table.a user can not access directly the table thus a view provides additional security.in addition a user  don,t have to write comlex queries on his end.

  Was this answer useful?  Yes

Sangeeta

  • Dec 27th, 2005
 

View is simply a JSP file.No flow logic,no business logic,no model information--just tags.

  Was this answer useful?  Yes

KIRAN BANDARI

  • Jan 31st, 2006
 

A view is a logical entity. It is a SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the database engine in the TEMP tablespace

  Was this answer useful?  Yes

Raghunath BhairavaJosula

  • Feb 23rd, 2006
 

A View is nothing but the presentation part to the client application with in a browser environment.It Will contain Both Static as well as Dynamic Content

  Was this answer useful?  Yes

sridharreddym

  • Apr 17th, 2006
 

Hi sangeetha,

thanks for giving the info.

please send me oracle apps faqs.

Thanks and regards,

sridhar reddy.

  Was this answer useful?  Yes

thumatinagaraju

  • Oct 24th, 2006
 

View is also a data base object which represent the subset of data from one or more tables.. when u select a view it internally refers the table on which it's created ,,when u drop a table the index on that table will be dropped ,, but the view can't dropped .......but if u want to drop view u can drop itdrop view ..;ok friends byeee

  Was this answer useful?  Yes

Mohamed Khaliqh

  • Jul 31st, 2007
 

Hi kiran,

Views stored in the database but it doesnt contain any data. In the runtime only it poputates the data. Also it doesnt have any queries.. it is created thru navigation only.. in program we have to use it as tables...

bye


  Was this answer useful?  Yes

C.Ramesh

  • Oct 17th, 2007
 

View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) it can be referesh methods like fast, complete.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions