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
ADVERTISEMENT
Apr 2, 2010
I have the data in the table like
Name
----------
a/bc
a*bc
a_bc
a&bc
So while retreiving the data from the above table so i need the data like
Name
--------
abc
abc
abc
abc
I need to Restrict the Special Characters.
View 5 Replies
View Related
Jun 2, 2010
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.
View 2 Replies
View Related
Apr 17, 2013
I am unable to insert string of Hindi language characters with 1800 character length in column having data type VARCHAR2(4000).
I am getting error "ORA-01461: Can bind LONG value only for insert into a LONG column"
NLS parameters for database are :
PARAMETERVALUE
NLS_LANGUAGEAMERICAN
NLS_TERRITORYAMERICA
[Code]....
Is there any way to insert this string in VARCHAR2 column? I can't change data type to CLOB (with which I able to insert this string).
View 1 Replies
View Related
Jul 23, 2013
create table test
(
name varchar2(50),
descd varchar2(50)
)
insert into test values ('kethlin','da,dad!tyerx');
insert into test values ('tauwatson','#$dfegr');
insert into test values ('jennybrown','fsa!!trtw$ fda');
insert into test values ('tauwatson','#$dfegr ,try');
how do I get the first three characters and last three characters from name field and remove all the junk characters from descd field?
so my o/p be like;
Quote:('ketlin','dadadtyerx')
('tauson','dfegr')
('jenown','fsatrtw fda')
('tauson','dfegr try')
View 6 Replies
View Related
Feb 6, 2012
1. i want that if a form is opened in one user session. it will not be available to other users.
2. if a user executes a procedure. it should not be available to other users to execute until the first execution completes.
View 12 Replies
View Related
Nov 14, 2010
i want to restrict the user if he/she enters any 3 consecutive sequence of numbers,characters,alphanumerics and special characters for example aaa, aAa, @@@, ---- , 111, 123 are not valid.
valid sequences are a1w,?1A,aa1,WW2,78a,-#a
i want to show the invalid sequence in a single query using regular expression function. suppose for example if user enters aaa,$$$,123 then the query output is aaa,$$$,123.
i have written two different queries for that but i want a single query
SELECT REGEXP_SUBSTR('EEE','([a-z])\1\1',1,1,'i') FROM DUAL;
SELECT REGEXP_SUBSTR('111','([0-9])\1\1',1,1,'i') FROM DUAL;
SELECT REGEXP_SUBSTR('@@@','([^-$])\1\1',1,1,'i') FROM DUAL; -it is not checking for -(hypen) characters
any 3 consecutive characters from key board.
View 2 Replies
View Related
Jan 28, 2010
i am working on attendance system using barcode scanner.
i want the user can only mark his/her attendance by scanning the attendance card.and cannot use keyboard.
View 9 Replies
View Related
Oct 17, 2010
The application user owns the application schema which owns all the database objects in this schema. Now 50 of our developers need access to this application schema but giving away the password for the application user is risk as "Drop user application cascade" and wipe off all the objects. The option i have is to create 50 separate users with tablespace as application and grant all rights to application schema.
View 9 Replies
View Related
Oct 1, 2013
I wanted to restrict the Users to login to DB using Application like TOAD or PL/SQl Developer .
But the users can login to DB using sql*plus.
We can get this info once user looged in to DB.
SQL> select SID,USER#,USERNAME,SERVER,MODULE from V$SESSION where USERNAME='LIVE4LEARN';
SIDUSER#USERNAMESERVERMODULE
12418265LIVE4LEARNDEDICATEDSQL*Plus
23018265LIVE4LEARNDEDICATEDPL/SQL Developer
43718265LIVE4LEARNDEDICATEDPL/SQL Developer
54018265LIVE4LEARNDEDICATEDPL/SQL Developer
Can we make this check done before login process and allow users to login when module not in ('TOAD','PL/SQL Developer').
View 15 Replies
View Related
Dec 22, 2012
restrict access to page or component for particular user. when that user login , restricted page should not be visible to the user..
APEX Verison :4.2
View 1 Replies
View Related
Oct 25, 2011
I would like to create a report specifying to few page numbers. Currently the report generates with all data for say e.g. 300 pages. I want this(original_300pages) report also i want copy of the same report with only first 20 pages.
View 1 Replies
View Related
Nov 4, 2012
We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.
Technologies are Oracle ,SQL
View 3 Replies
View Related
Aug 9, 2010
what name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)
I currently have this:
IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;
Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?
Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.
I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?
DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
View 5 Replies
View Related
Apr 16, 2010
My question is--> Is it possible to create procedure with embeded C code ?
View 10 Replies
View Related
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
Sep 14, 2007
I would need to translate the Oracle PL/SQL procedure to SQL Server 2000 SP4.
This is a package (body) that needs to be translated into a form that SQL server 2000 can unserstand it.
AS
FUNCTION object_name_fix (sobjectstring IN VARCHAR2)
RETURN VARCHAR2
AS
[Code].....
View 1 Replies
View Related
Mar 20, 2013
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.
View 1 Replies
View Related
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
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
Mar 12, 2012
I want to enter data in Arabic and English through Oracle Forms6i.
View 8 Replies
View Related
Feb 14, 2008
Any one tell me how can i enable urdu in oracle 9i which charter set will be use
View 2 Replies
View Related
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
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
View 1 Replies
View Related
Jan 30, 2012
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.
Attached File(s)
Doc1__1_.doc ( 41K )
Number of downloads: 2
View 1 Replies
View Related
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
Feb 4, 2011
how can i change my oracle database language
View 6 Replies
View Related
Dec 2, 2012
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?
View 6 Replies
View Related
Apr 6, 2010
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.
View 6 Replies
View Related
May 21, 2013
I want to display data in Chinese language.I have a emp table in my scott user.
View 7 Replies
View Related
