<div>
What is the datatype of transaction_id?
</div>


<div>
Can you also post a describe on the discount and transaction tables?
</div>


<div>
<br />
CREATE TABLE DISCOUNT:<br />
&nbsp; TRANSACTION_ID &nbsp; &nbsp;NUMBER(22) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOT NULL,<br />
<br />
CREATE TABLE TRANSACTION:<br />
TRANSACTION_ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NUMBER(22) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOT NULL,
</div>


<div>
select to_char(transaction_id,'99<wbr />9999999999<wbr />9999999999<wbr />99999') from discount<br />
where transaction_id &gt;= &nbsp;21199857657768100 and transaction_id &lt;= 21199857657768200
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I See the data in the databas table (From Toad) as follows.<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />Discount table data diplays as follows.<br />
CUSTOMER_NO &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TRANSACTION_ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISCOUNT_BALANCE<br />
123456789 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.11998576577681E17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--<br />
<br />
1.select * from discount &nbsp; where transaction_id=2.119985765<wbr />77681E17 doesn't fetch any records even though it is available in the database <br />
<br />
2.And Join conditions &nbsp;like &nbsp;DISCOUNT.TRANSACTION_ID=TR<wbr />ANSACTION.<wbr />TRANSACTIO<wbr />N_ID &nbsp;will give me problem?<br />
<br />
Please help.It is very Important and urgent Issue.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>
</div>


Hi,

I See the data in the databas table (From Toad) as follows.
--------------------------------------------------------Discount table data diplays as follows.
CUSTOMER_NO	TRANSACTION_ID	               DISCOUNT_BALANCE
123456789	                          2.11998576577681E17                                  5
--------------------------------------------------------------------------------------------------

1.select * from discount   where transaction_id=2.11998576577681E17 doesn't fetch any records even though it is available in the database 

2.And Join conditions  like  DISCOUNT.TRANSACTION_ID=TRANSACTION.TRANSACTION_ID  will give me problem?

Please help.It is very Important and urgent Issue.









How to convert   Exponential Value to exact number in oracle database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.