mysql "Server=164.99.152.215;Database=mysql;User Id=sudha;Password=novell" DSN=Mysql-Test-DSN;uid=sudha;pwd=novell 3 numericTable 15 serialNo TINYINT UNSIGNED PRIMARY KEY unsigned_tinyInt TINYINT UNSIGNED signed_tinyInt TINYINT bit BIT bool BOOL unsigned_smallint SMALLINT UNSIGNED signed_smallint SMALLINT unsigned_mediumint MEDIUMINT UNSIGNED signed_mediumint MEDIUMINT unsigned_int INT UNSIGNED signed_int INT unsigned_integer INTEGER UNSIGNED signed_integer INTEGER unsigned_bigint BIGINT UNSIGNED signed_bigint BIGINT realNoTable 11 serialNo TINYINT UNSIGNED unsigned_float FLOAT(24) UNSIGNED signed_float FLOAT(24) unsigned_double_float FLOAT(25) UNSIGNED signed_double_float FLOAT(53) unsigned_double DOUBLE UNSIGNED signed_double DOUBLE unsigned_double_precision DOUBLE PRECISION UNSIGNED signed_real REAL unsigned_decimal DECIMAL(6,3) UNSIGNED signed_numeric NUMERIC(5,3) dateTable 6 serialNo TINYINT UNSIGNED dateField DATE datetimeField DATETIME timestampField TIMESTAMP timeField TIME yearField YEAR 3 numericTable 4 15 1 0 -128 -128 -128 0 -32768 0 -8388608 0 -2147483648 0 -2147483648 0 -9223372036854775808 2 100 50 100 100 3000 -300 500000 -100000 4000000 500000 4000000 500000 5000000000 -5000000000 3 255 127 127 127 65535 32767 16777215 8388607 4294967295 2147483647 4294967295 2147483647 18446744073709551615 9223372036854775807 4 null null null null null null null null null null null null null null 5 1 2 58 1 6 10 2 3 27 2 6 999 1 14 999 realNoTable 6 11 1 0 0 0 0 0 0 0 0 0 0 2 1.175494351E-38 -3.402823466E+38 1.175494351E-38 -1.797693134862315E+308 1.175494351E-38 -1.797693134862315E+308 1.175494351E-38 -1.797693134862315E+308 99.999 -23.456 3 3.402823466E+38 -1.175494351E-38 3.402823466E+38 -2.2250738585072014E-308 3.402823466E+38 -2.2250738585072014E-308 3.402823466E+38 -2.2250738585072014E-308 778.123 -99.999 4 1.2345E+20 1.175494351E-38 1.2345E+20 2.2250738585072014E-308 1.2345E+20 2.2250738585072014E-308 1.2345E+20 2.2250738585072014E-308 308.90 12.345 5 3.452E-19 3.402823466E+38 4.32E-15 1.797693134862315E+308 4.32E-15 1.797693134862315E+308 4.32E-15 1.797693134862315E+308 999.999 999.999 6 null null null null null null null null null null 1 1 2 67.58 1 5 1.58E+124 2 7 -1.58E-124 1 8 1.12238E-62 dateTable 9 6 1 '1000-01-01' '1000-01-01 00:00:00' '1970-01-02 00:00:00' '-23:59:59' 2004 2 '1999-12-17' '1999-12-17 08:00:00' '2000-01-01 04:40:00' '-23:45:56' 1999 3 '9999-12-31' '9999-12-31 23:59:59' '2037-12-31 23:59:59' '23:59:59' 2155 4 '1999@12@31' '1999@12@31 11+30+45' '1999@12@31 11+30+45' '12:23:34' 1901 5 '9999.11.18' '9999.11.18 11*45*50' '2037.11.18 11*45*50' '23:34:34' 2069 6 '9999/11/09' '9999/11/09 12:23:34' '2037/11/09 12:23:34' '09:08:07' 1970 7 19980404 19980404083050 19980404083050 083045 0000 8 '0000-00-00' '0000-00-00 00:00:00' 00000000000000 '00:00:00' 00 9 null null null null null 3 1 5 '12:23:34' 1 3 '2004-12-17 08:00:00' 1 6 1980 2 Select COLUMNS from TABLE1 order by COLUMN1 Select COLUMN1,COLUMN3,COLUMN5 from TABLE2 order by COLUMN1 Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 mssql Server=164.99.168.131;Database=northwind;User ID=sa;Password=novell; DSN=MsSQL-DSN;uid=sa;pwd=novell Y 5 numericTable 6 sNo tinyint bigInteger bigint integer int smallInteger smallint tinyInt tinyint bit bit dateTimeTable 3 sNo tinyInt date datetime smalldate smalldatetime realNosTable 5 sNo tinyInt decimalCol decimal(8,4) numericCol numeric(6,4) floatCol float realCol real moneyTable 3 sNo tinyInt money money smallmoney smallmoney charTable 5 sNo tinyInt characterCol char(20) ncharacterCol nchar(20) varchar varchar(20) nvarchar nvarchar(20) 5 numericTable 4 6 1 -9223372036854775808 -2147483648 -32768 0 0 2 1244 -50 234 128 0 3 9223372036854775807 2147483647 32767 255 1 4 null null null null null 5 1 2 -5678 1 6 10 2 3 234 3 5 -345 3 2 -999 dateTimeTable 3 3 1 '1/1/1753 03:04:05.234' '1/1/1970 12:24' 2 '12/31/9999 00:00:00' '6/6/2079 00:00' 3 null null realNosTable 6 5 1 -9.99E+3 -99 -1.7976931348623157E+308 -3.402823466E+38 2 -1.23E3 -12 -2.2250738585072014E-308 -3.4E-38 3 0 0 0 0 4 1.2E1 12 2.2250738585072014E-308 4.56E-3 5 9.999E3 99 1.7976931348623157E+308 3.4E+38 6 null null null null 1 6 4 1.2E34 moneyTable 4 3 1 -922337203685477.5808 -214748.3648 2 5477.5808 748.3648 3 922337203685477.5807 214748.3647 4 null null charTable 2 5 1 '12345678901234567890' 'abcdefghijklmnopqrst' 'zyxwvutsrqponmlkjihg' '12345678901234567890' 2 null null null null 1 generic Select_{{TABLE}}_proc 5 Select COLUMNS from TABLE1 order by COLUMN1 Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 Select COLUMNS from TABLE4 order by COLUMN1 Select COLUMNS from TABLE5 order by COLUMN1 postgres Server=164.99.168.144;Database=test;User Id=sudha;Password= DSN=postgres-DSN;uid=sudha;pwd= 5 numericTable 4 serialNo smallint small_int smallint int integer bigInteger bigint realNoTable 5 serialNo smallint numeric_column numeric(10,6) numeric_noscale decimal(10) realNo real doubleNo double precision charTable 4 serialNo smallint charColumn char(20) varcharColumn varchar(20) textColumn text dateTimeTable 5 serialNo smallint timestampCol timestamp intervalCol interval dateCol date timeCol time booleanTable 2 serialNo smallint bool boolean 5 numericTable 4 4 1 -32768 -2147483648 -9223372036854775808 2 123 -648 0 3 32767 2147483647 9223372036854775807 4 null null null 2 3 2 2000 2 3 2000000 realNoTable 6 5 1 -9999.999999 -9999999999 -9.99999E-38 -9.999999999999999E-308 2 -123.99 -1239 9.99999E-38 9.999999999999999E-308 3 0 0 0 0 4 123.99 123 -9.99999E37 -1.79769313486231E308 5 9999.999999 9999999999 9.99999E37 1.79769313486231E308 6 null null null null charTable 2 4 1 'abcdefghijklmnopqrst' '1234567890' 'This is a fixed length text' 2 null null null datetimeTable 4 5 1 '0001-01-01 00:00:00.000000' '-178000000 years +4 days' '0001-01-01' '12:23:34' 2 '2004-10-21 11:15:23' '7890 years 5 days 07:30' '2004-01-12' '00:00:00' 3 '9999-12-31 23:59:59.9999' '178000000 years 00:19:23' '9999-12-31' '23:59:59' 4 null null null null booleanTable 3 2 1 TRUE 2 FALSE 3 null 5 Select COLUMNS from TABLE1 order by COLUMN1 Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 Select COLUMNS from TABLE4 order by COLUMN1 Select COLUMNS from TABLE5 order by COLUMN1 oracle Data Source=testdb.com;User Id=user9i;Password=oracle9i DSN=Oracle-DSN;uid=user9i;pwd=oracle9i Y 4 numericTable 3 serialNo number(1) intCol number(6) decimalCol number(6, 3) charTable 5 serialNo number(1) charCol char(10) ncharCol nchar(10) varcharCol varchar2(10) nvarcharCol nvarchar2(10) RealNoTable 2 serialNo number(1) floatCol float(24) DateTimeTable 5 serialNo number(1) dateCol date timestampCol timestamp Int_year interval Year to month int_day interval day to second 4 numericTable 4 3 1 -999999 -999.999 2 1000 234 3 999999 999.999 4 null null charTable 2 5 1 '0123456789' 'abcdefghij' '0123456789' 'abcdefghij' 2 null null null null RealNoTable 6 2 1 9.9999999E125 2 -9.999999E-126 3 1.23E-15 4 -9.999999E-126 5 9.9999999E125 6 null DateTimeTable 3 5 1 to_date('0001-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'0001-01-01 00:00:00' '-99-11' '-99 23:59:59' 2 to_date('2004-11-23 12:34:45', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'2004-11-23 12:34:45' '34-5' '-34 20:50:00' 3 to_date('9999-12-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'9999-12-31 23:59:59' '99-11' '00 23:59:59' 1 generic {{TABLE}}_pkg.Select_{{TABLE}}_data 4 Select COLUMNS from TABLE1 order by COLUMN1 Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 Select COLUMNS from TABLE3 order by COLUMN1 Select COLUMNS from TABLE4 order by COLUMN1