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 base2 to represent a number, whereas NUMBER uses decimal base10. The base used to represent a number affects how rounding occurs for that number. For example, a decimal floatingpoint number is rounded to the nearest decimal place, but a binary floatingpoint 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



Goto Forum:
Current Time: Mon Feb 27 03:15:04 CST 2017
Total time taken to generate the page: 0.08829 seconds
