| product name | SchemaCrawler |
| product version | 7.6 |
| database product name | HSQL Database Engine |
| database product version | 1.8.0 |
| database user name | SA |
| all procedures are callable | true |
| all tables are selectable | true |
| catalog separator | |
| catalog term | |
| catalogs | |
| data definition causes transaction commit | true |
| data definition ignored in transactions | false |
| database major version | 1 |
| database minor version | 8 |
| default transaction isolation | 1 |
| deletes are detected for TYPE_FORWARD_ONLY result sets | false |
| deletes are detected for TYPE_SCROLL_INSENSITIVE result sets | false |
| deletes are detected for TYPE_SCROLL_SENSITIVE result sets | false |
| does max row size include blobs | true |
| driver major version | 1 |
| driver minor version | 8 |
| extra name characters | |
| identifier quote string | " |
| inserts are detected for TYPE_FORWARD_ONLY result sets | false |
| inserts are detected for TYPE_SCROLL_INSENSITIVE result sets | false |
| inserts are detected for TYPE_SCROLL_SENSITIVE result sets | false |
| is catalog at start | false |
| is read only | false |
| JDBC major version | 3 |
| JDBC minor version | 0 |
| locators update copy | false |
| max binary literal length | 0 |
| max catalog name length | 0 |
| max char literal length | 0 |
| max column name length | 0 |
| max columns in group by | 0 |
| max columns in index | 0 |
| max columns in order by | 0 |
| max columns in select | 0 |
| max columns in table | 0 |
| max connections | 0 |
| max cursor name length | 0 |
| max index length | 0 |
| max procedure name length | 0 |
| max row size | 0 |
| max schema name length | 0 |
| max statement length | 0 |
| max statements | 0 |
| max table name length | 0 |
| max tables in select | 0 |
| max user name length | 0 |
| null plus non null is null | true |
| nulls are sorted at end | false |
| nulls are sorted at start | false |
| nulls are sorted high | false |
| nulls are sorted low | true |
| numeric functions | ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN, TRUNCATE, BITAND, BITOR, BITXOR, ROUNDMAGIC |
| others inserts are visible for TYPE_FORWARD_ONLY result sets | false |
| others inserts are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| others inserts are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| others updates are visible for TYPE_FORWARD_ONLY result sets | false |
| others updates are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| others updates are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own deletes are visible for TYPE_FORWARD_ONLY result sets | false |
| own deletes are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own deletes are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own inserts are visible for TYPE_FORWARD_ONLY result sets | false |
| own inserts are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own inserts are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| own updates are visible for TYPE_FORWARD_ONLY result sets | false |
| own updates are visible for TYPE_SCROLL_INSENSITIVE result sets | false |
| own updates are visible for TYPE_SCROLL_SENSITIVE result sets | false |
| procedure term | |
| result set holdability | 1 |
| schema term | SCHEMA |
| schemas | INFORMATION_SCHEMA, PUBLIC, SCHEMACRAWLER |
| search string escape | \ |
| SQL keywords | BEFORE, BIGINT, BINARY, CACHED, DATETIME, LIMIT, LONGVARBINARY, LONGVARCHAR, OBJECT, OTHER, SAVEPOINT, TEMP, TEXT, TOP, TRIGGER, TINYINT, VARBINARY, VARCHAR_IGNORECASE |
| SQL state type | 2 |
| stores lower case identifiers | false |
| stores lower case quoted identifiers | false |
| stores mixed case identifiers | false |
| stores mixed case quoted identifiers | false |
| stores upper case identifiers | true |
| stores upper case quoted identifiers | false |
| string functions | ASCII, BIT_LENGTH, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, CONCAT, DIFFERENCE, HEXTORAW, INSERT, LCASE, LEFT, LENGTH, LOCATE, LTRIM, OCTET_LENGTH, RAWTOHEX, REPEAT, REPLACE, RIGHT, RTRIM, SOUNDEX, SPACE, SUBSTR, SUBSTRING, UCASE, LOWER, UPPER |
| supports alter table with add column | true |
| supports alter table with drop column | true |
| supports ANSI92 entry level SQL | false |
| supports ANSI92 full SQL | false |
| supports ANSI92 intermediate SQL | false |
| supports batch updates | true |
| supports catalogs in data manipulation | false |
| supports catalogs in index definitions | false |
| supports catalogs in privilege definitions | false |
| supports catalogs in procedure calls | false |
| supports catalogs in table definitions | false |
| supports column aliasing | true |
| supports convert | true |
| supports core SQL grammar | true |
| supports correlated subqueries | true |
| supports data definition and data manipulation transactions | false |
| supports data manipulation transactions only | true |
| supports different table correlation names | true |
| supports expressions in order by | true |
| supports extended SQL grammar | false |
| supports full outer joins | false |
| supports get generated keys | false |
| supports group by | true |
| supports group by beyond select | true |
| supports group by unrelated | true |
| supports integrity enhancement facility | true |
| supports like escape clause | true |
| supports limited outer joins | true |
| supports minimum SQL grammar | false |
| supports mixed case identifiers | false |
| supports mixed case quoted identifiers | true |
| supports multiple open results | false |
| supports multiple result sets | false |
| supports multiple transactions | true |
| supports named parameters | true |
| supports non nullable columns | true |
| supports open cursors across commit | false |
| supports open cursors across rollback | false |
| supports open statements across commit | true |
| supports open statements across rollback | true |
| supports order by unrelated | true |
| supports outer joins | true |
| supports positioned delete | false |
| supports positioned update | false |
| supports result set type for TYPE_FORWARD_ONLY result sets | true |
| supports result set type for TYPE_SCROLL_INSENSITIVE result sets | true |
| supports result set type for TYPE_SCROLL_SENSITIVE result sets | false |
| supports savepoints | true |
| supports schemas in data manipulation | false |
| supports schemas in index definitions | true |
| supports schemas in privilege definitions | true |
| supports schemas in procedure calls | false |
| supports schemas in table definitions | true |
| supports select for update | false |
| supports statement pooling | false |
| supports stored procedures | true |
| supports subqueries in comparisons | true |
| supports subqueries in exists | true |
| supports subqueries in ins | true |
| supports subqueries in quantifieds | true |
| supports table correlation names | true |
| supports transactions | true |
| supports union | true |
| supports union all | true |
| system functions | DATABASE, USER, IDENTITY |
| table types | GLOBAL TEMPORARY, SYSTEM TABLE, TABLE, VIEW |
| time date functions | CURDATE, CURTIME, DATEDIFF, DAYNAME, DAY, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, MONTHNAME, NOW, QUARTER, SECOND, WEEK, YEAR, TO_CHAR |
| type info | TINYINT, BIGINT, LONGVARBINARY, VARBINARY, BINARY, LONGVARCHAR, CHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, FLOAT, REAL, DOUBLE, VARCHAR, VARCHAR_IGNORECASE, BOOLEAN, DATE, TIME, TIMESTAMP, OTHER |
| uses local file per table | false |
| uses local files | false |
| driver name | HSQL Database Engine Driver |
| driver version | 1.8.0 |
| driver class name | org.hsqldb.jdbcDriver |
| url | jdbc:hsqldb:hsql://localhost:9001/schemacrawler |
| is JDBC compliant | false |
| user | [driver property] | |
| required | ||
| value | null | |
| password | [driver property] | |
| required | ||
| value | null | |
| get_column_name | [driver property] | |
| not required; choices [true, false] | ||
| value | true | |
| ifexists | [driver property] | |
| not required; choices [true, false] | ||
| value | null | |
| default_schema | [driver property] | |
| not required; choices [true, false] | ||
| value | null | |
| shutdown | [driver property] | |
| not required; choices [true, false] | ||
| value | null | |
| BIGINT | [data type] | |
| based on | BIGINT | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable | ||
| BINARY | [data type] | |
| based on | BINARY | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| BOOLEAN | [data type] | |
| based on | BOOLEAN | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| CHAR | [data type] | |
| based on | CHAR | |
| not user defined | ||
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| DATE | [data type] | |
| based on | DATE | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| DECIMAL | [data type] | |
| based on | DECIMAL | |
| not user defined | ||
| defined with PRECISION,SCALE | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| DOUBLE | [data type] | |
| based on | DOUBLE | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| FLOAT | [data type] | |
| based on | FLOAT | |
| not user defined | ||
| defined with PRECISION | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| INTEGER | [data type] | |
| based on | INTEGER | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| auto-incrementable | ||
| searchable | ||
| LONGVARBINARY | [data type] | |
| based on | LONGVARBINARY | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| LONGVARCHAR | [data type] | |
| based on | LONGVARCHAR | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| NUMERIC | [data type] | |
| based on | NUMERIC | |
| not user defined | ||
| defined with PRECISION,SCALE | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| OTHER | [data type] | |
| based on | OTHER | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| not searchable | ||
| REAL | [data type] | |
| based on | REAL | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| SMALLINT | [data type] | |
| based on | SMALLINT | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| TIME | [data type] | |
| based on | TIME | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| TIMESTAMP | [data type] | |
| based on | TIMESTAMP | |
| not user defined | ||
| defined with PRECISION | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| TINYINT | [data type] | |
| based on | TINYINT | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| VARBINARY | [data type] | |
| based on | VARBINARY | |
| not user defined | ||
| defined with no parameters | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| VARCHAR | [data type] | |
| based on | VARCHAR | |
| not user defined | ||
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| VARCHAR_IGNORECASE | [data type] | |
| based on | VARCHAR | |
| not user defined | ||
| defined with LENGTH | ||
| nullable | ||
| not auto-incrementable | ||
| searchable | ||
| PUBLIC.CUSTOMER | [table] | ||
| ID | INTEGER not null | ||
| FIRSTNAME | VARCHAR(255) | ||
| LASTNAME | VARCHAR(255) | ||
| STREET | VARCHAR(255) | ||
| CITY | VARCHAR(255) | ||
| SYS_IDX_46 | [primary key] | ||
| ID | ascending | ||
| FK_INVOICE_CUSTOMER | [foreign key, with no action] | ||
| ID → PUBLIC.INVOICE.CUSTOMERID | |||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.CUSTOMERLIST | [view] | ||
| ID | INTEGER | ||
| FIRSTNAME | VARCHAR(255) | ||
| LASTNAME | VARCHAR(255) | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.INVOICE | [table] | ||
| ID | INTEGER not null | ||
| CUSTOMERID | INTEGER | ||
| TOTAL | FLOAT(17, 0) | ||
| SYS_IDX_48 | [primary key] | ||
| ID | ascending | ||
| FK_INVOICE_CUSTOMER | [foreign key, with no action] | ||
| PUBLIC.CUSTOMER.ID → CUSTOMERID | |||
| FK_B_ITEM_INVOICE | [foreign key, with no action] | ||
| ID → PUBLIC.ITEM.INVOICEID | |||
| INDEX_INVOICE_CUSTOMER | [non-unique index] | ||
| CUSTOMERID | ascending | ||
| SYS_IDX_50 | [non-unique index] | ||
| CUSTOMERID | ascending | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.ITEM | [table] | ||
| INVOICEID | INTEGER not null | ||
| ITEM | INTEGER not null | ||
| PRODUCTID | INTEGER | ||
| QUANTITY | INTEGER | ||
| COST | FLOAT(17, 0) | ||
| SYS_IDX_52 | [primary key] | ||
| INVOICEID | ascending | ||
| ITEM | ascending | ||
| FK_B_ITEM_INVOICE | [foreign key, with no action] | ||
| PUBLIC.INVOICE.ID → INVOICEID | |||
| FK_A_ITEM_PRODUCT | [foreign key, with no action] | ||
| PUBLIC.PRODUCT.ID → PRODUCTID | |||
| INDEX_ITEM_INVOICE | [non-unique index] | ||
| INVOICEID | ascending | ||
| SYS_IDX_53 | [non-unique index] | ||
| INVOICEID | ascending | ||
| INDEX_ITEM_PRODUCT | [non-unique index] | ||
| PRODUCTID | ascending | ||
| SYS_IDX_55 | [non-unique index] | ||
| PRODUCTID | ascending | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.PRODUCT | [table] | ||
| ID | INTEGER not null | ||
| NAME | VARCHAR(255) | ||
| PRICE | FLOAT(17, 0) | ||
| SYS_IDX_47 | [primary key] | ||
| ID | ascending | ||
| FK_A_ITEM_PRODUCT | [foreign key, with no action] | ||
| ID → PUBLIC.ITEM.PRODUCTID | |||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.SUPPLIER | [table] | ||
| SUPPLIER_ID | INTEGER | ||
| SUPPLIER_NAME | VARCHAR(255) | ||
| INDEX_B_SUPPLIER | [non-unique index] | ||
| SUPPLIER_ID | ascending | ||
| SUPPLIER_NAME | ascending | ||
| INDEX_A_SUPPLIER | [non-unique index] | ||
| SUPPLIER_NAME | ascending | ||
| SUPPLIER_ID | ascending | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| SCHEMACRAWLER.ITEM | [table] | ||
| INVOICEID | INTEGER not null | ||
| ITEM | INTEGER not null | ||
| PRODUCTID | INTEGER | ||
| QUANTITY | INTEGER | ||
| COST | FLOAT(17, 0) | ||
| SYS_IDX_59 | [primary key] | ||
| INVOICEID | ascending | ||
| ITEM | ascending | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| SCHEMACRAWLER.PRODUCT2 | [table] | ||
| ID | INTEGER not null | ||
| NAME | VARCHAR(255) | ||
| PRICE | FLOAT(17, 0) | ||
| SYS_IDX_61 | [primary key] | ||
| ID | ascending | ||
| DELETE | [privilege] | ||
| DBA → SA (grantable) | |||
| INSERT | [privilege] | ||
| DBA → SA (grantable) | |||
| SELECT | [privilege] | ||
| DBA → SA (grantable) | |||
| UPDATE | [privilege] | ||
| DBA → SA (grantable) | |||
| PUBLIC.PRODUCT.ID → SCHEMACRAWLER.ITEM.PRODUCTID | ||
| PUBLIC.INVOICE.ID → SCHEMACRAWLER.ITEM.INVOICEID |
| PUBLIC.ABS | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.ACOS | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.ASCII | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.ASIN | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.ATAN | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.ATAN2 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.BIT_LENGTH | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.BITAND | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.BITOR | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.BITXOR | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.CEILING | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.CHAR | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.CHAR_LENGTH | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.CHARACTER_LENGTH | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.CONCAT | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.COS | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.COT | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.CURDATE | [procedure, returns result] | ||
| @p0 | DATE, result | ||
| PUBLIC.CURTIME | [procedure, returns result] | ||
| @p0 | TIME, result | ||
| PUBLIC.DATABASE | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.DATEDIFF | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | TIMESTAMP, in | ||
| @p3 | TIMESTAMP, in | ||
| @p0 | BIGINT, result | ||
| PUBLIC.DAY | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.DAYNAME | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.DAYOFMONTH | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.DAYOFWEEK | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.DAYOFYEAR | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.DEGREES | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.DIFFERENCE | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.EXP | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.FLOOR | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.HEXTORAW | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.HOUR | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.IDENTITY | [procedure, returns result] | ||
| @p0 | INTEGER, result | ||
| PUBLIC.INSERT | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p3 | INTEGER, in | ||
| @p4 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.java.lang.Math.abs | [procedure, returns result] | ||
| @p1 | BIGINT, in | ||
| @p0 | BIGINT, result | ||
| PUBLIC.java.lang.Math.acos | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.asin | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.atan | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.atan2 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.cbrt | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.ceil | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.copySign | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p2 | FLOAT(8, 17), in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.java.lang.Math.cos | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.cosh | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.exp | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.expm1 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.floor | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.getExponent | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.java.lang.Math.hypot | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.IEEEremainder | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.log | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.log10 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.log1p | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.max | [procedure, returns result] | ||
| @p1 | BIGINT, in | ||
| @p2 | BIGINT, in | ||
| @p0 | BIGINT, result | ||
| PUBLIC.java.lang.Math.min | [procedure, returns result] | ||
| @p1 | BIGINT, in | ||
| @p2 | BIGINT, in | ||
| @p0 | BIGINT, result | ||
| PUBLIC.java.lang.Math.nextAfter | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.java.lang.Math.nextUp | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.java.lang.Math.pow | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.random | [procedure, returns result] | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.rint | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.round | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.java.lang.Math.scalb | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p2 | INTEGER, in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.java.lang.Math.signum | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.java.lang.Math.sin | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.sinh | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.sqrt | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.tan | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.tanh | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.toDegrees | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.toRadians | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.java.lang.Math.ulp | [procedure, returns result] | ||
| @p1 | FLOAT(8, 17), in | ||
| @p0 | FLOAT(8, 17), result | ||
| PUBLIC.LCASE | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.LEFT | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.LENGTH | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.LOCATE | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p3 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.LOG | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.LOG10 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.LOWER | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.LTRIM | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.MINUTE | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.MOD | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.MONTH | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.MONTHNAME | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.NOW | [procedure, returns result] | ||
| @p0 | TIMESTAMP, result | ||
| PUBLIC.OCTET_LENGTH | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.abs | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.ascii | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.bitand | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.bitLength | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.bitor | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.bitxor | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.character | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.concat | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.cot | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.curdate | [procedure, returns result] | ||
| @p0 | DATE, result | ||
| PUBLIC.org.hsqldb.Library.curtime | [procedure, returns result] | ||
| @p0 | TIME, result | ||
| PUBLIC.org.hsqldb.Library.database | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.datediff | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | TIMESTAMP, in | ||
| @p3 | TIMESTAMP, in | ||
| @p0 | BIGINT, result | ||
| PUBLIC.org.hsqldb.Library.dayname | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.dayofmonth | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.dayofweek | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.dayofyear | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.difference | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.getAutoCommit | [procedure, returns result] | ||
| @p0 | BOOLEAN, result | ||
| PUBLIC.org.hsqldb.Library.getDatabaseFullProductVersion | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.getDatabaseMajorVersion | [procedure, returns result] | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.getDatabaseMinorVersion | [procedure, returns result] | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.getDatabaseProductName | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.getDatabaseProductVersion | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.hexToRaw | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.hour | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.identity | [procedure, returns result] | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.insert | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p3 | INTEGER, in | ||
| @p4 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.isReadOnlyConnection | [procedure, returns result] | ||
| @p0 | BOOLEAN, result | ||
| PUBLIC.org.hsqldb.Library.isReadOnlyDatabase | [procedure, returns result] | ||
| @p0 | BOOLEAN, result | ||
| PUBLIC.org.hsqldb.Library.isReadOnlyDatabaseFiles | [procedure, returns result] | ||
| @p0 | BOOLEAN, result | ||
| PUBLIC.org.hsqldb.Library.lcase | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.left | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.length | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.locate | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p3 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.log10 | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.ltrim | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.minute | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.mod | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p2 | INTEGER, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.month | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.monthname | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.now | [procedure, returns result] | ||
| @p0 | TIMESTAMP, result | ||
| PUBLIC.org.hsqldb.Library.octetLength | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.pi | [procedure, returns result] | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.position | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.quarter | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.rand | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.rawToHex | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.repeat | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.replace | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p3 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.right | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.round | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | INTEGER, in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.roundMagic | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.rtrim | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.second | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.sign | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.soundex | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.space | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.substring | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p3 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.to_char | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.trim | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p3 | BOOLEAN, in | ||
| @p4 | BOOLEAN, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.truncate | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | INTEGER, in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.org.hsqldb.Library.ucase | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.user | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.org.hsqldb.Library.week | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.org.hsqldb.Library.year | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.PI | [procedure, returns result] | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.POWER | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.QUARTER | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.RADIANS | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.RAND | [procedure, returns result] | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.RAWTOHEX | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.REPEAT | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.REPLACE | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p3 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.RIGHT | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.ROUND | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | INTEGER, in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.ROUNDMAGIC | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.RTRIM | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.SECOND | [procedure, returns result] | ||
| @p1 | TIME, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.SIGN | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.SIN | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.SOUNDEX | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.SPACE | [procedure, returns result] | ||
| @p1 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.SQRT | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.SUBSTR | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p3 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.SUBSTRING | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p2 | INTEGER, in | ||
| @p3 | INTEGER, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.TAN | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.TO_CHAR | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p2 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.TRUNCATE | [procedure, returns result] | ||
| @p1 | DOUBLE(8, 17), in | ||
| @p2 | INTEGER, in | ||
| @p0 | DOUBLE(8, 17), result | ||
| PUBLIC.UCASE | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.UPPER | [procedure, returns result] | ||
| @p1 | LONGVARCHAR, in | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.USER | [procedure, returns result] | ||
| @p0 | LONGVARCHAR, result | ||
| PUBLIC.WEEK | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.YEAR | [procedure, returns result] | ||
| @p1 | DATE, in | ||
| @p0 | INTEGER, result | ||
| PUBLIC.CUSTOMER | 50 rows | |
| PUBLIC.CUSTOMERLIST | 50 rows | |
| PUBLIC.INVOICE | 50 rows | |
| PUBLIC.ITEM | 650 rows | |
| PUBLIC.PRODUCT | 50 rows | |
| PUBLIC.SUPPLIER | 1 rows | |
| SCHEMACRAWLER.ITEM | 20 rows | |
| SCHEMACRAWLER.PRODUCT2 | 11 rows | |
| ID | FIRSTNAME | LASTNAME | STREET | CITY |
| 0 | Laura | Steel | 429 Seventh Av. | Dallas |
| 1 | Susanne | King | 366 - 20th Ave. | Olten |
| 2 | Anne | Miller | 20 Upland Pl. | Lyon |
| 3 | Michael | Clancy | 542 Upland Pl. | San Francisco |
| 4 | Sylvia | Ringer | 365 College Av. | Dallas |
| 5 | Laura | Miller | 294 Seventh Av. | Paris |
| 6 | Laura | White | 506 Upland Pl. | Palo Alto |
| 7 | James | Peterson | 231 Upland Pl. | San Francisco |
| 8 | Andrew | Miller | 288 - 20th Ave. | Seattle |
| 9 | James | Schneider | 277 Seventh Av. | Berne |
| 10 | Anne | Fuller | 135 Upland Pl. | Dallas |
| 11 | Julia | White | 412 Upland Pl. | Chicago |
| 12 | George | Ott | 381 Upland Pl. | Palo Alto |
| 13 | Laura | Ringer | 38 College Av. | New York |
| 14 | Bill | Karsen | 53 College Av. | Oslo |
| 15 | Bill | Clancy | 319 Upland Pl. | Seattle |
| 16 | John | Fuller | 195 Seventh Av. | New York |
| 17 | Laura | Ott | 443 Seventh Av. | Lyon |
| 18 | Sylvia | Fuller | 158 - 20th Ave. | Paris |
| 19 | Susanne | Heiniger | 86 - 20th Ave. | Dallas |
| 20 | Janet | Schneider | 309 - 20th Ave. | Oslo |
| 21 | Julia | Clancy | 18 Seventh Av. | Seattle |
| 22 | Bill | Ott | 250 - 20th Ave. | Berne |
| 23 | Julia | Heiniger | 358 College Av. | Boston |
| 24 | James | Sommer | 333 Upland Pl. | Olten |
| 25 | Sylvia | Steel | 269 College Av. | Paris |
| 26 | James | Clancy | 195 Upland Pl. | Oslo |
| 27 | Bob | Sommer | 509 College Av. | Seattle |
| 28 | Susanne | White | 74 - 20th Ave. | Lyon |
| 29 | Andrew | Smith | 254 College Av. | New York |
| 30 | Bill | Sommer | 362 - 20th Ave. | Olten |
| 31 | Bob | Ringer | 371 College Av. | Olten |
| 32 | Michael | Ott | 339 College Av. | Boston |
| 33 | Mary | King | 491 College Av. | Oslo |
| 34 | Julia | May | 33 Upland Pl. | Seattle |
| 35 | George | Karsen | 412 College Av. | Chicago |
| 36 | John | Steel | 276 Upland Pl. | Dallas |
| 37 | Michael | Clancy | 19 Seventh Av. | Dallas |
| 38 | Andrew | Heiniger | 347 College Av. | Lyon |
| 39 | Mary | Karsen | 202 College Av. | Chicago |
| 40 | Susanne | Miller | 440 - 20th Ave. | Dallas |
| 41 | Bill | King | 546 College Av. | New York |
| 42 | Robert | Ott | 503 Seventh Av. | Oslo |
| 43 | Susanne | Smith | 2 Upland Pl. | Dallas |
| 44 | Sylvia | Ott | 361 College Av. | New York |
| 45 | Janet | May | 396 Seventh Av. | Oslo |
| 46 | Andrew | May | 172 Seventh Av. | New York |
| 47 | Janet | Fuller | 445 Upland Pl. | Dallas |
| 48 | Robert | White | 549 Seventh Av. | San Francisco |
| 49 | George | Fuller | 534 - 20th Ave. | Olten |
| ID | FIRSTNAME | LASTNAME |
| 0 | Laura | Steel |
| 1 | Susanne | King |
| 2 | Anne | Miller |
| 3 | Michael | Clancy |
| 4 | Sylvia | Ringer |
| 5 | Laura | Miller |
| 6 | Laura | White |
| 7 | James | Peterson |
| 8 | Andrew | Miller |
| 9 | James | Schneider |
| 10 | Anne | Fuller |
| 11 | Julia | White |
| 12 | George | Ott |
| 13 | Laura | Ringer |
| 14 | Bill | Karsen |
| 15 | Bill | Clancy |
| 16 | John | Fuller |
| 17 | Laura | Ott |
| 18 | Sylvia | Fuller |
| 19 | Susanne | Heiniger |
| 20 | Janet | Schneider |
| 21 | Julia | Clancy |
| 22 | Bill | Ott |
| 23 | Julia | Heiniger |
| 24 | James | Sommer |
| 25 | Sylvia | Steel |
| 26 | James | Clancy |
| 27 | Bob | Sommer |
| 28 | Susanne | White |
| 29 | Andrew | Smith |
| 30 | Bill | Sommer |
| 31 | Bob | Ringer |
| 32 | Michael | Ott |
| 33 | Mary | King |
| 34 | Julia | May |
| 35 | George | Karsen |
| 36 | John | Steel |
| 37 | Michael | Clancy |
| 38 | Andrew | Heiniger |
| 39 | Mary | Karsen |
| 40 | Susanne | Miller |
| 41 | Bill | King |
| 42 | Robert | Ott |
| 43 | Susanne | Smith |
| 44 | Sylvia | Ott |
| 45 | Janet | May |
| 46 | Andrew | May |
| 47 | Janet | Fuller |
| 48 | Robert | White |
| 49 | George | Fuller |
| ID | CUSTOMERID | TOTAL |
| 0 | 0 | 2607.6 |
| 1 | 33 | 1610.7 |
| 2 | 23 | 3789.0 |
| 3 | 21 | 5974.5 |
| 4 | 30 | 1953.0 |
| 5 | 34 | 4182.9 |
| 6 | 19 | 3340.2 |
| 7 | 26 | 5328.6 |
| 8 | 29 | 2675.1 |
| 9 | 38 | 6982.2 |
| 10 | 24 | 3274.5 |
| 11 | 24 | 2532.3 |
| 12 | 23 | 4578.3 |
| 13 | 39 | 7001.7 |
| 14 | 35 | 4940.4 |
| 15 | 39 | 1027.8 |
| 16 | 45 | 3657.3 |
| 17 | 46 | 3776.4 |
| 18 | 4 | 3772.8 |
| 19 | 9 | 804.3 |
| 20 | 19 | 3139.2 |
| 21 | 8 | 3740.1 |
| 22 | 40 | 2289.9 |
| 23 | 36 | 5166.6 |
| 24 | 15 | 4344.3 |
| 25 | 31 | 2054.1 |
| 26 | 27 | 4972.8 |
| 27 | 24 | 583.5 |
| 28 | 35 | 1664.4 |
| 29 | 46 | 2515.6 |
| 30 | 13 | 2117.4 |
| 31 | 22 | 2715.9 |
| 32 | 20 | 1098.6 |
| 33 | 40 | 4300.2 |
| 34 | 33 | 4290.6 |
| 35 | 4 | 3102.6 |
| 36 | 42 | 3200.1 |
| 37 | 39 | 7331.1 |
| 38 | 46 | 6373.8 |
| 39 | 5 | 1311.6 |
| 40 | 4 | 5288.4 |
| 41 | 19 | 5475.6 |
| 42 | 38 | 1436.4 |
| 43 | 13 | 4827.6 |
| 44 | 32 | 3388.2 |
| 45 | 42 | 4731.0 |
| 46 | 24 | 5827.2 |
| 47 | 45 | 2320.8 |
| 48 | 22 | 3494.7 |
| 49 | 32 | 4944.3 |
| INVOICEID | ITEM | PRODUCTID | QUANTITY | COST |
| 0 | 0 | 7 | 12 | 12.6 |
| 0 | 1 | 14 | 19 | 18.6 |
| 0 | 2 | 47 | 3 | 26.7 |
| 0 | 3 | 1 | 9 | 37.2 |
| 0 | 4 | 47 | 1 | 26.7 |
| 0 | 5 | 12 | 15 | 25.2 |
| 0 | 6 | 16 | 9 | 29.1 |
| 0 | 7 | 7 | 10 | 12.6 |
| 0 | 8 | 0 | 23 | 8.1 |
| 0 | 9 | 35 | 4 | 11.4 |
| 0 | 10 | 4 | 8 | 19.2 |
| 0 | 11 | 12 | 4 | 25.2 |
| 0 | 12 | 1 | 11 | 37.2 |
| 1 | 0 | 40 | 8 | 4.2 |
| 1 | 1 | 0 | 9 | 8.1 |
| 1 | 2 | 19 | 6 | 16.5 |
| 1 | 3 | 38 | 8 | 32.4 |
| 1 | 4 | 16 | 16 | 29.1 |
| 1 | 5 | 25 | 9 | 24.3 |
| 1 | 6 | 25 | 19 | 24.3 |
| 2 | 0 | 4 | 18 | 19.2 |
| 2 | 1 | 25 | 3 | 24.3 |
| 2 | 2 | 11 | 9 | 13.2 |
| 2 | 3 | 19 | 13 | 16.5 |
| 2 | 4 | 38 | 18 | 32.4 |
| 2 | 5 | 30 | 4 | 34.8 |
| 2 | 6 | 43 | 8 | 14.1 |
| 2 | 7 | 30 | 5 | 34.8 |
| 2 | 8 | 39 | 2 | 23.1 |
| 2 | 9 | 18 | 7 | 25.8 |
| 2 | 10 | 49 | 11 | 3.3 |
| 2 | 11 | 42 | 21 | 29.7 |
| 2 | 12 | 21 | 15 | 17.1 |
| 2 | 13 | 12 | 1 | 25.2 |
| 2 | 14 | 48 | 19 | 31.5 |
| 2 | 15 | 0 | 18 | 8.1 |
| 2 | 16 | 36 | 24 | 4.8 |
| 3 | 0 | 11 | 21 | 13.2 |
| 3 | 1 | 1 | 20 | 37.2 |
| 3 | 2 | 49 | 3 | 3.3 |
| 3 | 3 | 0 | 22 | 8.1 |
| 3 | 4 | 20 | 12 | 30.0 |
| 3 | 5 | 30 | 10 | 34.8 |
| 3 | 6 | 13 | 18 | 27.0 |
| 3 | 7 | 26 | 4 | 37.8 |
| 3 | 8 | 49 | 9 | 3.3 |
| 3 | 9 | 29 | 17 | 16.8 |
| 3 | 10 | 10 | 17 | 30.6 |
| 3 | 11 | 7 | 11 | 12.6 |
| 3 | 12 | 41 | 22 | 30.9 |
| 3 | 13 | 41 | 2 | 30.9 |
| 3 | 14 | 17 | 22 | 33.0 |
| 3 | 15 | 23 | 18 | 11.4 |
| 3 | 16 | 19 | 11 | 16.5 |
| 3 | 17 | 30 | 17 | 34.8 |
| 4 | 0 | 28 | 9 | 4.5 |
| 4 | 1 | 35 | 15 | 11.4 |
| 4 | 2 | 41 | 23 | 30.9 |
| 4 | 3 | 23 | 20 | 11.4 |
| 4 | 4 | 9 | 18 | 25.8 |
| 4 | 5 | 37 | 24 | 14.1 |
| 5 | 0 | 9 | 5 | 25.8 |
| 5 | 1 | 9 | 23 | 25.8 |
| 5 | 2 | 20 | 18 | 30.0 |
| 5 | 3 | 24 | 12 | 10.8 |
| 5 | 4 | 32 | 14 | 28.5 |
| 5 | 5 | 46 | 15 | 9.3 |
| 5 | 6 | 7 | 9 | 12.6 |
| 5 | 7 | 2 | 4 | 37.2 |
| 5 | 8 | 20 | 3 | 30.0 |
| 5 | 9 | 37 | 9 | 14.1 |
| 5 | 10 | 28 | 18 | 4.5 |
| 5 | 11 | 38 | 23 | 32.4 |
| 5 | 12 | 8 | 15 | 33.9 |
| 5 | 13 | 18 | 17 | 25.8 |
| 6 | 0 | 15 | 20 | 14.1 |
| 6 | 1 | 38 | 21 | 32.4 |
| 6 | 2 | 23 | 8 | 11.4 |
| 6 | 3 | 30 | 2 | 34.8 |
| 6 | 4 | 31 | 20 | 7.2 |
| 6 | 5 | 14 | 20 | 18.6 |
| 6 | 6 | 37 | 22 | 14.1 |
| 6 | 7 | 26 | 10 | 37.8 |
| 6 | 8 | 41 | 19 | 30.9 |
| 6 | 9 | 19 | 2 | 16.5 |
| 6 | 10 | 16 | 13 | 29.1 |
| 6 | 11 | 44 | 1 | 14.4 |
| 7 | 0 | 43 | 16 | 14.1 |
| 7 | 1 | 23 | 12 | 11.4 |
| 7 | 2 | 27 | 17 | 34.5 |
| 7 | 3 | 30 | 2 | 34.8 |
| 7 | 4 | 2 | 13 | 37.2 |
| 7 | 5 | 24 | 10 | 10.8 |
| 7 | 6 | 14 | 4 | 18.6 |
| 7 | 7 | 2 | 22 | 37.2 |
| 7 | 8 | 42 | 19 | 29.7 |
| 7 | 9 | 9 | 21 | 25.8 |
| 7 | 10 | 7 | 1 | 12.6 |
| 7 | 11 | 19 | 13 | 16.5 |
| 7 | 12 | 40 | 16 | 4.2 |
| 7 | 13 | 32 | 23 | 28.5 |
| 7 | 14 | 47 | 14 | 26.7 |
| 7 | 15 | 24 | 17 | 10.8 |
| 7 | 16 | 7 | 12 | 12.6 |
| 7 | 17 | 40 | 1 | 4.2 |
| 7 | 18 | 23 | 5 | 11.4 |
| 8 | 0 | 34 | 15 | 38.4 |
| 8 | 1 | 44 | 16 | 14.4 |
| 8 | 2 | 11 | 8 | 13.2 |
| 8 | 3 | 41 | 16 | 30.9 |
| 8 | 4 | 15 | 8 | 14.1 |
| 8 | 5 | 24 | 18 | 10.8 |
| 8 | 6 | 15 | 19 | 14.1 |
| 8 | 7 | 6 | 5 | 14.7 |
| 8 | 8 | 38 | 7 | 32.4 |
| 8 | 9 | 21 | 23 | 17.1 |
| 9 | 0 | 45 | 8 | 27.0 |
| 9 | 1 | 18 | 21 | 25.8 |
| 9 | 2 | 29 | 12 | 16.8 |
| 9 | 3 | 4 | 14 | 19.2 |
| 9 | 4 | 36 | 16 | 4.8 |
| 9 | 5 | 6 | 2 | 14.7 |
| 9 | 6 | 18 | 10 | 25.8 |
| 9 | 7 | 2 | 22 | 37.2 |
| 9 | 8 | 24 | 11 | 10.8 |
| 9 | 9 | 13 | 6 | 27.0 |
| 9 | 10 | 38 | 11 | 32.4 |
| 9 | 11 | 12 | 16 | 25.2 |
| 9 | 12 | 25 | 23 | 24.3 |
| 9 | 13 | 42 | 13 | 29.7 |
| 9 | 14 | 15 | 8 | 14.1 |
| 9 | 15 | 48 | 23 | 31.5 |
| 9 | 16 | 24 | 10 | 10.8 |
| 9 | 17 | 13 | 17 | 27.0 |
| 9 | 18 | 3 | 12 | 38.1 |
| 9 | 19 | 48 | 23 | 31.5 |
| 10 | 0 | 20 | 1 | 30.0 |
| 10 | 1 | 33 | 17 | 27.3 |
| 10 | 2 | 7 | 9 | 12.6 |
| 10 | 3 | 46 | 1 | 9.3 |
| 10 | 4 | 10 | 24 | 30.6 |
| 10 | 5 | 5 | 24 | 35.4 |
| 10 | 6 | 18 | 14 | 25.8 |
| 10 | 7 | 4 | 13 | 19.2 |
| 10 | 8 | 22 | 11 | 9.9 |
| 10 | 9 | 5 | 10 | 35.4 |
| 11 | 0 | 45 | 10 | 27.0 |
| 11 | 1 | 21 | 21 | 17.1 |
| 11 | 2 | 0 | 3 | 8.1 |
| 11 | 3 | 32 | 21 | 28.5 |
| 11 | 4 | 47 | 16 | 26.7 |
| 11 | 5 | 19 | 2 | 16.5 |
| 11 | 6 | 0 | 12 | 8.1 |
| 11 | 7 | 48 | 22 | 31.5 |
| 11 | 8 | 20 | 1 | 30.0 |
| 12 | 0 | 1 | 24 | 37.2 |
| 12 | 1 | 41 | 19 | 30.9 |
| 12 | 2 | 6 | 5 | 14.7 |
| 12 | 3 | 0 | 18 | 8.1 |
| 12 | 4 | 20 | 11 | 30.0 |
| 12 | 5 | 37 | 17 | 14.1 |
| 12 | 6 | 31 | 15 | 7.2 |
| 12 | 7 | 48 | 7 | 31.5 |
| 12 | 8 | 48 | 2 | 31.5 |
| 12 | 9 | 25 | 22 | 24.3 |
| 12 | 10 | 46 | 19 | 9.3 |
| 12 | 11 | 28 | 16 | 4.5 |
| 12 | 12 | 13 | 12 | 27.0 |
| 12 | 13 | 36 | 21 | 4.8 |
| 12 | 14 | 25 | 11 | 24.3 |
| 12 | 15 | 22 | 16 | 9.9 |
| 12 | 16 | 0 | 9 | 8.1 |
| 12 | 17 | 31 | 15 | 7.2 |
| 12 | 18 | 9 | 4 | 25.8 |
| 13 | 0 | 16 | 10 | 29.1 |
| 13 | 1 | 1 | 1 | 37.2 |
| 13 | 2 | 13 | 20 | 27.0 |
| 13 | 3 | 32 | 2 | 28.5 |
| 13 | 4 | 26 | 21 | 37.8 |
| 13 | 5 | 22 | 19 | 9.9 |
| 13 | 6 | 19 | 8 | 16.5 |
| 13 | 7 | 29 | 24 | 16.8 |
| 13 | 8 | 48 | 11 | 31.5 |
| 13 | 9 | 24 | 10 | 10.8 |
| 13 | 10 | 45 | 24 | 27.0 |
| 13 | 11 | 14 | 3 | 18.6 |
| 13 | 12 | 17 | 3 | 33.0 |
| 13 | 13 | 10 | 20 | 30.6 |
| 13 | 14 | 1 | 12 | 37.2 |
| 13 | 15 | 0 | 20 | 8.1 |
| 13 | 16 | 22 | 23 | 9.9 |
| 13 | 17 | 32 | 18 | 28.5 |
| 13 | 18 | 0 | 16 | 8.1 |
| 13 | 19 | 42 | 18 | 29.7 |
| 13 | 20 | 5 | 19 | 35.4 |
| 13 | 21 | 40 | 1 | 4.2 |
| 14 | 0 | 42 | 18 | 29.7 |
| 14 | 1 | 9 | 22 | 25.8 |
| 14 | 2 | 15 | 18 | 14.1 |
| 14 | 3 | 34 | 11 | 38.4 |
| 14 | 4 | 41 | 17 | 30.9 |
| 14 | 5 | 11 | 8 | 13.2 |
| 14 | 6 | 26 | 18 | 37.8 |
| 14 | 7 | 43 | 4 | 14.1 |
| 14 | 8 | 23 | 7 | 11.4 |
| 14 | 9 | 13 | 16 | 27.0 |
| 14 | 10 | 44 | 16 | 14.4 |
| 14 | 11 | 25 | 15 | 24.3 |
| 14 | 12 | 4 | 20 | 19.2 |
| 14 | 13 | 11 | 23 | 13.2 |
| 15 | 0 | 17 | 12 | 33.0 |
| 15 | 1 | 13 | 21 | 27.0 |
| 15 | 2 | 24 | 6 | 10.8 |
| 16 | 0 | 18 | 15 | 25.8 |
| 16 | 1 | 36 | 20 | 4.8 |
| 16 | 2 | 20 | 15 | 30.0 |
| 16 | 3 | 0 | 3 | 8.1 |
| 16 | 4 | 10 | 24 | 30.6 |
| 16 | 5 | 11 | 15 | 13.2 |
| 16 | 6 | 44 | 7 | 14.4 |
| 16 | 7 | 8 | 17 | 33.9 |
| 16 | 8 | 13 | 17 | 27.0 |
| 16 | 9 | 11 | 10 | 13.2 |
| 16 | 10 | 43 | 8 | 14.1 |
| 16 | 11 | 24 | 7 | 10.8 |
| 16 | 12 | 18 | 2 | 25.8 |
| 16 | 13 | 20 | 1 | 30.0 |
| 16 | 14 | 0 | 19 | 8.1 |
| 16 | 15 | 12 | 3 | 25.2 |
| 17 | 0 | 16 | 8 | 29.1 |
| 17 | 1 | 19 | 19 | 16.5 |
| 17 | 2 | 44 | 11 | 14.4 |
| 17 | 3 | 24 | 4 | 10.8 |
| 17 | 4 | 23 | 2 | 11.4 |
| 17 | 5 | 44 | 1 | 14.4 |
| 17 | 6 | 43 | 6 | 14.1 |
| 17 | 7 | 6 | 15 | 14.7 |
| 17 | 8 | 49 | 8 | 3.3 |
| 17 | 9 | 8 | 15 | 33.9 |
| 17 | 10 | 10 | 12 | 30.6 |
| 17 | 11 | 45 | 10 | 27.0 |
| 17 | 12 | 22 | 16 | 9.9 |
| 17 | 13 | 41 | 5 | 30.9 |
| 17 | 14 | 18 | 2 | 25.8 |
| 17 | 15 | 35 | 10 | 11.4 |
| 17 | 16 | 8 | 16 | 33.9 |
| 17 | 17 | 7 | 5 | 12.6 |
| 17 | 18 | 5 | 9 | 35.4 |
| 17 | 19 | 46 | 12 | 9.3 |
| 18 | 0 | 32 | 1 | 28.5 |
| 18 | 1 | 33 | 12 | 27.3 |
| 18 | 2 | 40 | 12 | 4.2 |
| 18 | 3 | 19 | 8 | 16.5 |
| 18 | 4 | 28 | 6 | 4.5 |
| 18 | 5 | 15 | 6 | 14.1 |
| 18 | 6 | 29 | 4 | 16.8 |
| 18 | 7 | 15 | 14 | 14.1 |
| 18 | 8 | 1 | 24 | 37.2 |
| 18 | 9 | 2 | 2 | 37.2 |
| 18 | 10 | 34 | 18 | 38.4 |
| 18 | 11 | 30 | 8 | 34.8 |
| 18 | 12 | 37 | 12 | 14.1 |
| 18 | 13 | 14 | 12 | 18.6 |
| 18 | 14 | 28 | 20 | 4.5 |
| 18 | 15 | 44 | 20 | 14.4 |
| 18 | 16 | 31 | 12 | 7.2 |
| 18 | 17 | 8 | 1 | 33.9 |
| 18 | 18 | 10 | 1 | 30.6 |
| 19 | 0 | 12 | 7 | 25.2 |
| 19 | 1 | 31 | 2 | 7.2 |
| 19 | 2 | 4 | 22 | 19.2 |
| 19 | 3 | 49 | 23 | 3.3 |
| 19 | 4 | 36 | 24 | 4.8 |
| 20 | 0 | 47 | 15 | 26.7 |
| 20 | 1 | 29 | 6 | 16.8 |
| 20 | 2 | 24 | 22 | 10.8 |
| 20 | 3 | 25 | 14 | 24.3 |
| 20 | 4 | 30 | 13 | 34.8 |
| 20 | 5 | 8 | 14 | 33.9 |
| 20 | 6 | 20 | 2 | 30.0 |
| 20 | 7 | 9 | 9 | 25.8 |
| 20 | 8 | 44 | 18 | 14.4 |
| 20 | 9 | 12 | 8 | 25.2 |
| 20 | 10 | 25 | 11 | 24.3 |
| 20 | 11 | 15 | 8 | 14.1 |
| 21 | 0 | 9 | 10 | 25.8 |
| 21 | 1 | 38 | 19 | 32.4 |
| 21 | 2 | 31 | 17 | 7.2 |
| 21 | 3 | 30 | 13 | 34.8 |
| 21 | 4 | 49 | 22 | 3.3 |
| 21 | 5 | 27 | 18 | 34.5 |
| 21 | 6 | 26 | 7 | 37.8 |
| 21 | 7 | 8 | 9 | 33.9 |
| 21 | 8 | 44 | 19 | 14.4 |
| 21 | 9 | 35 | 17 | 11.4 |
| 21 | 10 | 19 | 14 | 16.5 |
| 21 | 11 | 20 | 11 | 30.0 |
| 22 | 0 | 9 | 6 | 25.8 |
| 22 | 1 | 30 | 11 | 34.8 |
| 22 | 2 | 12 | 20 | 25.2 |
| 22 | 3 | 22 | 5 | 9.9 |
| 22 | 4 | 5 | 21 | 35.4 |
| 22 | 5 | 24 | 5 | 10.8 |
| 22 | 6 | 4 | 11 | 19.2 |
| 22 | 7 | 21 | 6 | 17.1 |
| 22 | 8 | 3 | 2 | 38.1 |
| 22 | 9 | 23 | 1 | 11.4 |
| 23 | 0 | 48 | 22 | 31.5 |
| 23 | 1 | 26 | 8 | 37.8 |
| 23 | 2 | 33 | 18 | 27.3 |
| 23 | 3 | 40 | 19 | 4.2 |
| 23 | 4 | 23 | 19 | 11.4 |
| 23 | 5 | 32 | 14 | 28.5 |
| 23 | 6 | 16 | 1 | 29.1 |
| 23 | 7 | 39 | 3 | 23.1 |
| 23 | 8 | 6 | 17 | 14.7 |
| 23 | 9 | 20 | 18 | 30.0 |
| 23 | 10 | 4 | 18 | 19.2 |
| 23 | 11 | 41 | 8 | 30.9 |
| 23 | 12 | 4 | 17 | 19.2 |
| 23 | 13 | 14 | 17 | 18.6 |
| 23 | 14 | 44 | 2 | 14.4 |
| 23 | 15 | 13 | 17 | 27.0 |
| 23 | 16 | 8 | 11 | 33.9 |
| 24 | 0 | 43 | 14 | 14.1 |
| 24 | 1 | 46 | 18 | 9.3 |
| 24 | 2 | 38 | 10 | 32.4 |
| 24 | 3 | 17 | 23 | 33.0 |
| 24 | 4 | 15 | 17 | 14.1 |
| 24 | 5 | 35 | 16 | 11.4 |
| 24 | 6 | 40 | 3 | 4.2 |
| 24 | 7 | 7 | 13 | 12.6 |
| 24 | 8 | 5 | 18 | 35.4 |
| 24 | 9 | 21 | 8 | 17.1 |
| 24 | 10 | 27 | 4 | 34.5 |
| 24 | 11 | 1 | 4 | 37.2 |
| 24 | 12 | 0 | 8 | 8.1 |
| 24 | 13 | 15 | 21 | 14.1 |
| 24 | 14 | 1 | 13 | 37.2 |
| 24 | 15 | 39 | 17 | 23.1 |
| 25 | 0 | 5 | 15 | 35.4 |
| 25 | 1 | 43 | 13 | 14.1 |
| 25 | 2 | 13 | 8 | 27.0 |
| 25 | 3 | 19 | 4 | 16.5 |
| 25 | 4 | 47 | 10 | 26.7 |
| 25 | 5 | 10 | 5 | 30.6 |
| 25 | 6 | 21 | 18 | 17.1 |
| 25 | 7 | 16 | 8 | 29.1 |
| 25 | 8 | 38 | 3 | 32.4 |
| 26 | 0 | 42 | 16 | 29.7 |
| 26 | 1 | 43 | 21 | 14.1 |
| 26 | 2 | 33 | 7 | 27.3 |
| 26 | 3 | 16 | 3 | 29.1 |
| 26 | 4 | 46 | 7 | 9.3 |
| 26 | 5 | 38 | 4 | 32.4 |
| 26 | 6 | 7 | 23 | 12.6 |
| 26 | 7 | 4 | 16 | 19.2 |
| 26 | 8 | 40 | 13 | 4.2 |
| 26 | 9 | 1 | 23 | 37.2 |
| 26 | 10 | 34 | 16 | 38.4 |
| 26 | 11 | 18 | 3 | 25.8 |
| 26 | 12 | 27 | 20 | 34.5 |
| 26 | 13 | 13 | 10 | 27.0 |
| 26 | 14 | 26 | 6 | 37.8 |
| 26 | 15 | 8 | 6 | 33.9 |
| 26 | 16 | 30 | 4 | 34.8 |
| 27 | 0 | 24 | 15 | 10.8 |
| 27 | 1 | 45 | 15 | 27.0 |
| 27 | 2 | 19 | 1 | 16.5 |
| 28 | 0 | 35 | 13 | 11.4 |
| 28 | 1 | 15 | 13 | 14.1 |
| 28 | 2 | 44 | 22 | 14.4 |
| 28 | 3 | 6 | 3 | 14.7 |
| 28 | 4 | 45 | 17 | 27.0 |
| 28 | 5 | 49 | 4 | 3.3 |
| 28 | 6 | 33 | 16 | 27.3 |
| 28 | 7 | 28 | 8 | 4.5 |
| 28 | 8 | 28 | 6 | 4.5 |
| 29 | 0 | 33 | 17 | 27.3 |
| 29 | 1 | 38 | 12 | 32.4 |
| 29 | 2 | 17 | 23 | 33.0 |
| 29 | 3 | 7 | 21 | 12.6 |
| 29 | 4 | 4 | 7 | 19.2 |
| 29 | 5 | 31 | 13 | 7.2 |
| 29 | 6 | 4 | 16 | 19.2 |
| 29 | 7 | 5 | 1 | 35.4 |
| 29 | 8 | 35 | 6 | 11.4 |
| 30 | 0 | 14 | 7 | 18.6 |
| 30 | 1 | 16 | 19 | 29.1 |
| 30 | 2 | 10 | 18 | 30.6 |
| 30 | 3 | 33 | 2 | 27.3 |
| 30 | 4 | 34 | 2 | 38.4 |
| 30 | 5 | 43 | 23 | 14.1 |
| 30 | 6 | 14 | 23 | 18.6 |
| 31 | 0 | 33 | 10 | 27.3 |
| 31 | 1 | 4 | 23 | 19.2 |
| 31 | 2 | 4 | 3 | 19.2 |
| 31 | 3 | 12 | 10 | 25.2 |
| 31 | 4 | 8 | 14 | 33.9 |
| 31 | 5 | 1 | 4 | 37.2 |
| 31 | 6 | 26 | 16 | 37.8 |
| 31 | 7 | 38 | 3 | 32.4 |
| 31 | 8 | 7 | 5 | 12.6 |
| 31 | 9 | 14 | 15 | 18.6 |
| 31 | 10 | 0 | 3 | 8.1 |
| 32 | 0 | 35 | 11 | 11.4 |
| 32 | 1 | 30 | 13 | 34.8 |
| 32 | 2 | 1 | 14 | 37.2 |
| 33 | 0 | 36 | 5 | 4.8 |
| 33 | 1 | 10 | 21 | 30.6 |
| 33 | 2 | 36 | 16 | 4.8 |
| 33 | 3 | 48 | 1 | 31.5 |
| 33 | 4 | 24 | 1 | 10.8 |
| 33 | 5 | 8 | 11 | 33.9 |
| 33 | 6 | 17 | 16 | 33.0 |
| 33 | 7 | 43 | 10 | 14.1 |
| 33 | 8 | 3 | 15 | 38.1 |
| 33 | 9 | 29 | 5 | 16.8 |
| 33 | 10 | 24 | 9 | 10.8 |
| 33 | 11 | 5 | 7 | 35.4 |
| 33 | 12 | 16 | 23 | 29.1 |
| 33 | 13 | 25 | 16 | 24.3 |
| 33 | 14 | 44 | 13 | 14.4 |
| 33 | 15 | 38 | 7 | 32.4 |
| 34 | 0 | 10 | 22 | 30.6 |
| 34 | 1 | 4 | 3 | 19.2 |
| 34 | 2 | 28 | 22 | 4.5 |
| 34 | 3 | 44 | 15 | 14.4 |
| 34 | 4 | 27 | 1 | 34.5 |
| 34 | 5 | 45 | 13 | 27.0 |
| 34 | 6 | 32 | 7 | 28.5 |
| 34 | 7 | 21 | 22 | 17.1 |
| 34 | 8 | 3 | 1 | 38.1 |
| 34 | 9 | 8 | 17 | 33.9 |
| 34 | 10 | 41 | 16 | 30.9 |
| 34 | 11 | 4 | 17 | 19.2 |
| 34 | 12 | 43 | 21 | 14.1 |
| 34 | 13 | 30 | 14 | 34.8 |
| 34 | 14 | 46 | 7 | 9.3 |
| 35 | 0 | 20 | 17 | 30.0 |
| 35 | 1 | 3 | 9 | 38.1 |
| 35 | 2 | 14 | 4 | 18.6 |
| 35 | 3 | 27 | 10 | 34.5 |
| 35 | 4 | 14 | 17 | 18.6 |
| 35 | 5 | 33 | 5 | 27.3 |
| 35 | 6 | 5 | 4 | 35.4 |
| 35 | 7 | 22 | 15 | 9.9 |
| 35 | 8 | 0 | 1 | 8.1 |
| 35 | 9 | 19 | 1 | 16.5 |
| 35 | 10 | 17 | 11 | 33.0 |
| 35 | 11 | 44 | 9 | 14.4 |
| 35 | 12 | 7 | 23 | 12.6 |
| 35 | 13 | 19 | 17 | 16.5 |
| 36 | 0 | 18 | 13 | 25.8 |
| 36 | 1 | 15 | 23 | 14.1 |
| 36 | 2 | 1 | 6 | 37.2 |
| 36 | 3 | 10 | 8 | 30.6 |
| 36 | 4 | 40 | 5 | 4.2 |
| 36 | 5 | 25 | 8 | 24.3 |
| 36 | 6 | 39 | 20 | 23.1 |
| 36 | 7 | 39 | 19 | 23.1 |
| 36 | 8 | 4 | 21 | 19.2 |
| 36 | 9 | 31 | 18 | 7.2 |
| 36 | 10 | 47 | 11 | 26.7 |
| 36 | 11 | 44 | 9 | 14.4 |
| 37 | 0 | 41 | 24 | 30.9 |
| 37 | 1 | 15 | 20 | 14.1 |
| 37 | 2 | 36 | 8 | 4.8 |
| 37 | 3 | 26 | 7 | 37.8 |
| 37 | 4 | 13 | 20 | 27.0 |
| 37 | 5 | 1 | 14 | 37.2 |
| 37 | 6 | 34 | 12 | 38.4 |
| 37 | 7 | 24 | 19 | 10.8 |
| 37 | 8 | 46 | 9 | 9.3 |
| 37 | 9 | 47 | 16 | 26.7 |
| 37 | 10 | 1 | 18 | 37.2 |
| 37 | 11 | 30 | 5 | 34.8 |
| 37 | 12 | 24 | 23 | 10.8 |
| 37 | 13 | 32 | 3 | 28.5 |
| 37 | 14 | 12 | 3 | 25.2 |
| 37 | 15 | 32 | 12 | 28.5 |
| 37 | 16 | 27 | 8 | 34.5 |
| 37 | 17 | 38 | 18 | 32.4 |
| 37 | 18 | 26 | 22 | 37.8 |
| 37 | 19 | 19 | 20 | 16.5 |
| 37 | 20 | 14 | 1 | 18.6 |
| 37 | 21 | 6 | 9 | 14.7 |
| 38 | 0 | 48 | 14 | 31.5 |
| 38 | 1 | 45 | 13 | 27.0 |
| 38 | 2 | 4 | 8 | 19.2 |
| 38 | 3 | 27 | 19 | 34.5 |
| 38 | 4 | 45 | 14 | 27.0 |
| 38 | 5 | 48 | 17 | 31.5 |
| 38 | 6 | 5 | 19 | 35.4 |
| 38 | 7 | 15 | 1 | 14.1 |
| 38 | 8 | 40 | 10 | 4.2 |
| 38 | 9 | 27 | 20 | 34.5 |
| 38 | 10 | 4 | 18 | 19.2 |
| 38 | 11 | 19 | 18 | 16.5 |
| 38 | 12 | 1 | 18 | 37.2 |
| 38 | 13 | 8 | 7 | 33.9 |
| 38 | 14 | 20 | 7 | 30.0 |
| 38 | 15 | 47 | 10 | 26.7 |
| 38 | 16 | 40 | 18 | 4.2 |
| 38 | 17 | 32 | 4 | 28.5 |
| 38 | 18 | 28 | 20 | 4.5 |
| 38 | 19 | 4 | 7 | 19.2 |
| 39 | 0 | 10 | 12 | 30.6 |
| 39 | 1 | 24 | 6 | 10.8 |
| 39 | 2 | 39 | 16 | 23.1 |
| 39 | 3 | 20 | 17 | 30.0 |
| 40 | 0 | 46 | 24 | 9.3 |
| 40 | 1 | 45 | 24 | 27.0 |
| 40 | 2 | 4 | 5 | 19.2 |
| 40 | 3 | 26 | 10 | 37.8 |
| 40 | 4 | 18 | 13 | 25.8 |
| 40 | 5 | 32 | 18 | 28.5 |
| 40 | 6 | 28 | 12 | 4.5 |
| 40 | 7 | 31 | 1 | 7.2 |
| 40 | 8 | 11 | 4 | 13.2 |
| 40 | 9 | 40 | 17 | 4.2 |
| 40 | 10 | 6 | 11 | 14.7 |
| 40 | 11 | 27 | 2 | 34.5 |
| 40 | 12 | 35 | 13 | 11.4 |
| 40 | 13 | 6 | 8 | 14.7 |
| 40 | 14 | 4 | 24 | 19.2 |
| 40 | 15 | 22 | 12 | 9.9 |
| 40 | 16 | 27 | 16 | 34.5 |
| 40 | 17 | 4 | 20 | 19.2 |
| 40 | 18 | 33 | 11 | 27.3 |
| 40 | 19 | 7 | 23 | 12.6 |
| 40 | 20 | 4 | 16 | 19.2 |
| 41 | 0 | 5 | 24 | 35.4 |
| 41 | 1 | 47 | 19 | 26.7 |
| 41 | 2 | 36 | 2 | 4.8 |
| 41 | 3 | 29 | 20 | 16.8 |
| 41 | 4 | 16 | 22 | 29.1 |
| 41 | 5 | 9 | 21 | 25.8 |
| 41 | 6 | 17 | 11 | 33.0 |
| 41 | 7 | 22 | 18 | 9.9 |
| 41 | 8 | 9 | 22 | 25.8 |
| 41 | 9 | 26 | 21 | 37.8 |
| 41 | 10 | 24 | 20 | 10.8 |
| 41 | 11 | 48 | 15 | 31.5 |
| 42 | 0 | 48 | 9 | 31.5 |
| 42 | 1 | 18 | 21 | 25.8 |
| 42 | 2 | 40 | 19 | 4.2 |
| 42 | 3 | 40 | 14 | 4.2 |
| 42 | 4 | 48 | 15 | 31.5 |
| 43 | 0 | 15 | 22 | 14.1 |
| 43 | 1 | 18 | 19 | 25.8 |
| 43 | 2 | 2 | 15 | 37.2 |
| 43 | 3 | 6 | 18 | 14.7 |
| 43 | 4 | 32 | 22 | 28.5 |
| 43 | 5 | 33 | 6 | 27.3 |
| 43 | 6 | 24 | 1 | 10.8 |
| 43 | 7 | 11 | 15 | 13.2 |
| 43 | 8 | 44 | 8 | 14.4 |
| 43 | 9 | 7 | 23 | 12.6 |
| 43 | 10 | 35 | 1 | 11.4 |
| 43 | 11 | 49 | 23 | 3.3 |
| 43 | 12 | 40 | 24 | 4.2 |
| 43 | 13 | 44 | 22 | 14.4 |
| 43 | 14 | 3 | 18 | 38.1 |
| 43 | 15 | 48 | 7 | 31.5 |
| 43 | 16 | 38 | 12 | 32.4 |
| 44 | 0 | 33 | 20 | 27.3 |
| 44 | 1 | 34 | 17 | 38.4 |
| 44 | 2 | 17 | 14 | 33.0 |
| 44 | 3 | 3 | 14 | 38.1 |
| 44 | 4 | 12 | 3 | 25.2 |
| 44 | 5 | 41 | 22 | 30.9 |
| 44 | 6 | 14 | 15 | 18.6 |
| 44 | 7 | 49 | 17 | 3.3 |
| 44 | 8 | 28 | 23 | 4.5 |
| 45 | 0 | 44 | 6 | 14.4 |
| 45 | 1 | 11 | 6 | 13.2 |
| 45 | 2 | 46 | 8 | 9.3 |
| 45 | 3 | 14 | 11 | 18.6 |
| 45 | 4 | 3 | 14 | 38.1 |
| 45 | 5 | 45 | 17 | 27.0 |
| 45 | 6 | 39 | 5 | 23.1 |
| 45 | 7 | 6 | 24 | 14.7 |
| 45 | 8 | 9 | 2 | 25.8 |
| 45 | 9 | 26 | 18 | 37.8 |
| 45 | 10 | 41 | 24 | 30.9 |
| 45 | 11 | 31 | 22 | 7.2 |
| 45 | 12 | 32 | 13 | 28.5 |
| 45 | 13 | 47 | 8 | 26.7 |
| 45 | 14 | 3 | 16 | 38.1 |
| 46 | 0 | 5 | 21 | 35.4 |
| 46 | 1 | 12 | 24 | 25.2 |
| 46 | 2 | 30 | 14 | 34.8 |
| 46 | 3 | 21 | 19 | 17.1 |
| 46 | 4 | 17 | 5 | 33.0 |
| 46 | 5 | 25 | 9 | 24.3 |
| 46 | 6 | 41 | 18 | 30.9 |
| 46 | 7 | 49 | 9 | 3.3 |
| 46 | 8 | 8 | 22 | 33.9 |
| 46 | 9 | 7 | 4 | 12.6 |
| 46 | 10 | 11 | 24 | 13.2 |
| 46 | 11 | 1 | 4 | 37.2 |
| 46 | 12 | 21 | 24 | 17.1 |
| 46 | 13 | 36 | 20 | 4.8 |
| 46 | 14 | 24 | 10 | 10.8 |
| 46 | 15 | 40 | 11 | 4.2 |
| 46 | 16 | 46 | 21 | 9.3 |
| 46 | 17 | 12 | 23 | 25.2 |
| 47 | 0 | 23 | 15 | 11.4 |
| 47 | 1 | 23 | 13 | 11.4 |
| 47 | 2 | 17 | 6 | 33.0 |
| 47 | 3 | 1 | 4 | 37.2 |
| 47 | 4 | 15 | 1 | 14.1 |
| 47 | 5 | 40 | 8 | 4.2 |
| 47 | 6 | 8 | 10 | 33.9 |
| 47 | 7 | 28 | 14 | 4.5 |
| 47 | 8 | 16 | 2 | 29.1 |
| 47 | 9 | 32 | 9 | 28.5 |
| 47 | 10 | 45 | 2 | 27.0 |
| 47 | 11 | 35 | 10 | 11.4 |
| 47 | 12 | 12 | 20 | 25.2 |
| 47 | 13 | 33 | 8 | 27.3 |
| 48 | 0 | 6 | 23 | 14.7 |
| 48 | 1 | 26 | 23 | 37.8 |
| 48 | 2 | 23 | 10 | 11.4 |
| 48 | 3 | 10 | 2 | 30.6 |
| 48 | 4 | 48 | 4 | 31.5 |
| 48 | 5 | 24 | 16 | 10.8 |
| 48 | 6 | 11 | 17 | 13.2 |
| 48 | 7 | 30 | 19 | 34.8 |
| 48 | 8 | 5 | 12 | 35.4 |
| 48 | 9 | 35 | 17 | 11.4 |
| 48 | 10 | 41 | 10 | 30.9 |
| 49 | 0 | 18 | 6 | 25.8 |
| 49 | 1 | 22 | 16 | 9.9 |
| 49 | 2 | 29 | 6 | 16.8 |
| 49 | 3 | 17 | 19 | 33.0 |
| 49 | 4 | 47 | 14 | 26.7 |
| 49 | 5 | 16 | 1 | 29.1 |
| 49 | 6 | 29 | 15 | 16.8 |
| 49 | 7 | 6 | 21 | 14.7 |
| 49 | 8 | 48 | 24 | 31.5 |
| 49 | 9 | 7 | 24 | 12.6 |
| 49 | 10 | 30 | 16 | 34.8 |
| 49 | 11 | 40 | 15 | 4.2 |
| 49 | 12 | 21 | 17 | 17.1 |
| 49 | 13 | 6 | 22 | 14.7 |
| 49 | 14 | 23 | 5 | 11.4 |
| 49 | 15 | 19 | 24 | 16.5 |
| 49 | 16 | 24 | 18 | 10.8 |
| ID | NAME | PRICE |
| 0 | Iron Iron | 5.4 |
| 1 | Chair Shoe | 24.8 |
| 2 | Telephone Clock | 24.8 |
| 3 | Chair Chair | 25.4 |
| 4 | Ice Tea Shoe | 12.8 |
| 5 | Clock Clock | 23.6 |
| 6 | Ice Tea Chair | 9.8 |
| 7 | Telephone Shoe | 8.4 |
| 8 | Ice Tea Clock | 22.6 |
| 9 | Clock Telephone | 17.2 |
| 10 | Telephone Ice Tea | 20.4 |
| 11 | Telephone Iron | 8.8 |
| 12 | Clock Ice Tea | 16.8 |
| 13 | Telephone Clock | 18.0 |
| 14 | Telephone Iron | 12.4 |
| 15 | Ice Tea Chair | 9.4 |
| 16 | Ice Tea Shoe | 19.4 |
| 17 | Clock Ice Tea | 22.0 |
| 18 | Chair Clock | 17.2 |
| 19 | Ice Tea Ice Tea | 11.0 |
| 20 | Ice Tea Telephone | 20.0 |
| 21 | Chair Chair | 11.4 |
| 22 | Iron Iron | 6.6 |
| 23 | Shoe Chair | 7.6 |
| 24 | Chair Shoe | 7.2 |
| 25 | Shoe Shoe | 16.2 |
| 26 | Shoe Shoe | 25.2 |
| 27 | Telephone Iron | 23.0 |
| 28 | Clock Iron | 3.0 |
| 29 | Chair Telephone | 11.2 |
| 30 | Shoe Iron | 23.2 |
| 31 | Ice Tea Telephone | 4.8 |
| 32 | Clock Iron | 19.0 |
| 33 | Iron Chair | 18.2 |
| 34 | Chair Iron | 25.6 |
| 35 | Telephone Shoe | 7.6 |
| 36 | Ice Tea Iron | 3.2 |
| 37 | Clock Shoe | 9.4 |
| 38 | Clock Ice Tea | 21.6 |
| 39 | Ice Tea Shoe | 15.4 |
| 40 | Shoe Clock | 2.8 |
| 41 | Clock Ice Tea | 20.6 |
| 42 | Iron Chair | 19.8 |
| 43 | Telephone Clock | 9.4 |
| 44 | Ice Tea Ice Tea | 9.6 |
| 45 | Iron Ice Tea | 18.0 |
| 46 | Ice Tea Clock | 6.2 |
| 47 | Ice Tea Iron | 17.8 |
| 48 | Clock Clock | 21.0 |
| 49 | Iron Iron | 2.2 |
| SUPPLIER_ID | SUPPLIER_NAME |
| 1 | IBM |
| INVOICEID | ITEM | PRODUCTID | QUANTITY | COST |
| 0 | 0 | 7 | 12 | 12.6 |
| 0 | 1 | 14 | 19 | 18.6 |
| 0 | 2 | 47 | 3 | 26.7 |
| 0 | 3 | 1 | 9 | 37.2 |
| 0 | 4 | 47 | 1 | 26.7 |
| 0 | 5 | 12 | 15 | 25.2 |
| 0 | 6 | 16 | 9 | 29.1 |
| 0 | 7 | 7 | 10 | 12.6 |
| 0 | 8 | 0 | 23 | 8.1 |
| 0 | 9 | 35 | 4 | 11.4 |
| 0 | 10 | 4 | 8 | 19.2 |
| 0 | 11 | 12 | 4 | 25.2 |
| 0 | 12 | 1 | 11 | 37.2 |
| 1 | 0 | 40 | 8 | 4.2 |
| 1 | 1 | 0 | 9 | 8.1 |
| 1 | 2 | 19 | 6 | 16.5 |
| 1 | 3 | 38 | 8 | 32.4 |
| 1 | 4 | 16 | 16 | 29.1 |
| 1 | 5 | 25 | 9 | 24.3 |
| 1 | 6 | 25 | 19 | 24.3 |
| ID | NAME | PRICE |
| 0 | Iron Iron | 5.4 |
| 1 | Chair Shoe | 24.8 |
| 2 | Telephone Clock | 24.8 |
| 3 | Chair Chair | 25.4 |
| 4 | Ice Tea Shoe | 12.8 |
| 5 | Clock Clock | 23.6 |
| 6 | Ice Tea Chair | 9.8 |
| 7 | Telephone Shoe | 8.4 |
| 8 | Ice Tea Clock | 22.6 |
| 9 | Clock Telephone | 17.2 |
| 10 | Telephone Ice Tea | 20.4 |