SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySql MAKEDATE function equivqlent

user565514Apr 2 2007 — edited Apr 2 2007

Dear all,

MySql offers the makedate() function which is to be used like:

makedate(year(fromTime), dayofyear(fromTime))

Oracle does not offer this function.

I'm trying to create such an equivalent function in Oracle with a statement like:

CREATE OR REPLACE FUNCTION MAKEDATE(...)

in the same spirit as in http://www.lamp2lapo.com/category/downloads/

Is it possible to have a user defined function with the same name as an Oracle native function..?

How to create that makedate function..?

Regards,

Stephane

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2007

Added on Apr 2 2007

6 comments

1,148 views