由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - what could be the problem
相关主题
Auto number in Oracle 8???mysql high hand please help!!!!
Oracle序列使用问题!ODBC SQLEndTran problem
ORACLE error code 04031[转载] what's wrong with this PL/SQL
What's SEQ;1 file?补充一下Re: 大侠一定要帮我看看呀(关于数据库的更新)
请教一个小白Query 问题download oralce9i windows 98 to xp?
不是难题不发问database design issue
来做sql题目。ORA-01002: fetch out of sequence问题
SQL问题求救!!做DBA需要什么文凭?
相关话题的讨论汇总
话题: what话题: sequence话题: seq话题: dual话题: oracle
进入Database版参与讨论
1 (共1页)
e******r
发帖数: 220
1
I created a sequence SEQ successfully, then when issuing command
select SEQ.CURRVAL from DUAL;
Oracle said the sequence is not defined in this session yet.
What is the reason?
thanks a lot.

B*****g
发帖数: 34098
2
currval only available after run nextval in this session

【在 e******r 的大作中提到】
: I created a sequence SEQ successfully, then when issuing command
: select SEQ.CURRVAL from DUAL;
: Oracle said the sequence is not defined in this session yet.
: What is the reason?
: thanks a lot.
:
:

1 (共1页)
进入Database版参与讨论
相关主题
做DBA需要什么文凭?请教一个小白Query 问题
问个笨问题不是难题不发问
A rookie's query question来做sql题目。
请教:如何从group里面拿到最后一个record的全部数据(MS SQL)SQL问题求救!!
Auto number in Oracle 8???mysql high hand please help!!!!
Oracle序列使用问题!ODBC SQLEndTran problem
ORACLE error code 04031[转载] what's wrong with this PL/SQL
What's SEQ;1 file?补充一下Re: 大侠一定要帮我看看呀(关于数据库的更新)
相关话题的讨论汇总
话题: what话题: sequence话题: seq话题: dual话题: oracle