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