pl sql code on access DB

  • Thread starter Thread starter Archana
  • Start date Start date
A

Archana

Can we write and execute Pl/SQL procedures, functions and packages on access
database tables. I want to write a procedure which uses cursor and some
advance features of PL/SQL on access database.
 
Can we write and execute Pl/SQL procedures, functions and packages on access
database tables. I want to write a procedure which uses cursor and some
advance features of PL/SQL on access database.
Click to expand...

No.

PL/SQL is a part of the Oracle database system. It is proprietary to Oracle
and is not available in Oracle's competitor, Microsoft's, programming
environment.

On the other hand, Access includes VBA (Visual Basic for Applications) as an
integral part of the program, and you can do anything in VBA which can be done
in PL/SQL. You'll need to do it differently, since it's a different language
with a different conceptual framework, but the two languages are equally
capable.
 
Back
Top