sgfx外汇

Ⅰ 如何手动创建oracle数据库

创建数据库前，要做的工作：
1.收集要设置的ORACLE_HOME路径 ORACLE_SID
2.创建数据库需要的目录
按照下面的步骤创建：（以AIX系统为例，Linux差不多，但有些文件的路径和文件名不一样）
1.编辑系统参数文件（AIX系统参数文件：.profile） :vi .profile文件 若是以前已添加过数据库的，则只需修改下ORACLE_SID=sg186fx(以我创建的数据库名为例)；若是没有添加过关于数据的参数，则需要添加ORACLE_HOME,ORACLE_BASE等的路径。
我的“.profile”文件中设置的路径：
ORACLE_BASE=/oracle;export ORACLE_BASE
ORACLE_HOME=/oracle/proct/10.2.0/db_1; export ORACLE_HOME
#ORA_CRS_HOME=/oracle/proct/10.2.0/crs; export ORA_CRS_HOME
SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$SHLIB_PATH
export SHLIB_PATH
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$LIBPATH
export LIBPATH
PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH:/oradata/quest/splex/bin; export PATH
export ORACLE_SID=sg186fx（这是在创建多个数据库，启动不同数据实例时需要修改的地方）
2.修改完系统参数文件，可以退出登录，重新登录进来就可以生效了，或者使用“export ORACLE_SID=sg186fx”在当前会话中生效。
3.创建数据库需要的目录
创建目录脚本：
su – oracle
cd /oradata
rm –rf sg186fx
mkdir sg186fx
cd /oracle/admin
rm –rf sg186fx
mkdir sg186fx
cd sg186fx
mkdir amp bmp cmp dpmp ump pfile
这个脚本可以不断进行测试创建数据库目录的时候使用。
4.创建oracle的启动参数文件——pfile或spfile
db_cache_size=4026531840
java_pool_size=16777216
large_pool_size=16777216
shared_pool_size=855638016
streams_pool_size=0
audit_file_dest='/oracle/admin/sg186fx/amp'
background_mp_dest='/oracle/admin/sg186fx/bmp'
compatible='10.2.0.2.0'
control_files='/oradata/sg186fx/control01.ctl','/oradata/sg186fx/control02.ctl','/oradata/sg186fx/control03.ctl'
core_mp_dest='/oracle/admin/sg186fx/cmp'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='sg186fx'
dispatchers='(PROTOCOL=TCP) (SERVICE=sg186fxdb)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=1639972864
processes=250
remote_login_passwordfile='EXCLUSIVE'
sessions=280
sga_target=4920967168
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_mp_dest='/oracle/admin/sg186fx/ump'
使用上面设置的参数文件创建pfile的文件名问initsg186fx.ora
5.创建密码文件
orapwd file=’orapwd$ORACLE_SID’ password=sys entries=20 force=y
file的参数需要指定路径的，他的创建位置应该在$ORACLE_HOME/dbs中，若是在当前目录下创建就不需要写上路径了。
password设置是数据库的sys用户的密码。
entries:DBA和操作员的最大用户数
force=y 等号中间不能有空格的，这是表示存在该文件则进行强制重写。
6.编写创建数据库脚本（非常重要的一步）
创建脚本请看脚本代码
查看创建数据库的必备的参数模板
在这个创建数据库脚本编写中可能会出现需要错误，将会在下篇重点分析，我在创建的过程中，出现过很多错误。
7.使用命令登录：
sqlplus /nolog
connect / as sysdba(注意：在这一步连接的时候，数据库要创建一些跟踪文件：alert文件等，若是在第三步创建目录的时候使用的不是oracle用户角色创建的用户，则在这一步登录的时候，由于权限不够会出现错误：ORA-09925：Unable to create audit trail file，此时需要去检查下手动创建的目录的权限对不对)
startup nomount pfile=’$ORACLE_HOME/dbs/initsg186fx.ora’ 这一步启动数据库只加载启动参数文件的状态，并没有装载控制文件和数据文件
@/createdatabase.sql 执行创建数据库脚本。
这一步很容易出错，出现最多的是：
2
alert日志显示的错误信息：
3
这个错误提示看不出有什么错误，因为他只是说脚本有错误，导致实例强制被终止。虽然报这个错误，但其他的文件将会正常的被创建，数据库还是不能运行的。所以要排除这个错误，重新创建数据库。必须去看alert日志来看哪个地方出现的错误。（我建议，在执行创建脚本的时候，重新打开一个窗口来监控alert日志，跟踪创建过程，很容易发现哪句话出现的错误。）
8.创建 user表空间和索引表空间
9 若创建没有出现错误，则可以执行rdbms里面的一些创建数据字典的脚本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
10.重启数据库。
到此，数据库的基本创建工作完成。
简单的数据库建成后，如果需要使用全文检索功能，则还需要执行几个脚本。
请查看：全文检索配置方法
若想了解各种oracle自带的脚本，根据需要执行哪些脚本，请查看：oralce自带脚本说明

Ⅱ 威纶触摸屏电缆USB-MT500连接触摸屏MT506MV 5WV怎么也连不上

1.看你的电脑上有没正确安装触摸屏的驱动。

2.数据线的驱动安装是不是正确。

3，软件端口设置是否正确。（桌面-右键-属性-设备管理器-看你的数据线端口显示是多少）。

4，检查通讯线有没问题。

威纶/USB-MT500缆型号是USB-MT500，适用于威纶通(Weinview)EB500系列和人机(EasyView) MT500系列，符合iso9002产品认证，它的正常工作电压是12V，输出频率50kHz。

(2)sgfx外汇扩展阅读

触摸屏MT506MV的规格

处理器是Intel PXA255 200MHz，内存是2MB，DRAM是4MB，串口是1 RS-232 (HMI-PC) 1 RS232/485 (HMI-PLC)，配方是内建(配方卡 128kB)；

自我诊断是电源异常侦测，输入电压是24 VDC, 0.5A maximum，人机尺寸(WxHxD)是204x150x48mm，开孔尺寸(WxH)是192x138mm，重量是Approx:0.85 kg。

Ⅲ SG$,CHF,EUR,JPY分别是什么货币单位,折合多少RMB

SG$ :新加坡元
CHF ：瑞士法郎
EUR ：欧元
JPY ：日元

具体的即时外汇报价（中国银行）可与参考一下网址：
中文：http://www.bank-of-china.com/cn/common/service.jsp
英文：http://www.bank-of-china.com/en/common/service.jsp

Ⅳ 《三国第一军师》最新章节全文阅读免费下载百度网盘资源,谁有

《三国第一军师》网络网盘txt最新全集下载:
链接:https://pan..com/s/1RI29UMkjHvZhsg9fX1UjyQ

Ⅳ oracle数据库实现全文检索

Oracle全文检索配置方法：

1.检查数据库是否具有全文检索功能（这是针对已经建成使用的数据库）

查看用户中是否存在ctxsys用户，查询角色里是否存在ctxapp角色。以上两个中的1个不满足（不存在），则说明没有装过全文检索功能。

使用contains函数的时候，若没有全文检索则会报错的。

2.若没有，则需要手动建立，先建立全文检索要使用的空间

sqlplus / as sysdba --进入控制台

createtablespaceIdx_ctxsysdatafile'/oradata/sg186fx/ctxsys01.;--创建全文检索使用的表空间

3.创建全文检索使用的用户和角色及相应的包，则需要执行oracle自带的一个脚本：cd $ORACLE_HOME/ctx/admin/catctx.sql

还是在sqlplus中执行：

@?/ctx/admin/catctx.sql ctxsys Idx_ctxsys temp nolock

在执行这个脚本的时候，输入了几个参数，第一个参数ctxsys为ctxsys用户的密码

第二个参数Idx_ctxsys为ctxsys用户要使用的表空间

第三个参数temp为ctxsys用户使用的临时表空间

第四个参数nolock为ctxsys用户处于解锁状态。

4.创建完成后，要登录ctxsys用户

connect ctxsys/ctxsys

执行以下脚本：@?/ctx/admin/defaults/drdefus.sql(这是个很重要的脚本，后面创建索引会使用该脚本创建的信息)

5.创建全文索引语法分析器

先要明确使用全文索引的用户，我要使用全文索引的是sgpm用户

因此

grantexecuteonctxsys.ctx_ddltosgpmwithgrantoption;

connect sgpm/sgpm

设置语法分析器：

execctx_ddl.drop_preference('chinalexer');
execctx_ddl.create_preference('chinalexer','chinese_lexer');

设置词法属性：

execctx_ddl.drop_preference('idx_c_store');

begin
ctx_ddl.create_preference('idx_c_store','BASIC_STORAGE');
ctx_ddl.set_attribut('idx_c_store','I_TABLE_CLAUSE','tablespacesIdx_ctxsy');
ctx_ddl.set_attribute('idx_c_store','I_INDEX_CLAUSE','tablespaceIdx_ctxsycompress2');
end;
/

6.创建索引

createindexsgpm.idx_c_cons_nameonsgpm.c_cons(cons_name)indextypeisctxsys.contextparameters('lexerchinalexerstorageidx_c_store');

7.同步索引

variablejobnonumber;
begin
dbms_job.submit(:jobno,'pkg_sp_tools.p_cont_sys_index();',sysdate,'trunc(sysdate)+19/24+1');--执行的是个性化方法。
end;
/

普通的就是用：

execctx_ddl.sync_index('idx_c_cons_name');

到此，全文检索创建成功，contains函数就可以正常使用了。

注意：创建的过程中会出现ORA-29879:cannot create multiple domain index on a column listusing same indextype ,这说明在其他用户下已经建立了该索引。

Ⅵ 汇率方面的英文参考文献 最少来3个 谢谢 ！~！！！

Exchange rate
In finance, the exchange rates (also known as the foreign-exchange rate, forex rate or FX rate) between two currencies specifies how much one currency is worth in terms of the other. For example an exchange rate of 102 Japanese yen (JPY, ¥) to the United States dollar (USD, $) means that JPY 102 is worth the same as USD 1. The foreign exchange market is one of the largest markets in the world. By some estimates, about 2 trillion USD worth of currency changes hands every day.

The spot exchange rate refers to the current exchange rate. The forward exchange rate refers to an exchange rate that is quoted and traded today but for delivery and payment on a specific future date.

Quotations
An exchange rate quotation is given by stating the number of units of "term currency" or "price currency" that can be bought in terms of 1 unit currency (also called base currency). For example, in a quotation that says the EURUSD exchange rate is 1.3 (1.3 USD per EUR), the term currency is USD and the base currency is EUR.

There is a market convention that determines which is the base currency and which is the term currency. In most parts of the world, the order is:
EUR - GBP - AUD - USD - *** (where *** is any other currency).
Thus if you are doing a conversion from EUR into AUD, EUR is the base currency, AUD is the term currency and the exchange rate tells you how many Australian dollars you would pay or receive for 1 euro. Cyprus and Malta which were quoted as the base to the USD and *** were recently removed from this list when they joined the euro. In some areas of Europe and in the non-professional market in the UK, EUR and GBP are reversed so that GBP is quoted as the base currency to the euro. In order to determine which is the base currency where both currencies are not listed (i.e. both are ***), market convention is to use the base currency which gives an exchange rate greater than 1.000. This avoids rounding issues and exchange rates being quoted to more than 4 decimal places. There are some exceptions to this rule e.g. the Japanese often quote their currency as the base to other currencies.

Quotes using a country's home currency as the price currency (e.g., EUR 1.00 = $1.45 in the US) are known as direct quotation or price quotation (from that country's perspective) ([1]) and are used by most countries.

Quotes using a country's home currency as the unit currency (e.g., £0.4762 = $1.00 in the US) are known as indirect quotation or quantity quotation and are used in British newspapers and are also common in Australia, New Zealand and the eurozone.

direct quotation: 1 foreign currency unit = x home currency units
indirect quotation: 1 home currency unit = x foreign currency units
Note that, using direct quotation, if the home currency is strengthening (i.e., appreciating, or becoming more valuable) then the exchange rate number decreases. Conversely if the foreign currency is strengthening, the exchange rate number increases and the home currency is depreciating.

When looking at a currency pair such as EURUSD, the first component (EUR in this case) will be called the base currency. The second is called the term currency. For example : EURUSD = 1.33866, means EUR is the base and USD the term, so 1 EUR = 1.33866 USD.

Currency pairs are often incorrectly quoted with a "/" (forward slash). In fact if the slash is inserted, the order of the currencies should be reversed. This gives the exchange rate. e.g. if EUR1 is worth USD1.35, euro is the base currency and dollar is the term currency so the exchange rate is stated EURUSD or USD/EUR. To get the exchange rate divide the USD amount by the euro amount e.g. 1.35/1.00 = 1.35

Market convention from the early 1980s to 2006 was that most currency pairs were quoted to 4 decimal places for spot transactions and up to 6 decimal places for forward outrights or swaps. (The fourth decimal place is usually referred to as a "pip.") An exception to this was exchange rates with a value of less than 1.000 which were usually quoted to 5 or 6 decimal places. Although there is no fixed rule, exchange rates with a value greater than around 20 were usually quoted to 3 decimal places and currencies with a value greater than 80 were quoted to 2 decimal places. Currencies over 5000 were usually quoted with no decimal places (e.g. the former Turkish Lira). e.g. (GBPOMR : 0.765432 - EURUSD : 1.3386 - GBPBEF : 58.234 - EURJPY : 165.29). In other words, quotes are given with 5 digits. Where rates are below 1, quotes frequently include 5 decimal places.

In 2006 Barclays Capital broke with convention by offering spot exchange rates with 5 or 6 decimal places. The contraction of spreads (the difference between the bid and offer rates) arguably necessitated finer pricing and gave the banks the ability to try and win transaction on multibank trading platforms where all banks may otherwise have been quoting the same price. A number of other banks have now followed this.

Free or pegged
Main article: Exchange rate regime
If a currency is free-floating, its exchange rate is allowed to vary against that of other currencies and is determined by the market forces of supply and demand. Exchange rates for such currencies are likely to change almost constantly as quoted on financial markets, mainly by banks, around the world. A movable or adjustable peg system is a system of fixed exchange rates, but with a provision for the devaluation of a currency. For example, between 1994 and 2005, the Chinese yuan renminbi (RMB) was pegged to the United States dollar at RMB 8.2768 to $1. China was not the only country to do this; from the end of World War II until 1966, Western European countries all maintained fixed exchange rates with the US dollar based on the Bretton Woods system. [2]

Nominal and real exchange rates
The nominal exchange rate e is the price in domestic currency of one unit of a foreign currency.
The real exchange rate (RER) is defined as , where P is the domestic price level and P * the foreign price level. P and P * must have the same arbitrary value in some chosen base year. Hence in the base year, RER = e.
The RER is only a theoretical ideal. In practice, there are many foreign currencies and price level values to take into consideration. Correspondingly, the model calculations become increasingly more complex. Furthermore, the model is based on purchasing power parity (PPP), which implies a constant RER. The empirical determination of a constant RER value could never be realised, e to limitations on data collection. PPP would imply that the RER is the rate at which an organization can trade goods and services of one economy (e.g. country) for those of another. For example, if the price of a good increases 10% in the UK, and the Japanese currency simultaneously appreciates 10% against the UK currency, then the price of the good remains constant for someone in Japan. The people in the UK, however, would still have to deal with the 10% increase in domestic prices. It is also worth mentioning that government-enacted tariffs can affect the actual rate of exchange, helping to rece price pressures. PPP appears to hold only in the long term (3–5 years) when prices eventually correct towards parity.

More recent approaches in modelling the RER employ a set of macroeconomic variables, such as relative proctivity and the real interest rate differential.

Bilateral vs effective exchange rate
Bilateral exchange rate involves a currency pair, while effective exchange rate is weighted average of a basket of foreign currencies, and it can be viewed as an overall measure of the country's external competitiveness. A nominal effective exchange rate (NEER) is weighted with trade weights. a real effective exchange rate (REER) adjust NEER by appropriate foreign price level and deflates by the home country price level. Compared to NEER, a GDP weighted effective exchange rate might be more appropriate considering the global investment phenomenon.

Uncovered interest rate parity
See also: Interest rate parity#Uncovered interest rate parity
Uncovered interest rate parity (UIRP) states that an appreciation or depreciation of one currency against another currency might be neutralized by a change in the interest rate differential. If US interest rates exceed Japanese interest rates then the US dollar should depreciate against the Japanese yen by an amount that prevents arbitrage. The future exchange rate is reflected into the forward exchange rate stated today. In our example, the forward exchange rate of the dollar is said to be at a discount because it buys fewer Japanese yen in the forward rate than it does in the spot rate. The yen is said to be at a premium.

UIRP showed no proof of working after 1990s. Contrary to the theory, currencies with high interest rates characteristically appreciated rather than depreciated on the reward of the containment of inflation and a higher-yielding currency.

Balance of payments model
This model holds that a foreign exchange rate must be at its equilibrium level - the rate which proces a stable current account balance. A nation with a trade deficit will experience rection in its foreign exchange reserves which ultimately lowers (depreciates) the value of its currency. The cheaper currency renders the nation's goods (exports) more affordable in the global market place while making imports more expensive. After an intermediate period, imports are forced down and exports rise, thus stabilizing the trade balance and the currency towards equilibrium.

Like PPP, the balance of payments model focuses largely on tradable goods and services, ignoring the increasing role of global capital flows. In other words, money is not only chasing goods and services, but to a larger extent, financial assets such as stocks and bonds. Their flows go into the capital account item of the balance of payments, thus, balancing the deficit in the current account. The increase in capital flows has given rise to the asset market model.

Asset market model
See also: Capital asset pricing model
The explosion in trading of financial assets (stocks and bonds) has reshaped the way analysts and traders look at currencies. Economic variables such as economic growth, inflation and proctivity are no longer the only drivers of currency movements. The proportion of foreign exchange transactions stemming from cross border-trading of financial assets has dwarfed the extent of currency transactions generated from trading in goods and services.

The asset market approach views currencies as asset prices traded in an efficient financial market. Consequently, currencies are increasingly demonstrating a strong correlation with other markets, particularly equities.

Like the stock exchange, money can be made or lost on the foreign exchange market by investors and speculators buying and selling at the right times. Currencies can be traded at spot and foreign exchange options markets. The spot market represents current exchange rates, whereas options are derivatives of exchange rates.

Fluctuations in exchange rates
A market based exchange rate will change whenever the values of either of the two component currencies change. A currency will tend to become more valuable whenever demand for it is greater than the available supply. It will become less valuable whenever demand is less than available supply (this does not mean people no longer want money, it just means they prefer holding their wealth in some other form, possibly another currency).

Increased demand for a currency is e to either an increased transaction demand for money, or an increased speculative demand for money. The transaction demand for money is highly correlated to the country's level of business activity, gross domestic proct (GDP), and employment levels. The more people there are unemployed, the less the public as a whole will spend on goods and services. Central banks typically have little difficulty adjusting the available money supply to accommodate changes in the demand for money e to business transactions.

The speculative demand for money is much harder for a central bank to accommodate but they try to do this by adjusting interest rates. An investor may choose to buy a currency if the return (that is the interest rate) is high enough. The higher a country's interest rates, the greater the demand for that currency. It has been argued that currency speculation can undermine real economic growth, in particular since large currency speculators may deliberately create downward pressure on a currency in order to force that central bank to sell their currency to keep it stable (once this happens, the speculator can buy the currency back from the bank at a lower price, close out their position, and thereby take a profit).

In choosing what type of asset to is officially pegged, synthetic markets have emerged that can behave as if the yuan were floating).

汇率
在经济学上，汇率定义为两国货币之间兑换的比例。通常会将某一国的货币设为基准，以此换算金额价值他国几元的货币。在英文使用方面，有时简写为FX，此为外国货币Foreign Exchange的简写。

通俗的说，是一国货币单位兑换他国货币单位的比率，也可以说是用一国货币表示的另一国货币的价格。

汇率的特性在于它多半是浮动的比率。只要货币能够透过汇率自由交换，依交换量的多寡，就会影响隔天的汇率，因此，有人也以赚汇差营利，今日以较低的比率购进某一外币，隔日等到较高的比率出现时，再转手卖出。

所以有时汇率也能看出一个国家的经济状况。了解外汇也能看出这个国家的出口贸易状况。

交叉汇率
所谓交叉汇率是指两种不同货币之间的价格关系，两个国家之间的货币汇兑是利用各自对美元的汇率套算得出。

举例来看，若一美元可分别兑换0.8112欧元、109.28日圆，则欧元兑日圆的交叉汇率为134.71（= 109.28/0.8112）。

Ⅶ 汇客MT4软件在哪里进行下载免费的外汇行情软件，听说是不需要安装的。

下载汇客MT4软件需要在汇客论坛注册的，而且还要回复贴子才可以下载。

你要下就到这个网址去下吧。http://www.onefx.net/bbs/thread-40588-1-1.html

Ⅷ 诺德外汇开户送金那个是怎么回事

其实目前诺德Nordfx所有的欢迎账户4在注册后是不w能立刻获得赠金的。你必须先登录《交易办7公3室》对账户5进行实名认1证。然后需要在《交易办8公0室》内4上w传以8下x两种证件，一w个u是你的个q人a身份证明，比1如护照、身份证或驾驶执照，另一e个i就是你的地址证明，其中0地址证明是必须包含你的姓名和所在地址。当然你在注册账户3时填写的个u人s资料务必准确填写，否则一m旦出现错误，账户2资料不u予1修改，且该帐号将不s能获得认3证！最后欢迎账户7在完成实名认2证的同时，系统将自动将4美金充入s账户0！认3证工y作在5～3个s工l作日7内0完成。 sgjv幄υ场a岌k泰rv幄υ场b畅тzε

Ⅸ 如何实现Oracle数据库Text全文检索

Oracle全文检索配置方法：
1.检查数据库是否具有全文检索功能（这是针对已经建成使用的数据库）
查看用户中是否存在ctxsys用户，查询角色里是否存在ctxapp角色。以上两个中的1个不满足（不存在），则说明没有装过全文检索功能。
使用contains函数的时候，若没有全文检索则会报错的。
2.若没有，则需要手动建立，先建立全文检索要使用的空间
sqlplus / as sysdba --进入控制台

1

create tablespace Idx_ctxsys datafile '/oradata/sg186fx/ctxsys01.dbf size 10240M autoextend on next 32M maxsize 20480M;--创建全文检索使用的表空间

3.创建全文检索使用的用户和角色及相应的包，则需要执行oracle自带的一个脚本：cd $ORACLE_HOME/ctx/admin/catctx.sql
还是在sqlplus中执行：
@?/ctx/admin/catctx.sql ctxsys Idx_ctxsys temp nolock
在执行这个脚本的时候，输入了几个参数，第一个参数ctxsys为ctxsys用户的密码
第二个参数Idx_ctxsys为ctxsys用户要使用的表空间
第三个参数temp为ctxsys用户使用的临时表空间
第四个参数nolock为ctxsys用户处于解锁状态。
4.创建完成后，要登录ctxsys用户
connect ctxsys/ctxsys
执行以下脚本：@?/ctx/admin/defaults/drdefus.sql(这是个很重要的脚本，后面创建索引会使用该脚本创建的信息)
5.创建全文索引语法分析器
先要明确使用全文索引的用户，我要使用全文索引的是sgpm用户
因此

1

grant execute on ctxsys.ctx_ddl to sgpm with grant option;

connect sgpm/sgpm
设置语法分析器：

1
2

exec ctx_ddl.drop_preference('chinalexer');
exec ctx_ddl.create_preference('chinalexer','chinese_lexer');

设置词法属性：

1

exec ctx_ddl.drop_preference('idx_c_store');

1
2
3
4
5
6

begin
ctx_ddl.create_preference('idx_c_store','BASIC_STORAGE');
ctx_ddl.set_attribut('idx_c_store','I_TABLE_CLAUSE','tablespaces Idx_ctxsy');
ctx_ddl.set_attribute('idx_c_store','I_INDEX_CLAUSE','tablespace Idx_ctxsy compress 2');
end;
/

6.创建索引

1

create index sgpm.idx_c_cons_name on sgpm.c_cons(cons_name) indextype is ctxsys.context parameters('lexer chinalexer storage idx_c_store');

7.同步索引

1
2
3
4
5

variable jobno number;
begin
dbms_job.submit(:jobno,'pkg_sp_tools.p_cont_sys_index();',sysdate,'trunc(sysdate)+19/24+1'); --执行的是个性化方法。
end;
/

普通的就是用：

1

exec ctx_ddl.sync_index('idx_c_cons_name');

到此，全文检索创建成功，contains函数就可以正常使用了。
注意：创建的过程中会出现ORA-29879:cannot create multiple domain index on a column listusing same indextype ,这说明在其他用户下已经建立了该索引。

Ⅹ 求《三国第一军师》全本txt完结小说,谢谢~

《三国第一军师》网络网盘txt最新全集下载:
链接:https://pan..com/s/1RI29UMkjHvZhsg9fX1UjyQ