test/sqlgw/Select/exp.test009.ksh

   1 Inserting records into table T1
   2 5 rows inserted into table T1
   3 Inserting records into table T2
   4 5 rows inserted into table T2
   5 Inserting records into table T3
   6 5 rows inserted into table T3
   7 +---------------------------------------+
   8 | Connected!                            |
   9 |                                       |
  10 | sql-statement                         |
  11 | help [tablename]                      |
  12 | quit                                  |
  13 |                                       |
  14 +---------------------------------------+
  15 \e[?1034hSQL> SELECT * FROM T1;
  16 +-----------+-----------------------------------+
  17 | f1        | f2                                |
  18 +-----------+-----------------------------------+
  19 | 0         | lakshya                           |
  20 | 1         | lakshya                           |
  21 | 2         | lakshya                           |
  22 | 3         | lakshya                           |
  23 | 4         | lakshya                           |
  24 +-----------+-----------------------------------+
  25 SQLRowCount returns 5
  26 5 rows fetched
  27 SQL> SELECT * FROM T2;
  28 +-----------+-----------------------------------+
  29 | f1        | f2                                |
  30 +-----------+-----------------------------------+
  31 | 5         | lakshya                           |
  32 | 6         | lakshya                           |
  33 | 7         | lakshya                           |
  34 | 8         | lakshya                           |
  35 | 9         | lakshya                           |
  36 +-----------+-----------------------------------+
  37 SQLRowCount returns 5
  38 5 rows fetched
  39 SQL> SELECT * FROM T3;
  40 +-----------+-----------------------------------+
  41 | f1        | f2                                |
  42 +-----------+-----------------------------------+
  43 | 10        | lakshya                           |
  44 | 11        | lakshya                           |
  45 | 12        | lakshya                           |
  46 | 13        | lakshya                           |
  47 | 14        | lakshya                           |
  48 +-----------+-----------------------------------+
  49 SQLRowCount returns 5
  50 5 rows fetched
  51 SQL> ---------------------------------------------------------
  52         T1.f1   T1.f2
  53 ---------------------------------------------------------
  54         0       lakshya
  55         1       lakshya
  56         2       lakshya
  57         3       lakshya
  58         4       lakshya
  59
  60 ---------------------------------------------------------
  61         T2.f1   T2.f2
  62 ---------------------------------------------------------
  63         5       lakshya
  64         6       lakshya
  65         7       lakshya
  66         8       lakshya
  67         9       lakshya
  68
  69 ---------------------------------------------------------
  70         T3.f1   T3.f2
  71 ---------------------------------------------------------
  72         10      lakshya
  73         11      lakshya
  74         12      lakshya
  75         13      lakshya
  76         14      lakshya
  77