Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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?
0
yongsing
Asked:
yongsing
  • 2
1 Solution
 
deva_kumarCommented:
Oracle support all the above

1. PL/SQL for Static SQL

2. Dynamic SQL - Using DBMS_SQL Package

3. OCI - Oracle Call Interface (like API programing)

0
 
deva_kumarCommented:
Oracle support all the above

1. PL/SQL for Static SQL

2. Dynamic SQL - Using DBMS_SQL Package

3. OCI - Oracle Call Interface (like API programing)

0
 
yongsingAuthor Commented:
>> 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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now