查看表对应的序列
-
oracle如何查看表对应的序列
在Oracle中,可以通过查询序列的所有者和名称来查看表对应的序列。可以使用以下SQL语句:,,“sql,SELECT sequence_owner, sequence_name ,FROM all_sequences ,WHERE sequence_owner = ‘表所属用户’ AND sequence_name LIKE ‘表名%’;,“
在Oracle中,可以通过查询序列的所有者和名称来查看表对应的序列。可以使用以下SQL语句:,,“sql,SELECT sequence_owner, sequence_name ,FROM all_sequences ,WHERE sequence_owner = ‘表所属用户’ AND sequence_name LIKE ‘表名%’;,“