java nextval_通过java检索序列nextVal是否比在表上选择查询更快？

您正试图通过询问什么更快来过早地优化解决方案。无论答案如何，外部应用程序(例如Java)与Oracle数据库之间的请求可能比检索数据库中的序列或查询的速度慢。

在查看数据库的某个内部部分是否会为您节省几微秒之前，减少从Java到数据库的调用次数，因为它需要缓存值而不是从硬盘驱动器查找它。

I need the value of the sequence that has just been inserted in my application. So, I am retrieving the value from the sequence and then inserting that value by firing another insert query. Is there any other way?

使用存储过程来防止Java和Oracle之间的多次往返：

CREATE PROCEDURE add_data(

in_value1 IN YOUR_TABLE.VALUE1%TYPE,

in_value2 IN YOUR_TABLE.VALUE2%TYPE,

in_other_value IN OTHER_TABLE.VALUE%TYPE,

out_id OUT YOUR_TABLE.ID%TYPE,

out_succcess OUT VARCHAR2

)

IS

BEGIN

INSERT INTO your_table ( id, value1, value2 )

VALUES ( your_table_seq.NEXTVAL, in_value1, in_value2 )

RETURNING id INTO out_id;

INSERT INTO other_table( id, value )

VALUES ( out_id, in_other_value );

out_success := 'Ok'

EXCEPTION

WHEN DUP_VAL_ON_INDEX THEN

ROLLBACK;

out_id := NULL;

out_success := 'Already exists!'; -- Handle exceptions

END;

/