oracle.javatools.db

Class View

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractSystemObject

oracle.javatools.db.AbstractSchemaObject

oracle.javatools.db.Relation

oracle.javatools.db.View

All Implemented Interfaces:

DBObject, SchemaObject, SQLQueryOwner, SystemObject, Copyable, DynamicPropertySet

public class View
extends Relation
implements SQLQueryOwner

Represents a database View. Both declarative and non-declarative views are supported - the difference being their SQLQuery object (which is either just a wrapper for text, or a full parse tree depending on whether we can support the view syntax).

Since:

9.0.5

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	View.Restriction The restriction on the query for this view

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	CHECK_OPTION Deprecated. use #Restriction
static java.lang.String	READ_ONLY Deprecated. use #Restriction
static java.lang.String	TYPE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
View() Creates a new View.
View(java.lang.String name, Schema schema) Constructs a new View in the specified schema with the specified name.

Method Summary

Methods

Modifier and Type	Method and Description
Column[]	getColumns() Retrieves the list of columns contained in this relation.
java.lang.String	getQueryRestriction() Deprecated.
View.Restriction	getRestriction() Gets the query restriction for this view.
SQLQuery	getSQLQuery() Returns this view's query.
java.lang.String	getType() Returns the type of this object.
java.lang.String	getViewText() Convenience method that returns the view's query in text format.
boolean	isDeclarative() Convinience method to check whether this view has a declarative query.
boolean	isForceOnCreate() Returns true if this view should include the FORCE option on create.
void	setForceOnCreate(boolean force) Sets whether this view should include the FORCE option on create.
void	setQueryRestriction(java.lang.String restriction) Deprecated. replaced by setRestriction(oracle.javatools.db.View.Restriction)
void	setRestriction(View.Restriction restriction) Sets the query restriction for this view.
void	setSQLQuery(SQLQuery query) Sets this view's query.
void	setViewText(java.lang.String text) Convinience method that sets the view's query to a NonDeclarativeSQLQuery from the given text.

Methods inherited from class oracle.javatools.db.Relation

addColumn, addColumn, addConstraint, getColumn, getConstraint, getConstraints, getOwnedObjectsImpl, removeColumn, removeConstraint, setColumns, setConstraints

Methods inherited from class oracle.javatools.db.AbstractSchemaObject

getSchema, setSchema

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, copyToImpl, getProperties, getReferenceIDsImpl, needsInitialization

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperties, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperty, getProperty, setProperties, setProperty

Methods inherited from interface oracle.javatools.db.SchemaObject

addObjectListener, removeObjectListener

Methods inherited from interface oracle.javatools.db.SystemObject

addObjectListener, fireObjectUpdated, removeObjectListener

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

READ_ONLY

@Deprecated
public static final java.lang.String READ_ONLY

Deprecated. use #Restriction

Allowed value for the "query restriction" property.

See Also:

getQueryRestriction(), setQueryRestriction(java.lang.String), Constant Field Values

CHECK_OPTION

@Deprecated
public static final java.lang.String CHECK_OPTION

Deprecated. use #Restriction

Allowed value for the "query restriction" property.

See Also:

getQueryRestriction(), setQueryRestriction(java.lang.String), Constant Field Values

Constructor Detail

View

public View()

Creates a new View.

View

public View(java.lang.String name,
    Schema schema)

Constructs a new View in the specified schema with the specified name.

Parameters:

name - a string containing the name of the view

schema - the schema containing the view

Method Detail

getViewText

public java.lang.String getViewText()

Convenience method that returns the view's query in text format.

setViewText

public void setViewText(java.lang.String text)

Convinience method that sets the view's query to a NonDeclarativeSQLQuery from the given text.

getSQLQuery

public SQLQuery getSQLQuery()

Returns this view's query.

Specified by:

getSQLQuery in interface SQLQueryOwner

setSQLQuery

public void setSQLQuery(SQLQuery query)

Sets this view's query.

Specified by:

setSQLQuery in interface SQLQueryOwner

getColumns

public Column[] getColumns()

Description copied from class: Relation

Retrieves the list of columns contained in this relation.

Overrides:

getColumns in class Relation

Returns:

an array containing the list of columns

isDeclarative

public boolean isDeclarative()

Convinience method to check whether this view has a declarative query.

Specified by:

isDeclarative in interface SQLQueryOwner

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Returns:

a string describing the type of object.

getRestriction

public View.Restriction getRestriction()

Gets the query restriction for this view. Can be null, READ_ONLY or CHECK_OPTION.

setRestriction

public void setRestriction(View.Restriction restriction)

Sets the query restriction for this view. Can be null, READ_ONLY or CHECK_OPTION.

getQueryRestriction

@Deprecated
public java.lang.String getQueryRestriction()

Deprecated.

Gets the query restriction for this view. Can be null, READ_ONLY or CHECK_OPTION.

setQueryRestriction

@Deprecated
public void setQueryRestriction(java.lang.String restriction)

Deprecated. replaced by setRestriction(oracle.javatools.db.View.Restriction)

Sets the query restriction for this view. Can be null, READ_ONLY or CHECK_OPTION.

Throws:

java.lang.IllegalArgumentException - if the string parameter is not recognized as a valid Restriction.

isForceOnCreate

public boolean isForceOnCreate()

Returns true if this view should include the FORCE option on create.

setForceOnCreate

public void setForceOnCreate(boolean force)

Sets whether this view should include the FORCE option on create.