how to get list of synonyms in oracle
Solutions on MaxInterview for how to get list of synonyms in oracle by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "how to get list of synonyms in oracle"
Mia
23 Oct 2016
1-- Depending on connected user grants:
2SELECT * FROM USER_SYNONYMS WHERE SYNONYM_NAME = 'syn_name'; -- User synonyms
3SELECT * FROM ALL_SYNONYMS WHERE TABLE_NAME = 'table_name'; -- Available to user
4SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'schema_name'; -- All schemassimilar questions
how to check grants on a package in oracleoracle list usersoracle list of long running queriesoracle list columns schemaquery to find object dependencies in oracleoracle list jobsoracle synonymoracle list typesoracle list grants on packageoracle create synonymoracle list user defined typesoracle list partitionsoracle list tablesoracle query to see what scema i am working inoracle list service namesoracle list constraintsoracle list viewsoracle list rulesoracle list programhow to get the query of a view in oracleoracle list columnssynonym oracleoracle sql listaggoracle list functionsoracle list packagesoracle list privilegesoracle search text in all packagesoracle list columns in schema your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful