test/cache/Gateway/exp.test002.ksh

   1 +---------------------------------------+
   2 | Connected!                            |
   3 |                                       |
   4 | sql-statement                         |
   5 | help [tablename]                      |
   6 | quit                                  |
   7 |                                       |
   8 +---------------------------------------+
   9 \e[?1034hSQL> select * from t1;
  10 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  11 | f1   | f2        | f3                  | f4        | f5            | f6                      | f7        | f8      | f9                 |
  12 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  13 | 1    | 2011      | 111111111           | Govind    | 113.141       | 111111111.111111        | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
  14 | 2    | 1978      | 222222222           | Gopal     | 114.567       | 222222222.222222        | 1926-05-16| 12:32:14| 1972-05-16 12:32:14|
  15 | 3    | 2008      | 333333333           | kishor    | 122.7         | 333333333.333333        | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
  16 | 4    | 1973      | 444444444           | kiran     | 142.718       | 444444444.444444        | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
  17 | 5    | 2005      | 555555555           | ganesh    | 152.718       | 555555555.555555        | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
  18 | 6    | 1962      | 666666666           | suresh    | 162.718       | 666666666.666666        | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
  19 | 7    | 1965      | 777777777           | Praba     | 172.718       | 777777777.777777        | 1975-12-25| 17:42:35| 1977-12-25 17:42:35|
  20 | 8    | 1942      | 888888888           | karan     | 182.718       | 888888888.888888        | 1985-12-25| 18:42:35| 1978-12-25 18:42:35|
  21 | 9    | 1956      | 999999999           | sharan    | 192.718       | 999999999.999999        | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
  22 | 10   | 1999      | 101010101           | vijay     | 102.718       | 111111111.999999        | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
  23 | 11   | 2010      | 121212121           | Prasad    | 112.718       | 111111111.222222        | 2005-12-25| 21:42:35| 2005-12-25 21:42:35|
  24 | 12   | 2069      | 131313131           | jiten     | 122.718       | 222222222.333333        | 2025-12-25| 22:42:35| 2025-12-25 22:42:35|
  25 | 13   | 1857      | 141414141           | hiten     | 132.718       | 333333333.444444        | 2035-12-25| 23:42:35| 2035-12-25 23:42:35|
  26 | 14   | 1545      | 151515151           | methane   | 126.718       | 444444444.555555        | 2045-12-25| 00:42:35| 2032-12-25 00:42:35|
  27 | 15   | 1889      | 161616161           | ethane    | 211.718       | 555555555.222222        | 2065-12-25| 01:42:35| 2005-12-25 01:42:35|
  28 | 16   | 1789      | 171717171           | sanjay    | 222.718       | 666666666.777777        | 2010-12-25| 02:42:35| 2010-12-25 02:42:35|
  29 | 17   | 2032      | 181818181           | vikrant   | 233.718       | 777777777.888888        | 2020-12-25| 03:42:35| 2020-12-25 03:42:35|
  30 | 18   | 2038      | 444455555           | nishant   | 244.718       | 888888888.999999        | 2040-12-25| 04:42:35| 2031-12-25 04:42:35|
  31 | 19   | 2048      | 777755555           | Sushant   | 277.718       | 333333333.999999        | 2023-12-25| 05:42:35| 2011-12-25 04:42:35|
  32 | 20   | 1994      | 666633333           | vishnu    | 255.718       | 333333333.666666        | 2030-12-25| 06:42:35| 2030-12-25 05:42:35|
  33 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  34 SQLRowCount returns 20
  35 20 rows fetched
  36 SQL> +---------------------------------------+
  37 | Connected!                            |
  38 |                                       |
  39 | sql-statement                         |
  40 | help [tablename]                      |
  41 | quit                                  |
  42 |                                       |
  43 +---------------------------------------+
  44 \e[?1034hSQL> select * from t1;
  45 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  46 | f1   | f2        | f3                  | f4        | f5            | f6                      | f7        | f8      | f9                 |
  47 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  48 | 1    | 2011      | 111111111           | Govind    | 113.141       | 111111111.111111        | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
  49 | 2    | 1995      | 222222222           | Gopal     | 114.567       | 222222222.222222        | 1926-05-16| 12:32:14| 1971-12-25 11:42:35|
  50 | 3    | 2008      | 333666999           | kishor    | 122.7         | 333333333.333333        | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
  51 | 4    | 1973      | 444444444           | poonam    | 142.718       | 444444444.444444        | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
  52 | 5    | 2005      | 555555555           | ganesh    | 152.718       | 555555555.555555        | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
  53 | 6    | 1962      | 666666666           | suresh    | 162.718       | 666666666.666666        | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
  54 | 7    | 1965      | 777777777           | Praba     | 172.718       | 777777777.777777        | 1978-09-12| 17:42:35| 1977-12-25 17:42:35|
  55 | 8    | 1942      | 888888888           | karan     | 182.718       | 888888888.888888        | 1985-12-25| 12:34:56| 1978-12-25 18:42:35|
  56 | 9    | 1956      | 999999999           | sharan    | 192.718       | 999999999.999999        | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
  57 | 10   | 1999      | 101010101           | vijay     | 102.718       | 111111111.999999        | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
  58 | 11   | 2010      | 121212121           | Prasad    | 112.718       | 111111111.222222        | 2005-12-25| 21:42:35| 2005-12-25 21:42:35|
  59 | 12   | 2069      | 131313131           | jiten     | 122.718       | 222222222.333333        | 2025-12-25| 22:42:35| 2025-12-25 22:42:35|
  60 | 16   | 1789      | 171717171           | sanjay    | 222.718       | 666666666.777777        | 2010-12-25| 02:42:35| 2010-12-25 02:42:35|
  61 | 17   | 2032      | 181818181           | vikrant   | 233.718       | 777777777.888888        | 2020-12-25| 03:42:35| 2020-12-25 03:42:35|
  62 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
  63 SQLRowCount returns 14
  64 14 rows fetched
  65 SQL>