how to: list of synonyms (Oracle)?

From: "Marc" <mphaan(at)hotmail(dot)com>
To: pgsql-questions(at)postgreSQL(dot)org
Subject: how to: list of synonyms (Oracle)?
Date: 2000-01-27 08:42:28
Message-ID: UxTj4.266$kJ6.750@198.235.216.4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

I've got a corrupt synonym on my database. Problem is, I got a whole lot of
synonyms and I dont know which one is corrupt. So I want to delete or drop
all synonyms that contain 500 in the name.

Question: How can I get a list of synynyms from e certain schema level?

Marc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Jewiss 2000-01-27 08:47:03 Re: [GENERAL] reverse sorting
Previous Message Sirish Kumar 2000-01-27 07:35:14 ecpg observation