Share on Google+Share on Google+

Rekha Makwana
Advance DBMS
2 Answer(s)      6 years and 4 months ago
Posted in : SQL

What are views? Explain its various types?

Ads

View Answers

December 6, 2010 at 7:55 PM


Hi,

Database allows us to create abstract form of the data from different tables. This is done through views.

Read how to create view at Views in SQL tutorial page.

Thanks



December 16, 2010 at 3:02 PM


Hi,

views are used to create a temporary table..

ex: Select * from tablename as viewtable;










Related Tutorials/Questions & Answers:
Advance DBMS
Advance DBMS  What are views? Explain its various types?   Hi, Database allows us to create abstract form of the data from different tables. This is done through views. Read how to create view at Views in SQL
Advertisements
advance java
advance java  application to demonstrate email validator
Isolation level is used by the DBMS.
Isolation level is used by the DBMS.  What isolation level is used by the DBMS when inserting, updating and selecting rows from a database
dbms_change_notification new_reg_start
dbms_change_notification new_reg_start  Please explain it "dbmschangenotification newregstart" Thanks in advance
advance java
advance java  give the sourse code for sky high institute of management using j2ee
advance java
advance java  i want to refer advanced java book can u plz suggest me auther name   You can learn from the following books: 1)Advanced Java, Gajendra Gupta 2)Core servlets and JavaServer Pages,Marty Hall
Advance Java
Advance Java  Context ctx = new InitialContext(); if(ctx==null) { throw new RuntimeException("JNDI Context not Found"); } ds=(DataSource)ctx.lookup
advance java
advance java  what is servlet context?why its used?in what situation we should use it in our program?   Hi Friend, ServletContext is an interface that is defined in the javax.servlet package. It describes a set
Advanced DBMS questions
Advanced DBMS questions   Five company/organization that involves in SQL Server database migration. what is the Transaction Recovery Method. What does Cloud Computing contributes in the RDBMS? Importance
the isolation levels supported by my DBMS
the isolation levels supported by my DBMS  How can I determine the isolation levels supported by my DBMS
Ask DBMS Questions online
Ask DBMS Questions online       DBMS stands for Data Base Management System (DBMS) is a set of computer programs that controls the creation, organization
Advance Java Training Program
Advance Java Training Program  Hi, Can anyone guide me how to study advance Java in few day's  Please visit the following link: Java Tutorials Through the above link, you will get the links of advanced java tutorials
Advance Search in Servlet
Advance Search in Servlet  Sir, I have built an application where a user types a long string as input. Then after he/she types a single word of that string. I'm supposed to show all strings which have that word in them. Ex
Advance Search in Servlet
Advance Search in Servlet  Sir, I have built an application where a user types a long string as input. Then after he/she types a single word of that string. I'm supposed to show all strings which have that word in them. Ex
Advance Search in Servlet
Advance Search in Servlet  Sir, I have built an application where a user types a long string as input. Then after he/she types a single word of that string. I'm supposed to show all strings which have that word in them. Ex
Advance Search in Servlet
Advance Search in Servlet  Sir, I have built an application where a user types a long string as input. Then after he/she types a single word of that string. I'm supposed to show all strings which have that word in them. Ex
Advance and Core JAVA Topics
Advance and Core JAVA Topics  topics come under core java and topics come under advanced java?   Under Core Java, following topics comes: Fundamental OF OOPS Classes, Objects and Methods Arrays, String and Vectors
advance java question
advance java question  how to develop servlets without using any IDE such as netbeans..   Hello Friend, Follow these steps: Put servlet-api.jar inside the lib folder of apache tomcat. 1)create a servlet. import
Advance Java training topics
Advance Java training topics       1. Programming with Servlets & JSP JSP/Servlets  Training Course Objective
use JDBC to execute non-standard features that my DBMS provides.
use JDBC to execute non-standard features that my DBMS provides.  Can I use JDBC to execute non-standard features that my DBMS provides
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads