Format of data types in Oracle
From: <mserafino_at_ameritrade.com>
Date: 1997/06/20
Message-ID: <866830019.7446_at_dejanews.com>#1/1
Date: 1997/06/20
Message-ID: <866830019.7446_at_dejanews.com>#1/1
How can i select a double as an int in oracle?
I am try to create an SQL statement that looks like:
select x from table_y;
SQL Server has a convert function so I could say
select convert(int,x) from table_y
Also how would you get oracle to accept special characters (such as [ ] #
) in a text field, is there an escape sequence to put in the string?
thanks!
For example: I get 5.53e5 when i want to see 55338.
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Fri Jun 20 1997 - 00:00:00 CEST