| blob | ebf1100e6ba5d1c8b904e96fe42ad40492884b92 |
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 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
15 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
16 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
17 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0
18 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
19 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
20 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0
21 18 2038 444455555 nishant 244.718002 888888888.999999 2040/12/25 4:42:35.0 2031/12/25 4:42:35.0
22 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0
23 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0
25 +---------------------------------------+
26 | Connected! |
27 | |
28 | sql-statement |
29 | help [tablename] |
30 | quit |
31 | |
32 +---------------------------------------+
33 SQL> +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
34 | f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 |
35 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
36 | 1 | 2011 | 111111111 | Govind | 113.141 | 111111111.111111 | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
37 | 2 | 1978 | 222222222 | Gopal | 114.567 | 222222222.222222 | 1926-05-16| 12:32:14| 1972-05-16 12:32:14|
38 | 3 | 2008 | 333333333 | kishor | 122.7 | 333333333.333333 | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
39 | 4 | 1973 | 444444444 | kiran | 142.718 | 444444444.444444 | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
40 | 5 | 2005 | 555555555 | ganesh | 152.718 | 555555555.555555 | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
41 | 6 | 1962 | 666666666 | suresh | 162.718 | 666666666.666666 | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
42 | 7 | 1965 | 777777777 | Praba | 172.718 | 777777777.777777 | 1975-12-25| 17:42:35| 1977-12-25 17:42:35|
43 | 8 | 1942 | 888888888 | karan | 182.718 | 888888888.888888 | 1985-12-25| 18:42:35| 1978-12-25 18:42:35|
44 | 9 | 1956 | 999999999 | sharan | 192.718 | 999999999.999999 | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
45 | 10 | 1999 | 101010101 | vijay | 102.718 | 111111111.999999 | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
46 | 11 | 2010 | 121212121 | Prasad | 112.718 | 111111111.222222 | 2005-12-25| 21:42:35| 2005-12-25 21:42:35|
47 | 12 | 2069 | 131313131 | jiten | 122.718 | 222222222.333333 | 2025-12-25| 22:42:35| 2025-12-25 22:42:35|
48 | 13 | 1857 | 141414141 | hiten | 132.718 | 333333333.444444 | 2035-12-25| 23:42:35| 2035-12-25 23:42:35|
49 | 14 | 1545 | 151515151 | methane | 126.718 | 444444444.555555 | 2045-12-25| 00:42:35| 2032-12-25 00:42:35|
50 | 15 | 1889 | 161616161 | ethane | 211.718 | 555555555.222222 | 2065-12-25| 01:42:35| 2005-12-25 01:42:35|
51 | 16 | 1789 | 171717171 | sanjay | 222.718 | 666666666.777777 | 2010-12-25| 02:42:35| 2010-12-25 02:42:35|
52 | 17 | 2032 | 181818181 | vikrant | 233.718 | 777777777.888888 | 2020-12-25| 03:42:35| 2020-12-25 03:42:35|
53 | 18 | 2038 | 444455555 | nishant | 244.718 | 888888888.999999 | 2040-12-25| 04:42:35| 2031-12-25 04:42:35|
54 | 19 | 2048 | 777755555 | Sushant | 277.718 | 333333333.999999 | 2023-12-25| 05:42:35| 2011-12-25 04:42:35|
55 | 20 | 1994 | 666633333 | vishnu | 255.718 | 333333333.666666 | 2030-12-25| 06:42:35| 2030-12-25 05:42:35|
56 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
57 SQLRowCount returns 20
58 20 rows fetched
59 SQL> ---------------------------------------------------------
60 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
61 ---------------------------------------------------------
62 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
63 5 2005 555555555 ganesh 152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
64 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
65 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
66 20 1994 666633333 vishnu 255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0
68 ---------------------------------------------------------
69 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
70 ---------------------------------------------------------
71 7 1965 777777777 Praba 172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
72 8 1942 888888888 karan 182.718002 888888888.888888 1985/12/25 18:42:35.0 1978/12/25 18:42:35.0
73 9 1956 999999999 sharan 192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
74 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
75 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
76 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
77 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
78 14 1545 151515151 methane 126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0
79 15 1889 161616161 ethane 211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
81 ---------------------------------------------------------
82 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
83 ---------------------------------------------------------
84 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
85 4 1973 444444444 kiran 142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
86 7 1965 777777777 Praba 172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
87 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
88 13 1857 141414141 hiten 132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
89 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
90 19 2048 777755555 Sushant 277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0
92 ---------------------------------------------------------
93 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
94 ---------------------------------------------------------
95 1 2011 111111111 Govind 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
96 2 1995 222222222 Gopal 114.567001 222222222.222222 1926/5/16 12:32:14.0 1971/12/25 11:42:35.0
97 3 2008 333666999 kishor 122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0
98 4 1973 444444444 poonam 142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
99 5 2005 555555555 ganesh 152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
100 6 1962 666666666 suresh 162.718002 666666666.666666 1965/12/25 16:42:35.0 1976/12/25 16:42:35.0
101 7 1965 777777777 Praba 172.718002 777777777.777777 1978/9/12 17:42:35.0 1977/12/25 17:42:35.0
102 8 1942 888888888 karan 182.718002 888888888.888888 1985/12/25 12:34:56.0 1978/12/25 18:42:35.0
103 9 1956 999999999 sharan 192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
104 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
105 11 2010 121212121 Prasad 112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
106 12 2069 131313131 jiten 122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
107 16 1789 171717171 sanjay 222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
108 17 2032 181818181 vikrant 233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0
110 +---------------------------------------+
111 | Connected! |
112 | |
113 | sql-statement |
114 | help [tablename] |
115 | quit |
116 | |
117 +---------------------------------------+
118 SQL> +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
119 | f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 |
120 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
121 | 1 | 2011 | 111111111 | Govind | 113.141 | 111111111.111111 | 1915-12-25| 11:42:35| 1971-12-25 11:42:35|
122 | 2 | 1995 | 222222222 | Gopal | 114.567 | 222222222.222222 | 1926-05-16| 12:32:14| 1971-12-25 11:42:35|
123 | 3 | 2008 | 333666999 | kishor | 122.7 | 333333333.333333 | 1937-08-15| 13:45:36| 1973-08-15 13:45:36|
124 | 4 | 1973 | 444444444 | poonam | 142.718 | 444444444.444444 | 1946-12-25| 14:42:35| 1974-12-25 14:42:35|
125 | 5 | 2005 | 555555555 | ganesh | 152.718 | 555555555.555555 | 1955-12-25| 15:42:35| 1975-12-25 15:42:35|
126 | 6 | 1962 | 666666666 | suresh | 162.718 | 666666666.666666 | 1965-12-25| 16:42:35| 1976-12-25 16:42:35|
127 | 7 | 1965 | 777777777 | Praba | 172.718 | 777777777.777777 | 1978-09-12| 17:42:35| 1977-12-25 17:42:35|
128 | 8 | 1942 | 888888888 | karan | 182.718 | 888888888.888888 | 1985-12-25| 12:34:56| 1978-12-25 18:42:35|
129 | 9 | 1956 | 999999999 | sharan | 192.718 | 999999999.999999 | 1995-12-25| 19:42:35| 1979-12-25 19:42:35|
130 | 10 | 1999 | 101010101 | vijay | 102.718 | 111111111.999999 | 1915-12-25| 20:42:35| 1980-12-25 20:42:35|
131 | 11 | 2010 | 121212121 | Prasad | 112.718 | 111111111.222222 | 2005-12-25| 21:42:35| 2005-12-25 21:42:35|
132 | 12 | 2069 | 131313131 | jiten | 122.718 | 222222222.333333 | 2025-12-25| 22:42:35| 2025-12-25 22:42:35|
133 | 16 | 1789 | 171717171 | sanjay | 222.718 | 666666666.777777 | 2010-12-25| 02:42:35| 2010-12-25 02:42:35|
134 | 17 | 2032 | 181818181 | vikrant | 233.718 | 777777777.888888 | 2020-12-25| 03:42:35| 2020-12-25 03:42:35|
135 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
136 SQLRowCount returns 14
137 14 rows fetched
138 SQL>