Oracle question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Oracle question

Oracle question# Database - 数据库

h*r2001-03-20 08:03

1 楼

Is ORACLE support pointer type? somebody told me using it
will greatly
increase the performance.
Some big shrimp can give some introduction on it?

s*e2001-03-20 08:03

2 楼

In fact, POINTER is not the basic data type of ORACLE.
Orcacle support NUMERIC and VARCHAR2,LOB, etc.
Since you can use Pro*C( or OCI) to develop Oracle
applciations,
the benefit of standard C language can be realized in such
type of applications.
Please reference to the Pro*C development guide of ORACLE.

【在 h****r 的大作中提到】

: Is ORACLE support pointer type? somebody told me using it
: will greatly
: increase the performance.
: Some big shrimp can give some introduction on it?

h*r2001-03-20 08:03

3 楼

Thanks, SuperMouse!

【在 s********e 的大作中提到】

: In fact, POINTER is not the basic data type of ORACLE.
: Orcacle support NUMERIC and VARCHAR2,LOB, etc.
: Since you can use Pro*C( or OCI) to develop Oracle
: applciations,
: the benefit of standard C language can be realized in such
: type of applications.
: Please reference to the Pro*C development guide of ORACLE.

s*e2001-03-20 08:03

4 楼

I am sorry that I make a mistake here.
The Pro*C/C++ do not support Pointer type. It only support
array (limit to 1 or 2 dimension).
If you want to use pointer, you may go to C (OCI) developing
guide.
In fact, the performance of DB application relies on the
data visiting operations.
You should foucs on optimizing the SQL performance. Also you
should cut down the data trander
between the DB server and client.
In fact, array and pointer will not have big difference in
Db applications.
If you want

【在 h****r 的大作中提到】

: Thanks, SuperMouse!