get schema name
can some one pls tell me how to get the 'schema name' for a particular 'sequen开发者_JS百科ce' using jdbc
I assume you are using Oracle DB.
If that's the case you can run the query given below via JDBC and get the column named sequence_owner for the Schema Name to which a sequence belongs to.
SELECT sequence_owner
FROM all_sequences
WHERE sequence_name = '<YOUR_SEQUENCE_NAME>'
select SCHEMA_NAME from INFORMATION_SCHEMA.SCHEMATA
This is return all schema names.
精彩评论