Top "Sql-view" questions

When using Toad to create a view in Oracle, how can I store the formatted script also?

This question may be Toad specific. I have no idea how Oracle stores views, so I'll explain what happens when …

oracle toad sql-view

Update a view doesn't work

I'm working on a view which is then updated by the user. This update basically changes the value of column. …

sql-server database tsql sql-view

What does 'vw' mean in this SQL statement?

What does vw mean in front of TournamentDetails? SELECT * FROM vwTournamentDetails WHERE firstname='@firstName' AND lastname='@lastName' AND …

sql sql-view

creating django model for existing database/sql view?

I have inserted a definition for a view in $template_dir/sql/$someTableName.sql file. (create or replace view) so …

django django-models sql-view

Using COALESCE in SQL view

I need to create a view from several tables. One of the columns in the view will have to be …

sql-server tsql sql-server-2008 coalesce sql-view

MySQL Views: Referencing one calculated field (by name) in another calculated field

How can I define a view that has two calculated fields, for instance... ('TableName'.'BlueSquares' + 'TableName'.'RedSquares') AS TotalSquares, ('TableName'.…

sql mysql calculated-columns sql-view

Prepend table name to each column in a result set in SQL? (Postgres specifically)

How can I get the label of each column in a result set to prepend the name if its table? …

sql postgresql dynamic-sql identifier sql-view

Why can't SQL Server alter a view in a stored procedure?

I'm using MS SQL Server, and I'd like to alter a view from within a stored procedure, by executing something …

sql sql-server stored-procedures alter-table sql-view

How can I see the Original MySQL used to create a view in phpMyAdmin or other program?

How can I see the original MySQL used to create a view in phpMyAdmin or other program? I am using …

mysql database phpmyadmin sql-view