definitely have a look at the oracle migration workbench which will convert
access databases to oarcle ones for you. It may not always do perfect
conversions, but you'll see the sort of things you need to produce (like
trigger/sequence combos for autoniumber fields and so on).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**
"JCR" <jrappa_at_hammer.net> wrote in message
news:12a73e0d.0108091236.3658fa6b_at_posting.google.com...
> Hi all, In the coming months, I will have to convert ACCESS database
> queries to ORACLE's stored procedures, triggers, etc...Possibly some
> Front-end with forms (which I am also currently learning) also. Aside
> from practicing from book examples, I have not created or written any
> code using Oracles stored procedures for any type of application.
>
> Basically, can any of you nice people out there offer me any other
> advice regarding converting "ACCESS to ORACLE" to someone like myself,
> who is relying on the web and books? I know very little, if anything,
> about ACCESS. Any form of advice, notes, or web sites would be greatly
> appreciated.
>
> Thanks in advance
Received on Fri Aug 10 2001 - 05:47:48 CDT
