Re: help: question on oracle sys_context(). more confused :( - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

Re: help: question on oracle sys_context(). more confused :(

Re: help: question on oracle sys_context(). more confused :(# Database - 数据库

d*a2001-07-25 07:07

1 楼

in the definition of table e1, fname is of type
character(10).
so if i ran the following sql, what i got:
SQL> select '++'||fname||'++' from e1;
'++'||FNAME||'

a*i2001-07-25 07:07

2 楼

It is not (I think) a problem of sys_context, sys_context is only an oracle
function implemented in PL/SQL, ( i believe :)
It is more likely to be the problem how oracle implements '=' operator.
Read more documentation on it. It might have ignored the spaces.

【在 d**a 的大作中提到】

: in the definition of table e1, fname is of type
: character(10).
: so if i ran the following sql, what i got:
: SQL> select '++'||fname||'++' from e1;
: '++'||FNAME||'