Home » SQL & PL/SQL » SQL & PL/SQL » Convert Access commands into Oracle (Oracle 9i)
Convert Access commands into Oracle [message #355672] Mon, 27 October 2008 00:40 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

We are working on a migration project from MS-Access/Excel
to BO/Oracle.
Basically we need help in interpreting/converting macros
i.e. the commands which are in MS-Access queries I want to
convert the same into Oracle.
Some eg -
1. (((Sum(CDbl([Revenue Share Amount])))<>0)
2. ((IsNumeric([Revenue Share Amount]))=True)

Above is only some examples but actually there are many
complicated commands used in the codes.

Can anyone suggest any site wherein I can get help on converting access commands into oracle.

Thank you,
Re: Convert Access commands into Oracle [message #355678 is a reply to message #355672] Mon, 27 October 2008 01:18 Go to previous messageGo to next message
kolipaka
Messages: 7
Registered: October 2008
Junior Member
Please check with www.dbforums.com
Re: Convert Access commands into Oracle [message #355680 is a reply to message #355678] Mon, 27 October 2008 01:21 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

Please let me know the commands for this issue.

Thank you
Re: Convert Access commands into Oracle [message #355683 is a reply to message #355680] Mon, 27 October 2008 01:28 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Wow... You must be a fast reader.
Having read www.dbforums.com in three minutes.

I suppose you already did some searching before you came here (didn't you?), so it might as well be that there are no standard tools for migrating such macros.
Time to finally learn some PL/SQL. I'm sure that the formulas behind the standard mathematical functions in Access/Excel are quite easy to be found, so you might start recoding them in PL/SQL.
Previous Topic: Duplicate Report
Next Topic: How to create Tree for Assembly ?
Goto Forum:
  


Current Time: Wed Dec 07 18:33:05 CST 2016

Total time taken to generate the page: 0.08732 seconds