Advance DBMS

Advance DBMS

What are views? Explain its various types?

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.ADS_TO_REPLACE_1 Read how to create view
DBMS
Advertisements
DBMS
dbms
dbms
DBMS
DBMS
DBMS
DBMS
dbms_change_notification new_reg_start
dbms_change_notification new_reg_start  Please explain it "dbmschangenotification newregstart" Thanks in advance
advance java
advance java  application to demonstrate email validator
ModuleNotFoundError: No module named 'dbms'
ModuleNotFoundError: No module named 'dbms'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
ModuleNotFoundError: No module named 'dbms'
ModuleNotFoundError: No module named 'dbms'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
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
advance java
advance java  give the sourse code for sky high institute of management using j2ee
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  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  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? (adsbygoogle
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
ModuleNotFoundError: No module named 'advance'
ModuleNotFoundError: No module named 'advance'  Hi, My Python... 'advance' How to remove the ModuleNotFoundError: No module named 'advance... to install padas library. You can install advance python with following command
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
ModuleNotFoundError: No module named 'advance-touch'
ModuleNotFoundError: No module named 'advance-touch'  Hi, My... 'advance-touch' How to remove the ModuleNotFoundError: No module named 'advance-touch' error? Thanks   Hi, In your python
dbms - SQL
DBMs - SQL
Keys in DBMS
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
Advance Java training topics
Advance Java training topics       1. Programming with Servlets & JSP JSP/Servlets  Training Course Objective
Database Management System (DBMS)
Database Management System (DBMS) A Database Management System (DBMS) sometimes called a database manager or database system is a set... of the data. A DBMS is a system software package that ensures the integrity
ModuleNotFoundError: No module named 'pelican-advance-embed-tweet'
ModuleNotFoundError: No module named 'pelican-advance-embed-tweet'  ...: No module named 'pelican-advance-embed-tweet' How to remove the ModuleNotFoundError: No module named 'pelican-advance-embed-tweet' error? Thanks
ModuleNotFoundError: No module named 'trytond-sale-advance-payment'
ModuleNotFoundError: No module named 'trytond-sale-advance-payment'  ...: No module named 'trytond-sale-advance-payment' How to remove the ModuleNotFoundError: No module named 'trytond-sale-advance-payment' error
Online Advance Java Training Course
Online Advance Java Training Course Online Advance Java Training Course... describes how the advance Java is important for any software company, its future and the advance technologies which are important to learn with core Java
ModuleNotFoundError: No module named 'odoo12-addon-hr-expense-advance-clearing'
ModuleNotFoundError: No module named 'odoo12-addon-hr-expense-advance-clearing...: ModuleNotFoundError: No module named 'odoo12-addon-hr-expense-advance-clearing' How...-advance-clearing' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty'
ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty...: ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance
ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty'
ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty...: ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance-warranty' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-crm-rma-advance
how to output text from comboBox from first frame to textField on the second frame? please help me.. thank you in advance..
how to output text from comboBox from first frame to textField on the second frame? please help me.. thank you in advance..  how to output text from..... thank you in advance
Database Management System (DBMS)
Open Source DBMS
Open Source DBMS Open Source Database Management Systems The rapid... of its adopters.    Open source DBMS vendors Like other... evaluating several database software vendors, Holden chose MySQL DBMS (database
Advance Struts Action
Advance Struts2 Action In struts framework Action is responsible... is said to be advance which reduces the complexity of code, that implements... be obtained from its mapping. The framework provides some advance features
Advance (Enterprise) Features
Advance (Enterprise) Features       Clustering Clustering feature works with only JDBCJobStore. It include job fail-over and loaded - balancing. Setting up the "
Advance Java Training
Advance Java Training       1. Programming with Servlets & JSP JSP/Servlets  Training Course Objective
JAX-RPC Advance Concepts
JAX-RPC Advance Concepts       Project Requirement Make a web service program which can persists the records of a student
IBM Commits to Advance Apache Spark
IBM Commits to Advance Apache Spark IBM is now gearing innovation for Spark ecosystem as part of its commitment to driving new technologies in Big Data... this as open source IBM actually helped Databricks to advance machine learning

Ads