dcsimg
Storing a SELECT statement as a view
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Saturday, November 30, 2002 02:32 AM

How can I create a view for tables using the SELECT statement in Java

Re: Storing a SELECT statement as a view

Posted By:   AlessandroA_Garbagnati  
Posted On:   Saturday, November 30, 2002 11:05 AM

Hi,

A VIEW is a database "object", so you should create it on the database side.

There are some drivers that do not allow the execution of DDL statements, you maybe be able to create a view using the way to create them, that should be something like:

CREATE VIEW AS SELECT FROM


Check the database documentation to verify the syntax of the statement.

About | Sitemap | Contact