Java Doc for Function.java in  » Database-DBMS » h2database » org » h2 » expression » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » h2database » org.h2.expression   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.h2.expression.Expression       org.h2.expression.Function All known Subclasses:   org.h2.expression.TableFunction, Function public class Function extends Expression implements FunctionCall(Code) This class implements most built-in functions of this database. Field Summary final public static  int ABSACOSASINATANATAN2BITANDBITORBITXORCEILINGCOSCOTDEGREESEXPFLOORLOGLOG10MODPIPOWERRADIANSRANDROUNDROUNDMAGICSIGNSINSQRTTANTRUNCATESECURE_RANDHASHENCRYPTDECRYPTCOMPRESSEXPANDZERORANDOM_UUID      final public static  int ASCIIBIT_LENGTHCHARCHAR_LENGTHCONCATDIFFERENCEHEXTORAWINSERTINSTRLCASELEFTLENGTHLOCATELTRIMOCTET_LENGTHRAWTOHEXREPEATREPLACERIGHTRTRIMSOUNDEXSPACESUBSTRSUBSTRINGUCASELOWERUPPERPOSITIONTRIMSTRINGENCODESTRINGDECODESTRINGTOUTF8UTF8TOSTRINGXMLATTRXMLNODEXMLCOMMENTXMLCDATAXMLSTARTDOCXMLTEXTREGEXP_REPLACERPADLPAD      final public static  int CURDATECURTIMEDATEADDDATEDIFFDAYNAMEDAYOFMONTHDAYOFWEEKDAYOFYEARHOURMINUTEMONTHMONTHNAMENOWQUARTERSECONDWEEKYEARCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPEXTRACTFORMATDATETIMEPARSEDATETIME      final public static  int DATABASEUSERCURRENT_USERIDENTITYAUTOCOMMITREADONLYDATABASE_PATHLOCK_TIMEOUT      final public static  int IFNULLCASEWHENCONVERTCASTCOALESCENULLIFCASENEXTVALCURRVALARRAY_GETCSVREADCSVWRITEMEMORY_FREEMEMORY_USEDLOCK_MODESCHEMASESSION_IDARRAY_LENGTHLINK_SCHEMAGREATESTLEASTCANCEL_SESSIONSETTABLETABLE_DISTINCTFILE_READ      protected  Expression[] args      Constructor Summary protected   Function(Database database, FunctionInfo info)      Method Summary protected  void checkParameterCount(int len)      public  void doneWithParameters()      public  Expression[] getArgs()      public  int getCost()      public  int getDisplaySize()      public static  Function getFunction(Database database, String name)      public static  FunctionInfo getFunctionInfo(String name)      public  int getFunctionType()      public  String getName()      public  int getParameterCount()      public  long getPrecision()      public  String getSQL()      public  int getScale()      public  int getType()      public  Value getValue(Session session)      public  ValueResultSet getValueForColumnList(Session session, Expression[] args)      public  Value getValueWithArgs(Session session, Expression[] args)      public  boolean isEverything(ExpressionVisitor visitor)      public  void mapColumns(ColumnResolver resolver, int level)      public  Expression optimize(Session session)      public  void setDataType(int dataType, long precision, int scale, int displaySize)      Set the result data type of this function. public  void setDataType(Column col)      public  void setEvaluatable(TableFilter tableFilter, boolean b)      public  void setParameter(int index, Expression param)      public  void updateAggregate(Session session)      Field Detail ABSACOSASINATANATAN2BITANDBITORBITXORCEILINGCOSCOTDEGREESEXPFLOORLOGLOG10MODPIPOWERRADIANSRANDROUNDROUNDMAGICSIGNSINSQRTTANTRUNCATESECURE_RANDHASHENCRYPTDECRYPTCOMPRESSEXPANDZERORANDOM_UUID final public static int ABSACOSASINATANATAN2BITANDBITORBITXORCEILINGCOSCOTDEGREESEXPFLOORLOGLOG10MODPIPOWERRADIANSRANDROUNDROUNDMAGICSIGNSINSQRTTANTRUNCATESECURE_RANDHASHENCRYPTDECRYPTCOMPRESSEXPANDZERORANDOM_UUID(Code) ASCIIBIT_LENGTHCHARCHAR_LENGTHCONCATDIFFERENCEHEXTORAWINSERTINSTRLCASELEFTLENGTHLOCATELTRIMOCTET_LENGTHRAWTOHEXREPEATREPLACERIGHTRTRIMSOUNDEXSPACESUBSTRSUBSTRINGUCASELOWERUPPERPOSITIONTRIMSTRINGENCODESTRINGDECODESTRINGTOUTF8UTF8TOSTRINGXMLATTRXMLNODEXMLCOMMENTXMLCDATAXMLSTARTDOCXMLTEXTREGEXP_REPLACERPADLPAD final public static int ASCIIBIT_LENGTHCHARCHAR_LENGTHCONCATDIFFERENCEHEXTORAWINSERTINSTRLCASELEFTLENGTHLOCATELTRIMOCTET_LENGTHRAWTOHEXREPEATREPLACERIGHTRTRIMSOUNDEXSPACESUBSTRSUBSTRINGUCASELOWERUPPERPOSITIONTRIMSTRINGENCODESTRINGDECODESTRINGTOUTF8UTF8TOSTRINGXMLATTRXMLNODEXMLCOMMENTXMLCDATAXMLSTARTDOCXMLTEXTREGEXP_REPLACERPADLPAD(Code) CURDATECURTIMEDATEADDDATEDIFFDAYNAMEDAYOFMONTHDAYOFWEEKDAYOFYEARHOURMINUTEMONTHMONTHNAMENOWQUARTERSECONDWEEKYEARCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPEXTRACTFORMATDATETIMEPARSEDATETIME final public static int CURDATECURTIMEDATEADDDATEDIFFDAYNAMEDAYOFMONTHDAYOFWEEKDAYOFYEARHOURMINUTEMONTHMONTHNAMENOWQUARTERSECONDWEEKYEARCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPEXTRACTFORMATDATETIMEPARSEDATETIME(Code) DATABASEUSERCURRENT_USERIDENTITYAUTOCOMMITREADONLYDATABASE_PATHLOCK_TIMEOUT final public static int DATABASEUSERCURRENT_USERIDENTITYAUTOCOMMITREADONLYDATABASE_PATHLOCK_TIMEOUT(Code) IFNULLCASEWHENCONVERTCASTCOALESCENULLIFCASENEXTVALCURRVALARRAY_GETCSVREADCSVWRITEMEMORY_FREEMEMORY_USEDLOCK_MODESCHEMASESSION_IDARRAY_LENGTHLINK_SCHEMAGREATESTLEASTCANCEL_SESSIONSETTABLETABLE_DISTINCTFILE_READ final public static int IFNULLCASEWHENCONVERTCASTCOALESCENULLIFCASENEXTVALCURRVALARRAY_GETCSVREADCSVWRITEMEMORY_FREEMEMORY_USEDLOCK_MODESCHEMASESSION_IDARRAY_LENGTHLINK_SCHEMAGREATESTLEASTCANCEL_SESSIONSETTABLETABLE_DISTINCTFILE_READ(Code) args protected Expression[] args(Code) Constructor Detail Function protected Function(Database database, FunctionInfo info)(Code) Method Detail checkParameterCount protected void checkParameterCount(int len) throws SQLException(Code) doneWithParameters public void doneWithParameters() throws SQLException(Code) getArgs public Expression[] getArgs()(Code) getCost public int getCost()(Code) getDisplaySize public int getDisplaySize()(Code) getFunction public static Function getFunction(Database database, String name) throws SQLException(Code) getFunctionInfo public static FunctionInfo getFunctionInfo(String name)(Code) getFunctionType public int getFunctionType()(Code) getName public String getName()(Code) getParameterCount public int getParameterCount()(Code) getPrecision public long getPrecision()(Code) getSQL public String getSQL()(Code) getScale public int getScale()(Code) getType public int getType()(Code) getValue public Value getValue(Session session) throws SQLException(Code) getValueForColumnList public ValueResultSet getValueForColumnList(Session session, Expression[] args) throws SQLException(Code) getValueWithArgs public Value getValueWithArgs(Session session, Expression[] args) throws SQLException(Code) isEverything public boolean isEverything(ExpressionVisitor visitor)(Code) mapColumns public void mapColumns(ColumnResolver resolver, int level) throws SQLException(Code) optimize public Expression optimize(Session session) throws SQLException(Code) setDataType public void setDataType(int dataType, long precision, int scale, int displaySize)(Code) Set the result data type of this function. Parameters:   dataType - the data type Parameters:   precision - the precision Parameters:   scale - the scale Parameters:   displaySize - the display size setDataType public void setDataType(Column col)(Code) setEvaluatable public void setEvaluatable(TableFilter tableFilter, boolean b)(Code) setParameter public void setParameter(int index, Expression param) throws SQLException(Code) updateAggregate public void updateAggregate(Session session) throws SQLException(Code) Methods inherited from org.h2.expression.Expression public void addFilterConditions(TableFilter filter, boolean outerJoin)(Code)(Java Doc) public void createIndexConditions(Session session, TableFilter filter) throws SQLException(Code)(Java Doc) public String getAlias()(Code)(Java Doc) public Boolean getBooleanValue(Session session) throws SQLException(Code)(Java Doc) public String getColumnName()(Code)(Java Doc) abstract public int getCost()(Code)(Java Doc) abstract public int getDisplaySize()(Code)(Java Doc) public Expression getNonAliasExpression()(Code)(Java Doc) public Expression getNotIfPossible(Session session)(Code)(Java Doc) public int getNullable()(Code)(Java Doc) abstract public long getPrecision()(Code)(Java Doc) abstract public String getSQL()(Code)(Java Doc) abstract public int getScale()(Code)(Java Doc) public String getSchemaName()(Code)(Java Doc) public String getTableAlias()(Code)(Java Doc) public String getTableName()(Code)(Java Doc) abstract public int getType()(Code)(Java Doc) abstract public Value getValue(Session session) throws SQLException(Code)(Java Doc) public boolean isAutoIncrement()(Code)(Java Doc) public boolean isConstant()(Code)(Java Doc) abstract public boolean isEverything(ExpressionVisitor visitor)(Code)(Java Doc) final public boolean isEverything(int expressionVisitorType)(Code)(Java Doc) public boolean isValueSet()(Code)(Java Doc) public boolean isWildcard()(Code)(Java Doc) abstract public void mapColumns(ColumnResolver resolver, int level) throws SQLException(Code)(Java Doc) abstract public Expression optimize(Session session) throws SQLException(Code)(Java Doc) public Expression optimizeInJoin(Session session, Select select) throws SQLException(Code)(Java Doc) abstract public void setEvaluatable(TableFilter tableFilter, boolean value)(Code)(Java Doc) public String toString()(Code)(Java Doc) abstract public void updateAggregate(Session session) throws SQLException(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)