Oracle-Developer.com Forums
A forum for discussing and sharing information about Oracle technologies
 
Navigation: Home  | Discussion Forums  |  Scripts  |  About Us  | Links  | Job Openings  | Blog  
 FAQFAQ   SearchSearch   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Email your Oracle questions to webmaster@oracle-developer.com to get Oracle 11g or Oracle E-Business expert advice.

New PL/SQL Data Type "simple_integer"

 
Post new topic   Reply to topic    Oracle-Developer.com Forums Forum Index -> Oracle 11g New Features Discussion
View previous topic :: View next topic  
Author Message
vj.jain
Site Admin


Joined: 10 Aug 2007
Posts: 85
PostPosted: Tue Nov 13, 2007 1:00 am    Post subject: New PL/SQL Data Type "simple_integer" Reply with quote
Oracle 11g has introduced a new data type called SIMPLE_INTEGER for improving performance when using native compilation. This data type is similar to PLS_INTEGER except that it is not checked for null or overflow values. When appropriate, using SIMPLE_INTEGER instead of PLS_INTEGER can yield significant performance improvements for your PL/SQL applications.


For more information about the "simple_integer" PL/SQL data type, read Oracle 11g New Features Guide by John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, and Brian Carr http://www.oracle-developer.com/oracle_11g_new_features.html
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Oracle-Developer.com Forums Forum Index -> Oracle 11g New Features Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Sponsored by Oracle Consulting

Copyright ©2007 Oracle-Developer.com