yongsing
asked on
Database programming on Oracle & Sybase
In DB2, for database programming, we can use:
1) Embedded Static SQL,
2) Embedded Dynamic SQL,
3) Call Level Interface (CLI), which is based on Microsoft's ODBC.
My questions are:
1. If I were to move to Oracle or Sybase, do I still have these choices?
2. Which are the preferred (or commonly used) methods?
1) Embedded Static SQL,
2) Embedded Dynamic SQL,
3) Call Level Interface (CLI), which is based on Microsoft's ODBC.
My questions are:
1. If I were to move to Oracle or Sybase, do I still have these choices?
2. Which are the preferred (or commonly used) methods?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>> 1. PL/SQL for Static SQL
It seems that the Oracle's equivalent of DB2's embedded static SQL is called Pro *C/C++. I don't know what's DB2's equivalent of PL/SQL.
It seems that the Oracle's equivalent of DB2's embedded static SQL is called Pro *C/C++. I don't know what's DB2's equivalent of PL/SQL.
1. PL/SQL for Static SQL
2. Dynamic SQL - Using DBMS_SQL Package
3. OCI - Oracle Call Interface (like API programing)