Search Result

Hi all

I have a monitoring application that running outside the DB server that every 1 minutes queries the snapshot tables and logs it into an internal repository of it. for later tuning.

I have a problem with getting SQL statements from it that has non-english letters inside.

here is small sample test I did from control center to simulate the problem :

select stmt_text from
table(snapshot_ statement('DBNA ME',-1))...

Hi!,

I'm sort of a newbie in OAS Portal, and I'm having problems with the CLOBs fields, see I am creating a portal that has the administrator area where the admins, can update the Portal's info and there are some tables that have CLOB fields, so the OAS Portal does not suppert CLOB right? but well I hope there are ways to work with them... like in te reports I use a substring calling and concatenation.. ..


...

I have a table

create table EMAIL (
EMAIL_ID number primary key,
CLASS char(5),
CONTENT CLOB);

after indexing on CONTENT, i want to create a new field NEW_FIELD contains words from CONTENT in the root form and without stopwords.

for example :
record in CONTENT : I saw her standing there.
desirable new record in NEW_FIELD: see stand

need help..
...