Most voted "sql-view" questions
10 questions
Sort by count of
-
41
votes2
answers33649
viewsWhat are SQL views? What are the advantages and disadvantages of using?
From my research I learned that views in SQL, are like virtual tables results of stored searches of frequent access. To W3S defines essentially as: virtual table. It has to be said that views are…
-
15
votes2
answers7839
viewsWhat is the difference between View and Materialized View?
According to Oracle documentation, a Materialized View is a database object that contains the results of a query and a View is a logical table based on one or more tables or views and does not…
-
4
votes2
answers1134
viewsIs there a performance gain when using View’s in SQL?
As View's are virtual tables resulting from consultations SQL, as in the example: CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition From this, we can update or delete a…
-
4
votes2
answers8619
viewsPass parameter in View
How do I pass a parameter to a view in Mysql? Using SQL Server simply put WHERE u.nome = @nome that would solve the problem. Below is the view of the problem in SQL: CREATE VIEW `view_conta_pessoa`…
-
2
votes4
answers3156
viewsHow do I create an sql view with more than two tables?
How to create a view sql, I need to get the name and password in the Magento comic that are in different tables, to authenticate in Moodle.
-
1
votes1
answer1315
viewsHow to run a script before a view on sql server?
I created a view and it looks for information from an X table. Only this table X, must be created in a select, before executing the view, for the data to be updated. It has to create something in…
-
1
votes2
answers229
viewsMysql Query - Count separate table fields
I need to create a view in Mysql where return the following result. Col1 | Col2 Total Tab1 | Total Tab2 I am using UNION in the form below, but the result comes as follows: col1 201 5699 CREATE VIEW…
-
0
votes1
answer697
viewsPHP ORACLE VIEW FROM SELECT
I intend to generate a view through a select with the code below, but it doesn’t work, which may be? $row[0] contains "select col1, col2, col3, col4, col5 from tabela1" $select=…
-
0
votes2
answers1867
viewsView with double SELECT from the same table
I need to build a VIEW with three fields, but one depends on the other to be calculated (two of them are from the same table on different lines need "link them"), how do I aggregate these fields in…
-
0
votes1
answer62
viewscreate php/oracle view
I intend to generate a view through php to an oracle database where select is done through the result of another query. This query mounts select to view: $sql1 = "SELECT TESTE FROM VIEW_TESTE";…