SQLCreateMaterializedViewStatement (druid 1.2.6.2 API)

java.lang.Object
- com.shulie.druid.sql.ast.SQLObjectImpl
- - com.shulie.druid.sql.ast.SQLStatementImpl
  - - com.shulie.druid.sql.ast.statement.SQLCreateMaterializedViewStatement

所有已实现的接口:

SQLDbTypedObject, SQLObject, SQLReplaceable, SQLStatement, SQLCreateStatement, SQLDDLStatement, OracleSegmentAttributes
```
public class SQLCreateMaterializedViewStatement
extends SQLStatementImpl
implements OracleSegmentAttributes, SQLCreateStatement, SQLReplaceable
```
Created by wenshao on 30/06/2017.

字段概要

字段
限定符和类型	字段和说明
`protected SQLExpr`	`comment`
`protected List<SQLName>`	`distributedBy`
`protected SQLName`	`distributedByType`
`protected boolean`	`refreshOnOverWrite`
`protected SQLObject`	`storage`
`protected List<SQLTableElement>`	`tableElementList`
`protected List<SQLAssignItem>`	`tableOptions`
`protected SQLName`	`tablespace`

从类继承的字段 com.shulie.druid.sql.ast.SQLStatementImpl
afterSemi, dbType, headHints

从类继承的字段 com.shulie.druid.sql.ast.SQLObjectImpl
attributes, hint, parent, sourceColumn, sourceLine

构造器概要

构造器
构造器和说明

SQLCreateMaterializedViewStatement()

构造器
构造器和说明
`SQLCreateMaterializedViewStatement()`

方法概要

所有方法实例方法具体方法
限定符和类型	方法和说明
`protected void`	`accept0(SQLASTVisitor visitor)`
`void`	`addOption(String name, SQLExpr value)`
`Boolean`	`getCache()`
`List<SQLName>`	`getColumns()`
`SQLExpr`	`getComment()`
`Boolean`	`getCompress()`
`Integer`	`getCompressLevel()`
`List<SQLName>`	`getDistributedBy()`
`SQLName`	`getDistributedByType()`
`Boolean`	`getEnableQueryRewrite()`
`Integer`	`getFreeLists()`
`Integer`	`getInitrans()`
`Boolean`	`getLogging()`
`Integer`	`getMaxtrans()`
`SQLName`	`getName()`
`SQLExpr`	`getNext()`
`SQLExpr`	`getOption(String name)`
`Boolean`	`getParallel()`
`Integer`	`getParallelValue()`
`SQLPartitionBy`	`getPartitionBy()`
`Integer`	`getPctfree()`
`Integer`	`getPctincrease()`
`Integer`	`getPctthreshold()`
`Integer`	`getPctused()`
`SQLSelect`	`getQuery()`
`SQLExpr`	`getStartWith()`
`SQLObject`	`getStorage()`
`List<SQLTableElement>`	`getTableElementList()`
`List<SQLAssignItem>`	`getTableOptions()`
`SQLName`	`getTablespace()`
`boolean`	`isBuildDeferred()`
`boolean`	`isBuildImmediate()`
`boolean`	`isCompressForOltp()`
`boolean`	`isRefresh()`
`boolean`	`isRefreshComplete()`
`boolean`	`isRefreshFast()`
`boolean`	`isRefreshForce()`
`boolean`	`isRefreshNext()`
`boolean`	`isRefreshOnCommit()`
`boolean`	`isRefreshOnDemand()`
`boolean`	`isRefreshOnOverWrite()`
`boolean`	`isRefreshStartWith()`
`boolean`	`isWithRowId()`
`boolean`	`replace(SQLExpr expr, SQLExpr target)`
`void`	`setBuildDeferred(boolean buildDeferred)`
`void`	`setBuildImmediate(boolean buildImmediate)`
`void`	`setCache(Boolean cache)`
`void`	`setComment(SQLExpr comment)`
`void`	`setCompress(Boolean compress)`
`void`	`setCompressForOltp(boolean compressForOltp)`
`void`	`setCompressLevel(Integer compressLevel)`
`void`	`setDistributedByType(SQLName x)`
`void`	`setEnableQueryRewrite(Boolean enableQueryRewrite)`
`void`	`setFreeLists(Integer freeLists)`
`void`	`setInitrans(Integer initrans)`
`void`	`setLogging(Boolean logging)`
`void`	`setMaxtrans(Integer maxtrans)`
`void`	`setName(SQLName name)`
`void`	`setNext(SQLExpr x)`
`void`	`setParallel(Boolean parallel)`
`void`	`setParallelValue(Integer parallelValue)`
`void`	`setPartitionBy(SQLPartitionBy x)`
`void`	`setPctfree(Integer pctfree)`
`void`	`setPctincrease(Integer pctincrease)`
`void`	`setPctthreshold(Integer pctthreshold)`
`void`	`setPctused(Integer pctused)`
`void`	`setQuery(SQLSelect query)`
`void`	`setRefreshComplete(boolean refreshComplete)`
`void`	`setRefreshFast(boolean refreshFast)`
`void`	`setRefreshForce(boolean refreshForce)`
`void`	`setRefreshNext(boolean refreshNext)`
`void`	`setRefreshOnCommit(boolean refreshOnCommit)`
`void`	`setRefreshOnDemand(boolean refreshOnDemand)`
`void`	`setRefreshOnOverWrite(boolean refreshOnOverWrite)`
`void`	`setRefreshStartWith(boolean refreshStartWith)`
`void`	`setStartWith(SQLExpr x)`
`void`	`setStorage(SQLObject storage)`
`void`	`setTablespace(SQLName tablespace)`
`void`	`setWithRowId(boolean withRowId)`

从类继承的方法 com.shulie.druid.sql.ast.SQLStatementImpl
clone, getChildren, getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setDbType, setHeadHints, toLowerCaseString, toParameterizedString, toString, toString, toUnformattedString

从类继承的方法 com.shulie.druid.sql.ast.SQLObjectImpl
accept, acceptChild, acceptChild, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, computeDataType, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getHint, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, output, putAttribute, setHint, setParent, setSourceColumn, setSourceLine

从类继承的方法 java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

从接口继承的方法 com.shulie.druid.sql.ast.SQLStatement
getChildren, getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setHeadHints, toLowerCaseString, toParameterizedString, toString, toString

从接口继承的方法 com.shulie.druid.sql.ast.SQLObject
accept, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getParent, hasAfterComment, hasBeforeComment, output, output, putAttribute, setParent

字段详细资料

tablespace
```
protected SQLName tablespace
```

storage
```
protected SQLObject storage
```

refreshOnOverWrite
```
protected boolean refreshOnOverWrite
```

tableElementList

protected List<SQLTableElement> tableElementList

distributedByType
```
protected SQLName distributedByType
```

distributedBy
```
protected List<SQLName> distributedBy
```

tableOptions

protected final List<SQLAssignItem> tableOptions

comment
```
protected SQLExpr comment
```

构造器详细资料
- SQLCreateMaterializedViewStatement
```
public SQLCreateMaterializedViewStatement()
```

方法详细资料

getName
```
public SQLName getName()
```

setName
```
public void setName(SQLName name)
```

getColumns
```
public List<SQLName> getColumns()
```

getQuery
```
public SQLSelect getQuery()
```

setQuery

public void setQuery(SQLSelect query)

isBuildImmediate
```
public boolean isBuildImmediate()
```

setBuildImmediate

public void setBuildImmediate(boolean buildImmediate)

isBuildDeferred
```
public boolean isBuildDeferred()
```

setBuildDeferred

public void setBuildDeferred(boolean buildDeferred)

isRefresh
```
public boolean isRefresh()
```

isRefreshFast
```
public boolean isRefreshFast()
```

setRefreshFast

public void setRefreshFast(boolean refreshFast)

isRefreshComplete
```
public boolean isRefreshComplete()
```

setRefreshComplete

public void setRefreshComplete(boolean refreshComplete)

isRefreshForce
```
public boolean isRefreshForce()
```

setRefreshForce

public void setRefreshForce(boolean refreshForce)

isRefreshOnCommit
```
public boolean isRefreshOnCommit()
```

setRefreshOnCommit

public void setRefreshOnCommit(boolean refreshOnCommit)

isRefreshOnDemand
```
public boolean isRefreshOnDemand()
```

setRefreshOnDemand

public void setRefreshOnDemand(boolean refreshOnDemand)

isRefreshOnOverWrite
```
public boolean isRefreshOnOverWrite()
```

setRefreshOnOverWrite

public void setRefreshOnOverWrite(boolean refreshOnOverWrite)

isRefreshStartWith
```
public boolean isRefreshStartWith()
```

setRefreshStartWith

public void setRefreshStartWith(boolean refreshStartWith)

isRefreshNext
```
public boolean isRefreshNext()
```

setRefreshNext

public void setRefreshNext(boolean refreshNext)

getPctfree
```
public Integer getPctfree()
```
指定者:

getPctfree 在接口中 OracleSegmentAttributes

setPctfree
```
public void setPctfree(Integer pctfree)
```
指定者:

setPctfree 在接口中 OracleSegmentAttributes

getPctused
```
public Integer getPctused()
```
指定者:

getPctused 在接口中 OracleSegmentAttributes

setPctused
```
public void setPctused(Integer pctused)
```
指定者:

setPctused 在接口中 OracleSegmentAttributes

getInitrans
```
public Integer getInitrans()
```
指定者:

getInitrans 在接口中 OracleSegmentAttributes

setInitrans
```
public void setInitrans(Integer initrans)
```
指定者:

setInitrans 在接口中 OracleSegmentAttributes

getMaxtrans
```
public Integer getMaxtrans()
```
指定者:

getMaxtrans 在接口中 OracleSegmentAttributes

setMaxtrans
```
public void setMaxtrans(Integer maxtrans)
```
指定者:

setMaxtrans 在接口中 OracleSegmentAttributes

getPctincrease
```
public Integer getPctincrease()
```
指定者:

getPctincrease 在接口中 OracleSegmentAttributes

setPctincrease
```
public void setPctincrease(Integer pctincrease)
```
指定者:

setPctincrease 在接口中 OracleSegmentAttributes

getFreeLists
```
public Integer getFreeLists()
```

setFreeLists

public void setFreeLists(Integer freeLists)

getCompress
```
public Boolean getCompress()
```
指定者:

getCompress 在接口中 OracleSegmentAttributes

setCompress
```
public void setCompress(Boolean compress)
```
指定者:

setCompress 在接口中 OracleSegmentAttributes

getCompressLevel
```
public Integer getCompressLevel()
```
指定者:

getCompressLevel 在接口中 OracleSegmentAttributes

setCompressLevel
```
public void setCompressLevel(Integer compressLevel)
```
指定者:

setCompressLevel 在接口中 OracleSegmentAttributes

isCompressForOltp
```
public boolean isCompressForOltp()
```
指定者:

isCompressForOltp 在接口中 OracleSegmentAttributes

setCompressForOltp
```
public void setCompressForOltp(boolean compressForOltp)
```
指定者:

setCompressForOltp 在接口中 OracleSegmentAttributes

getPctthreshold
```
public Integer getPctthreshold()
```

setPctthreshold

public void setPctthreshold(Integer pctthreshold)

getLogging
```
public Boolean getLogging()
```
指定者:

getLogging 在接口中 OracleSegmentAttributes

setLogging
```
public void setLogging(Boolean logging)
```
指定者:

setLogging 在接口中 OracleSegmentAttributes

getTablespace
```
public SQLName getTablespace()
```
指定者:

getTablespace 在接口中 OracleSegmentAttributes

setTablespace
```
public void setTablespace(SQLName tablespace)
```
指定者:

setTablespace 在接口中 OracleSegmentAttributes

getStorage
```
public SQLObject getStorage()
```
指定者:

getStorage 在接口中 OracleSegmentAttributes

setStorage
```
public void setStorage(SQLObject storage)
```
指定者:

setStorage 在接口中 OracleSegmentAttributes

getParallel
```
public Boolean getParallel()
```

setParallel

public void setParallel(Boolean parallel)

getParallelValue
```
public Integer getParallelValue()
```

setParallelValue

public void setParallelValue(Integer parallelValue)

getEnableQueryRewrite

public Boolean getEnableQueryRewrite()

setEnableQueryRewrite

public void setEnableQueryRewrite(Boolean enableQueryRewrite)

getCache
```
public Boolean getCache()
```

setCache
```
public void setCache(Boolean cache)
```

getPartitionBy

public SQLPartitionBy getPartitionBy()

getTableElementList

public List<SQLTableElement> getTableElementList()

getDistributedBy

public List<SQLName> getDistributedBy()

getDistributedByType
```
public SQLName getDistributedByType()
```

setDistributedByType

public void setDistributedByType(SQLName x)

getStartWith
```
public SQLExpr getStartWith()
```

setStartWith
```
public void setStartWith(SQLExpr x)
```

getNext
```
public SQLExpr getNext()
```

setNext
```
public void setNext(SQLExpr x)
```

setPartitionBy

public void setPartitionBy(SQLPartitionBy x)

isWithRowId
```
public boolean isWithRowId()
```

setWithRowId

public void setWithRowId(boolean withRowId)

addOption

public void addOption(String name,
                      SQLExpr value)

getTableOptions

public List<SQLAssignItem> getTableOptions()

getOption

public SQLExpr getOption(String name)

getComment
```
public SQLExpr getComment()
```

setComment

public void setComment(SQLExpr comment)

accept0

protected void accept0(SQLASTVisitor visitor)

覆盖:: accept0 在类中 SQLStatementImpl

replace

public boolean replace(SQLExpr expr,
                       SQLExpr target)

指定者:: replace 在接口中 SQLReplaceable

类 SQLCreateMaterializedViewStatement

字段概要

从类继承的字段 com.shulie.druid.sql.ast.SQLStatementImpl

从类继承的字段 com.shulie.druid.sql.ast.SQLObjectImpl

构造器概要

方法概要

从类继承的方法 com.shulie.druid.sql.ast.SQLStatementImpl

从类继承的方法 com.shulie.druid.sql.ast.SQLObjectImpl

从类继承的方法 java.lang.Object

从接口继承的方法 com.shulie.druid.sql.ast.SQLStatement

从接口继承的方法 com.shulie.druid.sql.ast.SQLObject

字段详细资料

tablespace

storage

refreshOnOverWrite

tableElementList

distributedByType

distributedBy

tableOptions

comment

构造器详细资料

SQLCreateMaterializedViewStatement

方法详细资料

getName

setName

getColumns

getQuery

setQuery

isBuildImmediate

setBuildImmediate

isBuildDeferred

setBuildDeferred

isRefresh

isRefreshFast

setRefreshFast

isRefreshComplete

setRefreshComplete

isRefreshForce

setRefreshForce

isRefreshOnCommit

setRefreshOnCommit

isRefreshOnDemand

setRefreshOnDemand

isRefreshOnOverWrite

setRefreshOnOverWrite

isRefreshStartWith

setRefreshStartWith

isRefreshNext

setRefreshNext

getPctfree

setPctfree

getPctused

setPctused

getInitrans

setInitrans

getMaxtrans

setMaxtrans

getPctincrease

setPctincrease

getFreeLists

setFreeLists

getCompress

setCompress

getCompressLevel

setCompressLevel

isCompressForOltp

setCompressForOltp

getPctthreshold

setPctthreshold

getLogging

setLogging

getTablespace

setTablespace

getStorage

setStorage

getParallel

setParallel

getParallelValue

setParallelValue

getEnableQueryRewrite