data.sql

The goal of this library is to make ODBC recordsets look just like an STL container. As a user, you

INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
1, 'Example', 3, 56,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
2, 'Foozle', 7.7, 12,  TO_Date( '12/04/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
3, 'Bedazzled', 12, 99,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
4, 'Example', 11.11, 44,  TO_Date( '02/28/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
7, 'Example', 21.11, 21,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
10, 'Settled', 100.11, -1,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
11, 'Example', 0, 0,  TO_Date( '10/31/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
12, 'Mirror Image', 31.13, 22,  TO_Date( '12/04/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
6, 'Find Me', 22.22, 22,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
10, 'Find Me', 34.44, 41,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
6, 'Jordan', 1000.1, 1,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
8, 'Corwin', 99.99, 100,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
17, 'To find', 213, 34,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
18, 'Duped', -12.22, -99,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
19, 'Mike', -43334, 2122,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
20, 'To find', 2020.2, 2,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
21, 'Do not find', 22, 22,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
22, 'To find', 443.33, 32,  TO_Date( '12/04/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
23, 'Who?', 0, 0,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
28, 'To find', 11.11, 38,  TO_Date( '12/04/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
29, 'Prayer', 912.22, -3,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
30, 'The Reliable, Red Caminus Bouncy Ball', 1000.11, 10,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
31, 'To find', 0, 110,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
32, 'Example', 1, 109,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
3, 'Join Example', 33, 33,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
3, 'Join Example', 333, 333,  TO_Date( '11/11/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
1, 'Find Me', 44.44, 44,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
15, 'Find Me', 11, 25,  TO_Date( '12/04/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
3, 'Find Me', 88.88, 88,  TO_Date( '01/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
23, 'To find', 54.21, 9,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
28, 'To find', 1.11, 1,  TO_Date( '02/13/1988 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
INSERT INTO DB_EXAMPLE ( INT_VALUE, STRING_VALUE, DOUBLE_VALUE, EXAMPLE_LONG,
EXAMPLE_DATE ) VALUES ( 
77, 'Blah', 3.21, 2,  TO_Date( '07/07/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')); 
commit;
 
INSERT INTO DB_SAMPLE ( SAMPLE_LONG, SAMPLE_INT, SAMPLE_STR,
EXTRA_FLOAT ) VALUES ( 
3434, 4, 'Joined Tables', 100); 
INSERT INTO DB_SAMPLE ( SAMPLE_LONG, SAMPLE_INT, SAMPLE_STR,
EXTRA_FLOAT ) VALUES ( 
2222, 1, 'Joined Tables', 11); 
INSERT INTO DB_SAMPLE ( SAMPLE_LONG, SAMPLE_INT, SAMPLE_STR,
EXTRA_FLOAT ) VALUES ( 
1111, 1, 'Also Joined', 99); 
INSERT INTO DB_SAMPLE ( SAMPLE_LONG, SAMPLE_INT, SAMPLE_STR,
EXTRA_FLOAT ) VALUES ( 
22, 3, 'Blah', 123); 
INSERT INTO DB_SAMPLE ( SAMPLE_LONG, SAMPLE_INT, SAMPLE_STR,
EXTRA_FLOAT ) VALUES ( 
18, 12, 'Foo', 0); 
commit;
 
insert into DB_EXAMPLE_BACKUP select * from DB_EXAMPLE;
commit;