Forum: Orafce 3.0.0 Released

Posted by: Takahiro Itagaki
Date: 2009-07-21 14:34
Summary:Orafce 3.0.0 Released
Project:Better Oracle functions support

The goal of orafce project is to implemente some functions from Oracle database. Some date functions, string functions and some module packages are implemented now. In 3.0, functions listed below are newly added and compatibility of existing functions are much improved.

There are documentations of orafce:
* English : http://www.postgres.cz/index.php/Oracle_functionality_(en)
* Czech : http://www.postgres.cz/index.php/Oracle_functionality
* Japanese : http://orafce.projects.postgresql.org/index-ja.html

---- list of new functions in 3.0 ----
next_day(value, weekday integer)
to_char(num)
to_number(str)
to_date(str)
to_multi_byte(str)
bitand(lhs, rhs)
sinh(rad)
cosh(rad)
tanh(rad)
nanvl(val, alt)
dump(...)
decode(...)
utl_file.frename(location, filename, dest_dir, dest_file, overwrite)
utl_file.fcopy(src_location, src_filename, dest_location, dest_filename, start_line, end_line)
utl_file.fgetattr(location, filename)
utl_file.tmpdir()
dbms_assert.enquote_literal(str)
dbms_assert.enquote_name(str, loweralize)
dbms_assert.enquote_name(str)
dbms_assert.noop(str)
dbms_assert.schema_name(str)
dbms_assert.object_name(str)
dbms_assert.simple_sql_name(str)
dbms_assert.qualified_sql_name(str)
plunit.assert_true(condition, message)
plunit.assert_false(condition, message)
plunit.assert_null(actual, message)
plunit.assert_not_null(actual, message)
plunit.assert_equals(expected, actual, range, message)
plunit.assert_not_equals(expected, actual, range, message)
plunit.fail(message)

Sponsors Ads

Latest News

GIT repository

Gabriele Bartolini - 2012-06-22 10:21 -

Orafce 3.0.0 Released

Takahiro Itagaki - 2009-07-21 14:34 -

Orafce in Debian

Peter Eisentraut - 2007-10-24 20:58 -

Orafce rpm's are available

Pavel Stehule - 2007-10-09 15:45 -

New minor version Orafce

Pavel Stehule - 2007-03-04 23:25 -
Monitor Forum | Start New Thread Start New Thread
Powered By FusionForge