test/cache/Gateway/exp.test005.ksh

   1 ---------------------------------------------------------
   2         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
   3 ---------------------------------------------------------
   4         1       2011    111111111       Govind  113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0
   5         2       1978    222222222       Gopal   114.567001      222222222.222222        1926/5/16       12:32:14.0      1972/5/16 12:32:14.0
   6         3       2008    333333333       kishor  122.699997      333333333.333333        1937/8/15       13:45:36.0      1973/8/15 13:45:36.0
   7         4       1973    444444444       kiran   142.718002      444444444.444444        1946/12/25      14:42:35.0      1974/12/25 14:42:35.0
   8         5       2005    555555555       ganesh  152.718002      555555555.555555        1955/12/25      15:42:35.0      1975/12/25 15:42:35.0
   9         6       1962    666666666       suresh  162.718002      666666666.666666        1965/12/25      16:42:35.0      1976/12/25 16:42:35.0
  10         7       1965    777777777       Praba   172.718002      777777777.777777        1975/12/25      17:42:35.0      1977/12/25 17:42:35.0
  11         8       1942    888888888       karan   182.718002      888888888.888888        1985/12/25      18:42:35.0      1978/12/25 18:42:35.0
  12         9       1956    999999999       sharan  192.718002      999999999.999999        1995/12/25      19:42:35.0      1979/12/25 19:42:35.0
  13         10      1999    101010101       vijay   102.718002      111111111.999999        1915/12/25      20:42:35.0      1980/12/25 20:42:35.0
  14
  15 ---------------------------------------------------------
  16         lower(f4)
  17 ---------------------------------------------------------
  18         govind
  19         gopal
  20         kishor
  21         kiran
  22         ganesh
  23         suresh
  24         praba
  25         karan
  26         sharan
  27         vijay
  28
  29 ---------------------------------------------------------
  30         upper(f4)
  31 ---------------------------------------------------------
  32         GOVIND
  33         GOPAL
  34         KISHOR
  35         KIRAN
  36         GANESH
  37         SURESH
  38         PRABA
  39         KARAN
  40         SHARAN
  41         VIJAY
  42
  43 ---------------------------------------------------------
  44         length(f4)
  45 ---------------------------------------------------------
  46         6
  47         5
  48         6
  49         5
  50         6
  51         6
  52         5
  53         5
  54         6
  55         5
  56
  57 ---------------------------------------------------------
  58         substr(f4, 1, 4)
  59 ---------------------------------------------------------
  60         Govi
  61         Gopa
  62         kish
  63         kira
  64         gane
  65         sure
  66         Prab
  67         kara
  68         shar
  69         vija
  70
  71 ---------------------------------------------------------
  72         lpad(f4, 10 , '*')
  73 ---------------------------------------------------------
  74         ****Govind
  75         *****Gopal
  76         ****kishor
  77         *****kiran
  78         ****ganesh
  79         ****suresh
  80         *****Praba
  81         *****karan
  82         ****sharan
  83         *****vijay
  84
  85 ---------------------------------------------------------
  86         rpad(f4, 10 , '*')
  87 ---------------------------------------------------------
  88         Govind****
  89         Gopal*****
  90         kishor****
  91         kiran*****
  92         ganesh****
  93         suresh****
  94         Praba*****
  95         karan*****
  96         sharan****
  97         vijay*****
  98