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


ADVERTISEMENT

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 View Related

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

Forms :: Setup Arabic Language

Aug 8, 2010

My arabic data appears like ???????

How could I setup Arabic for forms , database?

I have 10G oracle database, forms,reports.

View 13 Replies View Related

SQL & PL/SQL :: Arabic Language Appearing In A Different Format?

Mar 13, 2011

While generating reports, arabic languages are not exceuting in a normal format.

instead of سيبسيل its appearing as ÈãÇÚÒ íÊÎØÇÁ ÇáÔÇÑÚ æÇÕØÏãÉ æÊæÝÇÁ ÇáãÇÚÒ

[/bold]

1) we have done following changes at DB level.

CONN SYS/SYS@THAI AS SYSDBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;

[code]...

2) also installed regional Language.

View 10 Replies View Related

Forms :: Change Language - English To Arabic

Apr 18, 2010

Which is changing language in form from English to Arabic and vise versa during run time when I validate from item to another one ..

View 5 Replies View Related

Forms :: Arabic Support And Rich Text Tool In Report 10g

Dec 16, 2012

I have two requirements that we have an ERP with default language (English US) and now we need :

1) Put Arabic support in our forms and reports
2) Add Rich Text Tool in our forms and reports

View 2 Replies View Related

SQL & PL/SQL :: Transfer Data - Arabic Language Column Appears As Junk

Feb 8, 2012

When I transfer the data from Oracle to MS SQL I have one column in a table which is of Arabic Language.The data is fine in Oracle but when I transfer it to MS SQL Server I see that the text in MS SQL server appears as junk.

View 1 Replies View Related

Server Administration :: Language In Oracle 10g

Jul 16, 2013

I have an Oracle DB's charset configured for Korean language and things in there are English and Korean and they are working fine. If i try to import a txt file with Chinese characters into the DB. It doesn't show correctly on query.

Is there any way I can solve this ? Since I find that there are many charset / NLS language options througout DB. I read from others that they have the following response. Any alternative beside changing the whole DB charset ?

Recreate the database with the correct character set
Convert the database to AL32UTF8. Documentation link
Change the databases National Character Set to AL32UTF8 & change your application to use NVARCHAR2()/NCHAR() datatypes instead of VARCHAR2() (documented at the same link as above)

View 5 Replies View Related

Server Administration :: Write Bangla Language In Oracle 10gR1 / 10gR2 And Express

May 17, 2012

I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but failed. When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.

View 3 Replies View Related

Server Utilities :: IMP With Different Language Settings?

May 7, 2010

i have to import Data (exported with EXP) from a 8.1.6 Database running with GERMAN_GERMANY.WE8MSWIN1252 language settings. The destination database is running with GERMAN_GERMANY.AL32UTF8.

What do i have to do to import (IMP) the data correctly?

View 2 Replies View Related

SQL Server Query - Oracle Does Not Support OUTER APPLY Statement

Feb 1, 2012

DECLARE @MainTable TABLE (UniqueID INTEGER, Category VARCHAR(200), WeekDate DATETIME, VALUE INTEGER)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/07/2011', 5000)
INSERT INTO @MainTable VALUES(123, 'Shirts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(124, 'Pants', '10/07/2011', 4000)
INSERT INTO @MainTable VALUES(125, 'Shorts', '10/14/2011', 8000)
INSERT INTO @MainTable VALUES(126, 'Shoes', '10/21/2011', 9000);
--select * from @MainTable;
[code]...

The query works with all the CTEs up to the last select statement. Oracle does not support the OUTER APPLY statement, how should the last piece be written to make it work in Oracle?

View 1 Replies View Related

Server Utilities :: Does Oracle Forms / Report Services (Standalone) Support Data Export Utility

Jun 10, 2010

I have a From which take Logical Backup through oracle export utility. This Form work fine when i Start OCJ4 but when i want to take backup after running oracle Forms & Report services its not take backup.

My Question is dose Oracle Forms & Report Services (Standalone) Support data backup through Export (exp) utility. I have install Oracle Forms and Report Services (Standalone) on Window XP (SP-3).

View 1 Replies View Related

Transfer Data To SQL Server 2008 / Arabic Data Showing

Jan 15, 2013

I am trying to transfer data from Oracle database table into another table resides in a SQL server 2008. A database link is already set, and data can be selected/queried using

select * from a_table@db_link

the thing is when trying to insert Arabic data from Oracle to a SQL server table

insert into a_table@db_link values(
'N''some data in Arabic'' ,
'11-oct-00',
'some data in English'
);
commit;

its inserted alright, but when we try to display the data it shows like this instead of displaying Arabic, the english data is alright, but also date show as garbage?!!

when trying to insert arabic data directly through SQL server its fine though.I suggested that we transfer data through ODBC to flat files like Acess and then to SQL server but the team rejected it since they're going to do it daily and the data is huge( we are talking more than 28000 records).

View 1 Replies View Related

Audit Vault/Firewall :: How Max Storage Can Audit Vault Server Support

Aug 18, 2013

AVDF current version 12.1 not support External/SAN storage. my question is, if customer get a huge number of Audit log and DBFW event records, then how max size can Audi Vault server support for online data (not archive data)? and can I use a Hardware server with multiple HDDs for AV Server?

View 0 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

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

Forms :: Displaying Arabic In 10g

Sep 15, 2009

1-i have exported a database 9i with character set WE8MSWIN1252 which is her original character set;
2- i have created a new database 10G R2 with character set AL32UTF8;
3- i have imported the .dmp file to this new database with imp.exe 9i version configured with WE8MSWIN1252 character set;

-The problem is:

* when i use sqlplus, arabic data displays correctly but, in forms 10G, arabic data displays lick this ?E?? EC???IEC...... HOW CAN I CONFIGURE FORMS TO DISPLAY CORRECTLY ARABIC DATA?

View 3 Replies View Related

SQL & PL/SQL :: Week On Particular Day According To Arabic Calendar

May 26, 2013

As my requirement is that to find week for particular date according to Arabic calender.As per Arabic calender first day for year starts from saturday.

so when i execute query :

select to_char(to_date('05/26/2013','MM/DD/RRRR'),'WW')
from dual;

Then it gives 21,but as per arabic calender it should show 22nd week.

getting result according to Arabic calender as it should return 22,because weak starts from saturday according to Arabic calender.

View 6 Replies View Related

Forms :: Arabic Characters?

Mar 17, 2010

problem is that when i call run_product to generate a report from a form i have the name of employee in arabic characters appear in wrong form. yet when i use query from forms directly or from reports directly. name appears correct.

i want the arabic charcters to appear correct when i call to show report from a form..

View 6 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







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