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
1
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
2
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