Questions tagged [synonym]

Synonym is a word or phrase that means exactly or nearly the same as another word or phrase in the same language.

Synonym is a word or phrase that means exactly or nearly the same as another word or phrase in the same language.

For more information read the Wikipedia page.

508 questions
58
votes
18 answers

How to debug ORA-01775: looping chain of synonyms?

I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging it, or do I just have to "create or replace" my way out of it? Is there a way to query the schema or whatever to find out what the current…
Josh Kodroff
  • 27,301
  • 27
  • 95
  • 148
37
votes
7 answers

How to create an alias of database in SQL Server

We have a very old software has been created around 10 years ago and we don't have source code. The software uses two databases, DB01 and DB02 on the same SQL Server 2012 instance. There is SQL statements such as db01..table1 join db02..table2, but…
Dmitriy Sosunov
  • 1,075
  • 3
  • 10
  • 25
35
votes
3 answers

Alias target name in Makefile

The Problem: Is it possible to give a target a different name or alias, such that it can be invoked using either the original target name or the alias. For example something like /very/long/path/my_binary: dep_a dep_b dep_c # Compile # Desired…
WaelJ
  • 2,942
  • 4
  • 22
  • 28
31
votes
6 answers

When should database synonyms be used?

I've got the syntax down but I'm wondering if somebody can provide an illustrative use case where database synonyms are very useful.
aw crud
  • 8,791
  • 19
  • 71
  • 115
30
votes
4 answers

How to create Sql Synonym or "Alias" for Database Name?

I'm using ms sql 2008 and trying to create a database name that references another database. For example 'Dev', 'Test', 'Demo' would be database names that i could reference from my multiple config files, but each name would point to another…
Kevin McKinley
  • 599
  • 1
  • 5
  • 13
29
votes
3 answers

Making an Entity Framework Model span multiple databases

Is it valid to do something such as CREATE SYNONYM [dbo].[MyTable] FOR [AnotherDatabase].dbo.[MyTable] and then modify Entity Framework's edmx file to read this object like it would any other table? I did a quick sample test and it seems to work…
Rachel
  • 130,264
  • 66
  • 304
  • 490
17
votes
3 answers

SQL Server - Synonyms Tips & Tricks?

I've been doing a lot of DB refactoring lately and synonyms have come in incredibly useful. When I originally put in the synonyms I was thinking they would be very temporary while I refactor. Now I am thinking there might be some good reasons to…
Chad Grant
  • 44,326
  • 9
  • 65
  • 80
15
votes
3 answers

How to make solr synonyms work

I'm trying to set up some basic synonyms in Solr. The one I've been working on is: us, usa, united states My understanding is that adding that to the synonym file will allow users to search for US, and get back documents containing usa or united…
mlissner
  • 17,359
  • 18
  • 106
  • 169
14
votes
5 answers

ORA-00980 synonym translation no longer valid in PLSQL

I've got a synonym on a remote Oracle database that I can access in SQL over a database link, eg, insert into my_table select * from my_synonym@my_database_link; If I put the above statement into a PLSQL block, it won't compile, giving the error…
D Veloper
  • 171
  • 1
  • 1
  • 6
14
votes
2 answers

How can I check that if synonym already exist then don't create synonym

I am using Oracle SQL developer 2.1 for creating a synonym. CREATE OR REPLACE SYNONYM "ETKS_PR_RW"."SQ_CLDOS_ATCHMNT_ID" FOR "CLDOS_ONLINE_DBA"."SQ_CLDOS_ATCHMNT_ID"; How can I check that if this synonym already exists then don't create the…
SOF User
  • 7,590
  • 22
  • 75
  • 121
13
votes
2 answers

Is there any lib for python that will get me the synonyms of a word?

Is there any api/lib for python that will get me the synonyms of a word? For example if i have the word "house" it will return "building, domicile, mansion, etc..."
daniels
  • 18,416
  • 31
  • 103
  • 173
12
votes
1 answer

What is the data model used for tags and tag synonyms?

I asked this question on meta, but i now realize that it may be more appropriate for the main site as it is a general question that would relate to any tagging based system (i am happy to close / delete one depending on where people think this…
leora
  • 188,729
  • 360
  • 878
  • 1,366
12
votes
3 answers

Way to extract Google Synonyms

Would anyone know of a way to extract Google Synonyms, either through their API or other (TOS-approved) methods? Specifically, Google have a function that allows you to type a tilde sign "~" in front of a word to conduct a search with synonyms. As…
Pierre
  • 121
  • 1
  • 3
12
votes
2 answers

Hibernate Schema Validation Fails on Oracle Table Synonyms

I'm developing a Java web application that uses Hibernate (annotations-based) for persisting entities to an Oracle 11g database. The DBA created synonyms for the tables and requested that I use these synonyms instead of the physical tables. (Eg:…
Rob
  • 121
  • 1
  • 3
12
votes
4 answers

Wordnet Find Synonyms

I am searching for a way to find all the synonyms of a particular word using wordnet. I am using JAWS. For example: love(v): admire, adulate, be attached to, be captivated by, be crazy about, be enamored of, be enchanted by, be fascinated with, be…
Sankalp
  • 1,128
  • 4
  • 14
  • 31
1
2 3
33 34