21st Century PL/SQL
Your chance to influence the direction of the Oracle PL/SQL language.
Data structures and datatypes > Numbers
Oracle offers a wide range of datatypes and associated functions to manipulate numbers.
Ideas within Numbers
| Top Vote Getters | Top Scorers |
|---|---|
September 24, 2005
Add a CURRENCY datatype
I realize this is sooner a database issue than a PL/SQL issue. I also realize that I can easily define my own datatype... but... it would be very useful in working with third-party products if there were an Oracle-defined CURRENCY(p, s) datatype. A product such as Crystal Reports (which we use extensively) would be able to immediately apply currency formatting when working with columns of this type. All other DBMSs have a CURRENCY (or MONEY) datatype. Why not Oracle?Posted by Kai-Joachim Kamrath at 03:05 PM | Add your thoughts (0)
Sidebar Template
Search Template
Search 21st Century PL/SQL
Actions Template
Actions
Ideas List Template
Browse Categories
- Built-in (Supplied) Packages
- DBMS_LOB
- DBMS_OUTPUT
- New built-in packages
- modplsql
- UTL_FILE
- UTL_MAIL
- Data structures and datatypes
- Built-in Procedures and Functions
- Collections
- adding two collections in runtime
- Dates, timestamps, intervals, etc.
- Numbers
- Object types
- String manipulation
- Exception handling
- exception
- General and Miscellaneous issues
- Loops, conditionals, other control logic
- Performance-related Issues
- Program unit construction and structure
- SQL processing inside PL/SQL
- Bulk processing FORALL and BULK COLLECT
- DML Operations (INSERT, UPDATE, DELETE)
- Dynamic SQL and Dynamic PL/SQL
- Querying data in PL/SQL
- Querying with REF CURSORS (cursor variables)
- Transaction management