|
Replies:
0
-
Pages:
1
|
|
|
Posts:
2
Registered:
12/1/10
|
|
|
|
doubt about the result shown by toad editor
Posted:
Dec 13, 2010 4:18 AM
|
|
|
when i am executing the following query it is displaying the correct result.
select concat('Kiran',' Polard');
result is
Kiran Polard
But when i am putting columns in place of strings. It is showing result is Excluded for all the row and then asking to display the result toad will execute the total query once again.then it is showing the hexadecimal values. the query is
select CONCAT(class_id, section) ClassName from class_sections;
the table is filled with data. the result is as follows--
It is showing (Excluded ) for all the rows
ClassName
(Excluded)
(Excluded)
(Excluded)
then to fetch the data it asking to execute once again after that the values are like as below
ClassName
<table border="0" cellspacing="0" cellpadding="0" width="88" style="width: 66pt; border-collapse: collapse"> <tbody> <tr height="17" style="height: 12.75pt"> <td width="88" height="17" style="background-color: transparent; width: 66pt; height: 12.75pt; border: #ece9d8">0x3141</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3142</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3241</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3242</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3341</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3342</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3441</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3442</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3541</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3542</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3641</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3642</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3741</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3742</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3841</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3842</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3941</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3942</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x313041</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3143</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3144</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3145</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3146</td> </tr> <tr height="17" style="height: 12.75pt"> <td height="17" style="background-color: transparent; height: 12.75pt; border: #ece9d8">0x3147</td> </tr> </tbody></table>
these are the results. i donot understand why these type of results are coming.please reply.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
