Home » SQL & PL/SQL » SQL & PL/SQL » sql features
sql features [message #192700] Wed, 13 September 2006 05:24
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi friends,

these r things i read abt 10g features,

i understood some of them , but for this i dnt find any examples.
if u guys knows anything about this,it will be very useful for me.

I need some queries using features ...

Closed operations Arithmetic operations involving BINARY_FLOAT and BINARY_DOUBLE are closed, which means that either a number or a special value is returned. For example, if you divide a BINARY_FLOAT by another BINARY_FLOAT, a BINARY_FLOAT is returned.

Transparent rounding BINARY_FLOAT and BINARY_DOUBLE use binary base-2 to represent a number, whereas NUMBER uses decimal base-10. The base used to represent a number affects how rounding occurs for that number. For example, a decimal floating-point number is rounded to the nearest decimal place, but a binary floating-point number is rounded to the nearest binary place.

New for Oracle10g. Matches the NaN special value, which means “not a number”

New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values

thanx and regards


Previous Topic: how to create database in oracle
Next Topic: Hierarchical View of Query
Goto Forum:

Current Time: Wed Aug 23 22:08:40 CDT 2017

Total time taken to generate the page: 0.01662 seconds