INSO Filter Language Support?

May 4, 2011

Is it possible to extract kannada text from a pdf document using INSO filter ?

Or Does it support only English Language ?

View 5 Replies


ADVERTISEMENT

Forms :: Multi-Language Support In 6i

Mar 12, 2012

I want to enter data in Arabic and English through Oracle Forms6i.

View 8 Replies View Related

Server Administration :: Arabic Language Support

Apr 14, 2013

i installed database 10g with English language support and imported a dump file contains tables having columns in arabic

so after search i did these steps

SHUT;
CONN SYS/SYS AS SYSDBA
STARTUP RESTRICT;

Alter database character set INTERNAL_USE AR8ISO8859P6; (for arabic) which we want.

SHUT;
STARTUP

after the previous steps i checked on the nls_characterset from NLS_DATABASE_PARAMETERS and found it changed to AR8ISO8859P6 and that's right after that i can insert any arabic character to the tables but the original data still the same

is there anyway i can do to change the original data to be read in Arabic or i should make another import

View 1 Replies View Related

How To Get Profile In Oracle Support

Nov 19, 2012

How to get my profile in oracle support ? i need to know to many license what we have in oracle how to get this ,ex: oracle rac 11g , application server 10g ...etc.

View 13 Replies View Related

Forms :: 6i Support CLOB?

Oct 4, 2010

I wants to ask about CLOB that:

Is Form 6i support CLOB?

and also can we use LONGROW for storing images into database?

what exactly difference between these two data types in usage..

View 1 Replies View Related

SQL & PL/SQL :: Filter Data In One Row?

Jul 27, 2012

I've got one Table content

DataID...............Name
123...................test.doc
345...................test1.doc
678...................test2.doc
979...................test1.pdf

What I try is the following....

I go though the table and search for each *.doc the correct *.pdf.

the result should be this:

DataIDDoc...............NameDoc......DataIDPDF...............NameDocPDF......

123...................test.doc........979...................test1.pdf

Entries should never be twice in the table..

View 6 Replies View Related

Support Dram SSD For Small Database

Mar 15, 2011

I read the Website URL....and searching now for an alternative way for a small Oracle DB around 120 - 250 GB Data.I cant find any DRAM SSD that seems to suite the needs of such a small amount of data to a valuable price.

The only Hdd i found is URL... but im not sure if thats the right thing and if its possible to still buy such a device.where do we get such a device in Europe(swiss) and what would be the price for such a device?

Do i need to make a special setup within oracle (11g R2) to get the maximum out of such a DRAM SSD?

View 1 Replies View Related

Forms :: Firefox 14.0 Can Support Oracle 10g

Jul 9, 2012

firefox 14.0 can run oracle 10g forms ? and how can run ?

View 7 Replies View Related

Windows :: Does Win 7 Support Oracle 11g To Install

Nov 16, 2011

that windows7 will support oracle 11g and oracle 10 g

View 1 Replies View Related

SQL & PL/SQL :: Does Oracle Support Domain Concept

Dec 8, 2011

Do Oracle SQL support Domain Concept?

View 3 Replies View Related

Data Filter Within Table?

Sep 5, 2013

I am not sure if Oracle has a simple solution for a problem that I have in retrieving data?

Conditions:

As per rule we have to hold data from 7 - 10 years so the data can be searched at any given time.Don't want to purge data and keep the historic data separate so the request can be redirected based on the year.

I am looking for a solution similar to windows .ocx search. When a application is requesting an ocx (active X control) the search happens in C;\windows\system32 and if the ocx doesn't exists then the search is done on the entire system. Similarly can a table be partitioned (just the term I am using not discussing Oracle partition here) so I can partition data from 2011,2012 and 2013 to search first and if the searched data doesn't exists then search the other partition (data from 2003-2010) ?

View 2 Replies View Related

SQL & PL/SQL :: Filter Special Characters?

Jan 8, 2013

I have one column name party_name containing Korean Characters and English characters.Some of the English characters have different symbols.My requirement is to get the data and exclude those symbols but not Korean characters.

Already I used a function to replace special symbols with space.The function contains code based on ASCII values it works good but it filters Korean characters too.the attachment of the screenshot, When I double click the name it shows with some question mark.

View 9 Replies View Related

Forms :: 10g And Filter Data With SSO ID?

Oct 14, 2010

I'm having difficulty trying to show a list of forms that I would like to present the user after they log on with SSO.

The funny thing is that I can show the user in a message box. However, I cannot filter records that the user should have on an "Application" menu. The application menu is designed to allow the user to launch the form by double clicking on the menu item. That works fine. It is just that I cannot seem to filter. It shows no records.

Here is my WNFI

DECLARE
sso_user varchar2(40);
nn number;
v_vis VARCHAR2(20);

[Code]....

View 7 Replies View Related

SQL & PL/SQL :: Filter In Xplan Not In Query

Feb 9, 2011

This is probably a priv/similar issue but I've not seen it before.

select * from ccs.paymentmethod;

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------
Plan hash value: 2424632210
-----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 19791 | 2589K| 39 |
|* 1 | FILTER | | | | |
| 2 | TABLE ACCESS FULL| PAYMENTMETHOD | 19791 | 2589K| 39 |
-----------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter(1=2)

I get no rows - why? Obviously the predicate 1=2. Except, equally obviously, I don't have that in the query. On checking the objects views I see that ccs.payment method is indeed a table within that schema not a view or anything like that and when checking through another user I can see it has data within.

The "problem" user can see the table exists, just cant ever query rows back. Another user can see the table exists and can get data back.

Like I say, likely a priv or similar issue but I'm damned if I've seen this before, I'd not expect a priv issue to cause a 1=2 filter appear in a plan and its not a view that I can tell.

I'm still digging at my end and this may be irrelevant but when I browse to the table in Sql Developer I can see the columns tab ok, on clicking the "data" tab it throws "ORA-00904: "ORA_ROWSCN": invalid identifier" out. Maybe nothing, maybe related.

Google results suggest that error in SQL Dev is due to implementations of policies/VPD presence on the table.

View 2 Replies View Related

SQL & PL/SQL :: Multiple Filter Option

Apr 2, 2013

in many shopping cart applications they are providing multiple filter option.

suppose filter by brand,fitler by price ranges,filter by color,filter by shape etc..

so how they are achieving the performance.because lot of filter if applied then it should get slow execution.

how to achieve this.I tried as follows.

alter session set nls_date_format = 'dd-MON-yy';

CREATE OR replace PROCEDURE Multiple_filter (p_empno VARCHAR2,
p_ename VARCHAR2,
p_from_hiredate DATE,
p_to_hiredate DATE)

[Code]....

View 18 Replies View Related

PL/SQL :: Filter Values From String

Oct 13, 2013

I have data something like this:

Sample DateWITH DATA AS          (          SELECT 'AAAXXXX IO BLUEEXPRESS' LIST FROM dual          UNION ALL          SELECT 'BLUEEXPRESS AAAXXXX IO BLUEEXPRESS'  FROM dual          UNION ALL          SELECT 'DDDDD BLUEEXPRESS AAAXXXX'  FROM dual          UNION ALL          SELECT 'DDDDD DDDDD AAAXXXX'  FROM dual          UNION ALL          SELECT 'DDDDD BLUEEXPRESS AAAXXXX NO CARBON'  FROM dual          UNION ALL          SELECT 'NO CARBON
[code]....

The above result depends on the following rules:         

- Replace BLUEEXPRESS into BEXPRESS         
- Remove the term NO CARBON (See row no 6)         
- Reduce all multiple space into single space (see last record).

So far I create separated queries for replacing BLUEEXPRESS into BEXPRESS and replace NOCARBON term but I don't know how to do it in a single shot as well as stuck on scenario to remove multiple spaces  and put single space. 

View 5 Replies View Related

SQL & PL/SQL :: Filter The System Grants?

Jun 3, 2010

As per my req, i need to get the system grants of one user (GRANTEE) using DBMS_OUTPUT API. The requirement get completed using 'SYSTEM_GRANT' as parameter for OPEN function in the metadata api. Please look into part of code which works.

v_meta_handle := DBMS_METADATA.OPEN('SYSTEM_GRANT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'GRANTEE','SCOTT');

When using above piece, i get sys grants granted to SCOTT user. But i need to use 'DATABASE_EXPORT' as a parameter to my 'OPEN' function.

v_meta_handle := DBMS_METADATA.OPEN('DATABASE_EXPORT');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'INCLUDE_PATH_EXPR','IN''SYSTEM_GRANT''');
DBMS_METADATA.SET_FILTER(v_meta_handle, 'NAME_EXPR','IN''SCOTT''','GRANTEE_EXPR');

The second set filter doesn't work to get SYS GRANTS of one user. It does not throw any error. Simply the filter doesn't work. 'GRANTEE_EXPR' is not a correct value in the 2nd set filter. What parameter need to pass in object_path_expr ('GRANTEE_EXPR')?

View 4 Replies View Related

SQL Create Table Doesn't Support %TYPE / But PL/SQL Does

Oct 12, 2010

oracle 10G who knows why Oracle SQL doesn't support %TYPE when create a table. But it supports it when we use it in PL/SQL.

SQL> create table wg_1
(account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE)
;
2 3 (account_category JNL_WORK_LIST.ACCOUNT_CATEGORY%TYPE)
*
ERROR at line 2: ORA-00911: invalid character

SQL> desc JNL_WORK_LIST
Name Null? Type
----------------------------------------- -------- ----------------------------
ACCOUNT_NO NOT NULL NUMBER(10)
BILL_REF_NO NOT NULL NUMBER(10)
BILL_REF_RESETS NOT NULL NUMBER(3)
JNL_EARNED_THRU_DT DATE
[code]...

PL/SQL procedure successfully completed.

View 3 Replies View Related

Forms :: Oracle 10g Express Edition Can Support 6i

Mar 2, 2007

I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.

If there is any patch to connect forms 6i into oracle 10g express edition.

View 3 Replies View Related

Networking And Gateways :: Listener Support No Services

Jan 24, 2012

i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 24-JAN-2012 13:45:44
Uptime 0 days 0 hr. 3 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....

now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr

View 14 Replies View Related

Does Oracle 11g Support Host Naming Method

Jun 30, 2013

DB: 11.2.0.3 & OS: RHEL5 Easy Connect Naming method enhances the host naming method by allowing for a port and service specification. My question is does Oracle 11g support Host naming method?

View 4 Replies View Related

TimesTen In-Memory :: No Support For Trigonometric Functions

Sep 2, 2013

We cache oracle 11g2 data in timesten 11.2.2.5.0   ( IMDB ) We can't find any trigonometric functions like  cos(x), sin(x)  or so in timesten. Does that means timesten doesn't support trigonometric functions?

View 2 Replies View Related

Call Interface :: Only OCI V11 And Above Support Client Caching?

May 29, 2013

Our API supports Oracle 11.2g but uses OCI v8 yet.This means I cant activate client caching as a new feature ? We should update to OCIv11 ?

View 5 Replies View Related

Application Express :: JSONP Support For RSS Feed

Sep 17, 2012

We have an APEX application that leverage's APEX and UCM API to create a RSS feed that is displayed on the Content Portal.URL>....

The feed XML is converted to a JSON object and displayed on the home page using jquery.Up until last week this feed was displaying fine but now its broken and can no longer be seen on the home page.Our logs indicate that the feed content is being pulled as before without errors. URL....

A test page created to investigate the issue shows the following error -Resource interpreted as Script but transferred with MIME type application/rss+xml: URL>....

URL to the test page is :URL..... Could this possibly have to do with the recent upgrade on the APEX server as this worked perfectly earlier?Could the JSON support for RSS feed might have been affected?

View 1 Replies View Related

Forms :: Filter The Records Displayed

May 11, 2010

I have a block in the form which is based of a table as data source and so when i query on the form using a execute_query inbuilt statement is fired and all the records in the table behind is retrived and displayed. Also if i need to update any record i can do in on the screen and use commit_form so that all the changes go into the underlying table. Now my problem is when i retrieving my records i want to filter those records based on some conditions to be displayed in the form and not all records to be retrieved. Is it possible to do it if I am using the execute_query inbuilt and my block is based of a table?

View 8 Replies View Related

PL/SQL :: Filter Ticket Prices According To Class?

Sep 24, 2013

I need to filter ticket prices according to the class; i.e. 

CASE WHEN booking_class = 'Economy'           THEN economy_saver ELSE 0 END AS ECONOMY_SAVER           THEN economy_basic ELSE 0 END AS ECONOMY_BASIC           THEN economy_basic_plus ELSE 0 END AS ECONOMY_BASIC_PLUSEND, CASE WHEN booking_class = 'Business'           THEN business ELSE 0 END AS BUSINESS           THEN business_flexible ELSE 0 END AS BUSINESS_FLEXIBLEEND.

..The objective is to show only the prices that belong to the selected class. I am not sure if my sql is correct at this point. 

View 7 Replies View Related

SQL & PL/SQL :: Restricting Other Language Characters?

Jan 24, 2011

I need to give validation for not allowing french or arabic or hindi alphabets or numbers except for only english alphanumeric letters.

I understood how to restrict special characters or spaces .

regexp_instr(i, '[^[:alnum:]]') = 0

This function allow only characters and numbers in English language and doesnt allow special characters.

I need to restrict further by not allowing any other language characters or numbers except only english alphanumeric letters.

View 37 Replies View Related

SQL & PL/SQL :: Oracle Procedure With C Language

Apr 16, 2010

My question is--> Is it possible to create procedure with embeded C code ?

View 10 Replies View Related

SQL & PL/SQL :: Creating Oracle Database To Support Chinese Fonts

Aug 21, 2012

mentioned database is created with Character set = UTF8 and the National Character Set = AL16UTF16 and got the result for other languages (latin,german,french etc) but still Chinese language was not supported.

NLS_CHARACTERSETAL32UTF8
NLS_NCHAR_CHARACTERSETAL16UTF16

I was getting the output as given below-

SQL> select translator ('table and chair','zh-CN','en') English_to_chinese from dual ;

ENGLISH_TO_chinese
--------------------------------------------------------------------------------
┐┐┐┐┐

and the function is given below

/* Formatted on 16/08/2012 21:55:39 (QP5 v5.215.12089.38647) */
CREATE OR REPLACE FUNCTION translator (p_words IN CLOB, -- words to be translated
p_to IN VARCHAR2, -- language to translate to

[Code].....

View 15 Replies View Related

Installation :: Does Windows 7 Home Basic Support Oracle 11g

Jun 7, 2012

Does windows 7 home basic support oracle 11g?

i am getting some error during installation.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved