RDBMS - what is the difference bwtween view and join

GeekInterview.com > Tech FAQs > RDBMS

Go To First | Previous Question | Next Question

RDBMS | Question 14 of 18

what is the difference bwtween view and join

Total Answers and Comments: 5

Last Update: May 19, 2009 Asked by: sawee

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 03, 2007 01:22:20

nandeesh.keelara

Member Since: October 2006 Contribution: 18

RE: what is the difference bwtween view and join

View- it is result set obtained from Select statement.

Join- it is used to join the two related table

Is this answer useful? Yes | No

January 09, 2007 01:29:49

vmshenoy

Member Since: October 2005 Contribution: 508

RE: what is the difference bwtween view and join

view is a virtual table where data is not stored physically but give the convenient method to retrieve and manipulate the info as needed.done for SECURITY REASONS. helps make SIMPLE QUERIES.

Join is joining of two tables

Is this answer useful? Yes | No

March 22, 2007 14:48:09

RE: what is the difference bwtween view and join

View:View is a virtual table which is created by records from two or more tables.
syntax: create view viewname as select statement.

Join: Joins are used to retrive data from two very distinctive tables.

Is this answer useful? Yes | No

November 14, 2007 07:03:19

rajakumar_na

Member Since: November 2007 Contribution: 26

RE: what is the difference bwtween view and join

One more point is
View is a Schema Object
Join is not a schema object

Is this answer useful? Yes | No

May 18, 2009 16:14:17

NOTNULL

Member Since: May 2009 Contribution: 2

RE: what is the difference bwtween view and join

View is mainly created to provide security for the data and data definitions.

Mainly used to retrieve the data in a secure manner.
View cannot use space in the physical memory means virtually it will resides.

Join mainly used to join the data from two or more tables.
It is the RDBMS concept I mean not a
DBMS.
Join also resides in the virtual.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank