Home » SQL & PL/SQL » SQL & PL/SQL » sql features
sql features [message #192700] Wed, 13 September 2006 05:24
selvakumar_82
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.

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

IS INFINITE
New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values

thanx and regards

Selva.R

Previous Topic: Timeout occured while trying to LOCK object
Next Topic: how to create database in oracle
Goto Forum:
  


Current Time: Tue Dec 06 02:55:12 CST 2016

Total time taken to generate the page: 0.09670 seconds