oracle insert 返回值

oracle执行 insert语句后能返回插入的id值吗??谢谢

---

declare
v_id t.id%type;
begin
insert into t(id) values(seq.nextval) returning id into v_id;
end;
/

---

学习了啊,新知识

---

不用存储过程能实现吗???

---

*_*

---

引用

不用存储过程能实现吗???

which variable to hold on return value if you don't want to use procedure?

---

不知道还有没有其他做法

---

java jdbc:

Java code:

try {
con = OConnection.getConn();
DatabaseMetaData dmd = con.getMetaData();

System.out.println("database product name: "
+ dmd.getDatabaseProductName());
System.out.println("database product version: "
+ dmd.getDatabaseProductVersion());
System.out.println("supports generate keys? "
+ dmd.supportsGetGeneratedKeys());

String sql = "INSERT INTO test11(ID,sdate) " + "VALUES (t_seq.nextval, ?)";

ps = con.prepareStatement(sql, new String[] { "ID" });

ps.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
ps.executeUpdate();
Statement st = null;
st = con.createStatement();