Oracle文本-单词的同义词!

大家好，

我有关于Oracle文本12c的问题。我希望得到你的支持。

1.单词的同义词
例如，我有一个单词 “揭示”，我可以得到揭示的所有同义词吗，例如: 展示，展示，展示，披露，揭开...

2.一个词的过去和现在
例如: made (过去) => make (现在)，tried => try


提前谢谢。

VN。

你可以用同义词库。您可以创建自己的，或者加载一个。我们提供一个默认的，您可以在 $ ORACLE_HOME/ctx/sample下加载，例如

C:\oracle\product\12.2.0.1\ctx\sample\thes>ctxload -thes -name default -file dr0thsus.txt
Enter user: mcdonac/******
Connecting...
Creating thesaurus default...
Thesaurus default created...
Processing...
1000 lines processed
2000 lines processed
3000 lines processed
4000 lines processed
5000 lines processed
6000 lines processed
7000 lines processed
8000 lines processed
9000 lines processed
10000 lines processed
11000 lines processed
12000 lines processed
13000 lines processed
14000 lines processed
15000 lines processed
16000 lines processed
17000 lines processed
18000 lines processed
19000 lines processed
20000 lines processed
21000 lines processed
21760 lines processed successfully
Beginning insert...21760 lines inserted successfully
Disconnected

SQL> create table t (col varchar2(60));

Table created.

SQL>
SQL> insert all
  2  into t values ('I abandoned all hope of losing weight')
  3  into t values ('We shall never surrender')
  4  select * from dual;

2 rows created.

SQL>
SQL> create index t_idx on t (col) INDEXTYPE IS CTXSYS.CONTEXT;

Index created.

SQL>
SQL> select * from t where contains (col, 'abandonment') > 0;

no rows selected

SQL> select * from t where contains (col, 'SYN(abandonment,default)') > 0;

COL
------------------------------------------------------------
I abandoned all hope of losing weight

1 row selected.

这里有很多好的信息

https://docs.oracle.com/database/122/CCAPP/working-with-thesaurus-in-oracle-text.htm#CCAPP0900