Questions tagged as 'sql-view'

2
answers

What 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 contain data itself. Okay, the documentat...
asked by 30.06.2016 / 17:23
2
answers

Is there performance gain when using View's in SQL?

The View 's are virtual tables, resulting from SQL queries, 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 View , but we can not edi...
asked by 15.07.2014 / 17:57
2
answers

Pass parameter in View

How do I pass a parameter to a view in MySQL? Using SQL Server just put WHERE u.nome = @nome that would solve the problem. Here is the view of the problem in SQL: CREATE VIEW 'view_conta_pessoa' AS SELECT p.nome, p.email FROM conta...
asked by 21.07.2015 / 21:31
4
answers

How do I create a sql view with more than two tables?

How to create a view sql , I need to get the name and password in the Magento DB that are in different tables, to authenticate in Moodle.     
asked by 03.02.2014 / 13:28
2
answers

MySQL Query - Count different table fields

I need to create a view in MySQL where I get the following result. Col1 | Col2 Total Tab1 | Total Tab2 I'm using UNION as follows, but the result comes as follows: col1 Page 201 Page 5699 CREATE VIEW 'dashboards' AS ( select...
asked by 16.11.2015 / 14:01
1
answer

How to execute a script before a view in sql server?

I created a view and it fetches information from an X table. However, this X table must be created in a select, before running the view, so that the data is updated. How can I create something in the sql server so that as soon as the user cli...
asked by 09.04.2015 / 16:02
2
answers

View with double SELECT from the same table

I need to mount a VIEW with three fields, but one depends on the other to be calculated (two of them are from the same table in different lines I need to "link" them), how do I add those fields in one place? The select's are as follows: SELECT...
asked by 23.04.2018 / 18:08
1
answer

PHP ORACLE VIEW FROM SELECT

I want to generate a view through a select with the code below, but it does not work, what can it be? $row[0] contains "select col1, col2, col3, col4, col5 from tabela1" $select= oci_parse($ora_conexao, 'SELECT *...
asked by 14.01.2016 / 17:39
1
answer

create view php / oracle

I want to generate a view through php for an oracle database where the select is done through the result of another query. This query mounts the select to the view: $sql1 = "SELECT TESTE FROM VIEW_TESTE"; $result1 = odbc_exec($conOraSql , $...
asked by 25.11.2015 / 18:06