Forms :: How To Create LOV Via Own Mother Language
Apr 28, 2011
I am using Developer 6i and oracle 8i. when we r create LOV , it's generate by English language. and it's contains 3 button . this r find, ok , cancel button. but now i want this 3 button language show by my mother language(Bangla language). it's possible
cookiemonster wrote on Wed, 20 March 2013 22:01Or if the user does anything to wipe the modified data - clear block, enter query etc - forms will also raise the alert.
i've uploaded a new RTF for Spanish but wen i login with the Spanish creds and run the program. Its not showing the changes i've chosen the right language and territory code.
I have a problem concerning the display of language specific apostrophes (Czech, e.g. in "Další") in Oracle Forms (Labels/Prompts):
In my local Forms Developer /OC4J they are displayed correctly, but when I copy the module onto the IAS (Unix) the are not shown correctly.I already tried several fonts, but none is working for me.
There is a table called cd_details. It has fields like id, name, language, type etc.I need a form where the user can search the database on basis of language and name and then display the other details. I used a data block wizard and given a push_buttonwith (execute_query). But it's very clumsy. For eg, if the user presses next the next button then all the records are being displayed. Is there any way to do this thing in a better way?
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)
My colleague sent me a sql script to copy and execute in Toad for Data Analysts (see attached). Once I execute I get error messages on the date and a few other lines. My question is should I completely rewrite the script?
I would rather have this in a grid format anyway with the same data instead of how this script is pulling. I'm very green when it comes to this (if you didn't notice) and need some insight esp. on the date format considering the date column has 10 digits i.e. 1209105576.
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?
I am using oracle 10 g database on windows xp. I have backup of data contains data in local language (Marathi). I want read this data in oracle itself.Which character set need to choose?
I've recently been asked to replace certain English text fields with their French translation. I thought I could do this with the replace function: line_desc_reformed := replace(l.Line_Description,'Labor Item for Regular Hours','Main d uvres pour les heures rgulire');
The special characters do not get translated. So I tried the CONVERT function: line_desc_reformed := CONVERT(line_desc_reformed, 'WE8MSWIN1252', 'WE8DEC').
All gets translated except for the tick mark after the d. It gets replaced by an upside down? I have tried several different language sets and can not get that to convert.
also when using the dbms_xmldom to convert this to xml, the also gets replaced by an upside down ?. I don't belive you can change the charset when using this package.
how to connect to Oracle to retrieve data using SQL language. I've started with a new company which is pretty much a sink or swim type of environment meaning you're an idiot if you don't figure it out on your own. I was told that we use Toad for Oracle 10g. I was given a server name; location and an .ora file named tnsnames that was given to me but I have no clue what to do with. I've come from companies where this was already setup. You just go into access to retrieve the data.
II have totally hit a brick wall with all the other roadblocks I encounter and all researched out. Where I can get step by step instructions on how to connect to start sql in Toad/Oracle?
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
I need to converte apex app in welsh language and welsh is supported by apex.What other alternative we take apart from Apex default language translation.
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.
I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.