List Oracle sequence object owners (homework)

Write a SQL statement (not a DESCRIBE) to lis开发者_StackOverflow社区t the sequence owner and name for all of the sequence objects available to you.

You need to figure out what a sequence is. Then how to query for it in the system tables, the ALL_SEQUENCES table specifically. After that filtering the sequences for your own privileges should be easy.

Since it's homework, here is a strong hint to get you started: Do an internet search for Oracle's ALL_CATALOG, ALL_TABLES and ALL_TAB_COLS.

Oracle, like most RDBMS, stores information about the structure & ownership of tables, objects, etc inside system tables. You will need to query the correct system tables to retrieve the information your instructor asked for.