0
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Will view drop if table drop?
If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.
What are user views in database?
A database View is a query which shows a portion of data in the database. It can be thought of as a virtual table. An example of a view would be one in which all attributes of an employee are returned as the result without salary details. Views are often used to provide "filtered" views of a database. A view can also hide the complexity of getting the correct data when a query is sent.
How many types of view in oracle?
There are two types of views in Oracle based upon from how many tables data are being fetched. 1. Simple view - In this view, data is coming from only one table. 2. Complex view - In this view, data comes from more than one table. That's it. However, Complex views have some limitations. For these follow Oracle documentation.
How do you create a query that will display the top five orders in descending order by order total?
To create a query that will display the top five orders in descending order by order total create a select query object. Open the query design table and select the top five orders, then choose to display them in descending order.
What is the different between a view and a create view?
View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).
What can use two different views to create a table?
In a database management system, you can use two different views to create a table by performing a union operation on the two views. This will combine the results of the two views into a single virtual table, allowing you to access the data from both views in one unified table.
Why do scientists have different views about the periodic table should be arranged?
because they have different opinions about each other
What is a display of data?
A visual display of data is called a chart, table or a graph.
What type of fountain makes a good table top display?
A type of fountain that makes a good table top display is statue water fountains that provide excellent design, quality, and service to make your table top display beautiful.
What is the time table of HSC Time Table February 2008?
just display time table
Why did America have different views about independence?
because they had different views
What is a frequency table used for?
To display data
What is Visual display of data?
A visual display of data is called a chart, table or a graph.
What is the timetable of Diploma 1th semester for msbte exam time table winter 2008?
when r exam time table gone be display. when r exam time table gone be display.
What makes a table top display visually appealing?
Table top displays can vary greatly. Some factors that can make a table top display more visually appealing include color and size. Incorporating animated (exciting) photos can draw in viewers to your display.
What type of control in a form can display data from database table?
A DataGridView control in a Windows Forms application can display data from a database table. You can bind the DataGridView to a data source such as a DataTable or a collection of objects, and it will automatically display the data from the database table in a tabular format.
To set the alignment of a table on a page display the table tab of dialog box?
table cell dialog box :)
