SQL & PL/SQL :: Google Translator - How To Pass Special Characters In URI Type

Aug 30, 2012

I am using http url for Google translator to convert into different languages.

While passing the string, to escape the white spaces, I am using utl_url.escape . But many of my words contain special characters like '+ , @ , $ , ) ,. ,; [, ] etc.

Not sure how to pass these special characters in uri type.

httpuritype
('http://translate.google.com/?hl=' ||
p_from || '&layout=1&eotf=1&sl=' || p_from ||
'&tl=' || p_to || '&text=' ||
utl_url.escape (p_words) || '#').getclob();

few of my words for translation are

VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + MELISSA OFFICINALIS L.
VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + [ MELISSA OFFICINALIS] L.

View 16 Replies


ADVERTISEMENT

SQL & PL/SQL :: Removing Special Characters And Get Desired Characters From Column Values

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

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

SQL & PL/SQL :: How Special Characters Got Inserted Into DB

Jul 9, 2013

We are using Release 11.2.0.3.0 of Oracle. I am having below special characters inserted into one of my columns, how this value got inserted, (what is the source) i need to track it down.

We dont have any audit trigger on this table to track one level below. As per JAVA guys this is uploaded through a file and the file is having well defined characters and no special characters for this column value also they uploaded the file again but its now going fine with no such special characters. So they put it on DBA's to find how special characters came into database?

Again the editor is not recognising all the characters , so i got the ASCII value for each of the characters in the string, its as below.

String - ‡Mw‹O--ggсÆÔéÓÞ³µmT¤OˆÓ`ôiyïÎ!Ž
ASCII character is : ‡ ASCII Value Is : 14844065
ASCII character is : ‹ ASCII Value Is : 14844089
ASCII character is : -- ASCII Value Is : 14844052
ASCII character is :  ASCII Value Is : 49793
ASCII character is : Ñ ASCII Value Is : 50065

[code]....

View 8 Replies View Related

SQL & PL/SQL :: How To Remove Special Characters

Mar 22, 2013

I need to removed special characters (!, ", #, $, %, &, /, () from a string, i have a table with sll this special characters and words that i have to remove from the string.

How can i do that ?

i have a string with |R!$#&2-_D%2 and i want to get R2-D2

SELECT '|R!$#&2-_D%2' as Original, 'R2-D2' as Correct
FROM DUAL

View 5 Replies View Related

SQL & PL/SQL :: Restricting Special Characters?

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

PL/SQL :: Special Characters Not Working?

Jan 17, 2013

I am using the below query to get the persons details for shell script. Its throwing the error like string not properly terminated but the issue is due to the data is having special characters like below.

select first_name||last_name from employees;

Data output is

O'brainsteve
Stevebross

how to remove these special characters like ' in the query string.

View 5 Replies View Related

SQL & PL/SQL :: Removal Of Special Characters In A String

Jan 2, 2013

I am looking for a SQL query which checks for special character(s) in a string and remove them if any.

for e.g: input string : 'ABCD $ & * # 123 Test'
expected output should be in upper case : 'ABCD123TEST'

we do not know the position of special characters and also what kind of special characters will come as input.

View 17 Replies View Related

SQL & PL/SQL :: Select Data With Special Characters

Feb 16, 2012

I have a table in which a column has some data like this:

prod¿ct_liste¿_25175892
prod¿ct_liste¿_76815456

Is there any way to select this data?

View 3 Replies View Related

SQL & PL/SQL :: Replace Special Characters By SPACE?

Oct 18, 2010

i have a database column holding first name and last name. I want to find out the special characters and convert it to empty space.

Eg : kishore's 001 ==> kishores 001

: jerryKumar* ==> jerryKumar

View 2 Replies View Related

Forms :: UTF-8 - Special Characters Replaced With ?

Oct 27, 2010

We have a table with an nvarchar column that we use to store product descriptions.

This field is maintained on a web form created with the htp package.

Whenever a special character is used (ie, the copyright symbol, trademark, etc), the value is stored correctly in the DB. I've verified this because if i query the value in sql developer, i do see the correct symbol.

However, pulling this piece of data out to display in a formtext box (for edit) replaces all the special characters with ?'s.

Our National Character Set value is set to UTF-8.

Is this being caused by our database character set? or is it a web design problem that i'm just not aware of.

I can post code snippets if this isn't enough info...but I was hoping it'd be fairly simple.

View 3 Replies View Related

Generating MD5 If There Are Any Special Characters In The CLOB

Nov 30, 2012

We are using dbms_crypto.hash to generate the MD5 hash value for a CLOB that will be sent to other feeder systems. The feeder systems validate the file by generating the MD5 hash value on their end and compare with the MD5 generated in Oracle and accept the file only if the MD5 hash value matches.

The MD5 file matches between both the systems except in the case where there are special characters in the CLOB. Somehow, MD5 is prefixing  character before any special character and calculating the MD5 value. In our case, our special characters being ®, §, ™, ©....

This is a high priority issue for us and it is holding our UAT. We are using Oracle 11.2.0.2.0.

View 1 Replies View Related

PL/SQL :: Losing Special Characters In CONVERTTOCLOB

Feb 27, 2013

This is in Oracle 10.2.0.4.0. I have some blob records (delimited text uploads) with some diacritic characters in them, and the diacritics are being lost when I run CONVERTTOCLOB.

database character set is AMERICAN_AMERICA.AL32UTF8

View 9 Replies View Related

Using SQLDriverConnect With Special Characters In Password Fails

Jul 28, 2013

on a windows 2008 machine that has the Oracle instant client 11_1 installed (11.01.00.06) i am calling SQLDriverConnect in the following way:

std::string str = "Driver={Oracle in instantclient11_1};Dbq=//10.10.101.66:1521/orcl;;Uid=myUser;pwd=a;b";
odbcRc = SQLDriverConnect(hdbc, NULL, (SQLTCHAR*)str.c_str(), str.size(), (SQLTCHAR*)szConnStrOut, 1024, &cbConnStrOut, SQL_DRIVER_NOPROMPT)) == SQL_ERROR);

as long as the password contains no special chars (namely semicolon) it works fine. but when I try to use special chars in the password It stops working, with an invalid username/password error.

State: 28000 Native error: 1017 Message: [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

i tried different variations of adding " (\") over the password, over the entire pwd=a;b or braces { but nothing seems to work.the thing is that using ODBC works! what I did was: open ODBC, go to System DSN tab, add "Oracle in instantclient11_1", then fill the following information:

Data source name: Anything
TNS Service Name: //10.10.101.66:1521/orcl
User ID: myUser

then i press test connection, enter the password "a;b" and it works!

View 3 Replies View Related

SQL & PL/SQL :: Finding Out If A Table Column Has Special Characters

Jul 15, 2010

I have this table column of varchar2 data type. I need to find out if it contains anything other than numbers or alphabets(basically to see if it contains any special characters in it).

I just need to fetch only those rows that has special characters. How do I get this?

CREATE TABLE CHECK_SPL_CHARAC
(ADDRESS VARCHAR2(100));

INSERT INTO CHECK_SPL_CHARAC VALUES ('ABC%ABC');
INSERT INTO CHECK_SPL_CHARACVALUES ('ABC_ABC');
INSERT INTO CHECK_SPL_CHARAC VALUES ('ABC?ABC');
INSERT INTO CHECK_SPL_CHARAC VALUES ('ABC*ABC');
INSERT INTO CHECK_SPL_CHARAC VALUES ('1234');
INSERT INTO CHECK_SPL_CHARAC VALUES ('ABC');
INSERT INTO CHECK_SPL_CHARAC VALUES ('AB C');
INSERT INTO CHECK_SPL_CHARAC VALUES ('12 34');
COMMIT;

I need to get the first 4 rows alone in the sql output. I do not wan to get the last 2 rows with space.

View 8 Replies View Related

SQL & PL/SQL :: Remove Special Characters From Input String?

Aug 5, 2010

I have a following table,

create table test1(col1 varchar2(20));

insert into test1 values('4711-3/01');

I believe we need to use Translate function to get rid of special characters, But I would not be knowing what sort of special charecters which appear in the string, In that case how do I use Translate?

View 29 Replies View Related

Reports & Discoverer :: Print Special Characters

Sep 22, 2013

i want to display such as ratio and degree in the reports 6i, how can i add them ?

View 2 Replies View Related

SQL & PL/SQL :: How To Retain Special Characters While Extracting From DB In UNIX

Jul 16, 2013

In my DB there are special characters are stored like "Świętochłowice". So in Unix script while extracting these characters, I have used
export LANG="universal.UTF-8" in order to make it English. which works fine.

But my question is how to retain this special character intact as, it is in DB?

So in UNIX script
export LANG="universal.UTF-8"
sqlplus -s uname/pwd@hostname/schema << ENDSQL | sed -e "s/Connected.//" -e "/^$/d"
set pagesize 0 feedback off verify off heading off echo off serveroutput on size 10000
spool /path/out.txt
Select name from tablename where is=12;
spool off;
exit
ENDSQL

Output is "Swietochlowice" (makes sense),but how to get the output as "Świętochłowice" which is in DB? I have tried different NLS_LANG option, but no success.

View 5 Replies View Related

SQL & PL/SQL :: German Data Upload Special Characters

Sep 20, 2010

oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"

I am uploading the data file which is a .csv, into one of the tables.. Few columns of the data file, contains sentences in German - like- Lötstelle Zinnspritzer Zinnschluß .. and while loading the problem that i encounter is - it doesnt recognize the commas, and doesnt know where the field ends..
e.g., in this line 1540,Lötstelle Zinnspritzer Zinnschluß,solder short,45230,94885,0,0,0,0,0,0,0,0,0,0,0,0

sometimes it assumes comma after 1540,Lö,tstelle and then no commas till Lö, tstelle Zinnspritzer Zinnschlußsolder short,

and sometimes, the whole as one line Lötstelle Zinnspritzer Zinnschlußsolder short4523094885,0,0

View 2 Replies View Related

PL/SQL :: How To Find Special Characters In A Single Query

Sep 12, 2012

My query is "How to find all special characters like (%$*&@,;'/+- etc. in a single query?"

e.g.

A_MIR
A%SIM
A*SIM
A)SIM

View 6 Replies View Related

Function To Convert Special Characters To HTML Code?

Nov 5, 2008

The HTML code for the bracket character '[' is & # 91; (without spaces). In my SQL, I would like to convert the word [you into & # 91;you. Is there a way to do that?

I know that replace() will work, but with that you have to supply a list of chars to replace; I

View 3 Replies View Related

SQL & PL/SQL :: Select Query To Check For Special And Non Printable Characters?

Jun 19, 2013

Is there any sql select query to check and find for special and non printable characters in a table column.

View 4 Replies View Related

SQL & PL/SQL :: How To Execute Dynamic Query In Procedure With Special Characters

Dec 17, 2012

I have the following procedure body in a package.

PROCEDURE getrecordsForinspection(i_table_name in varchar2, i_thread_id in varchar2, i_max_count in number default null, o_results out sys_refcursor)
AS
v_sql varchar2(1000):= null;

begin
v_sql := 'update '||'i_table_name||' set status = '||'''IN_PROCESS-'||i_thread_id||''''||' Where final_status = '||''''STATUS_ACCEPTED'''||' and ('||i_max_count||' is null or rownum <= '||i_max_count||');';

EXECUTE IMMEDIATE(v_sql);
commit;
end;

when I execute the above procedure it gives the following error.

ORA-00911: invalid character
cause: Identifiers may not start with any ASCII characters other than letters and numbers.$#_ are also allowed after the first character. Identifiers enclosed by double quotes may contain any character other than a double quote. Alternative quotes(q'#....#') can not use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL language reference Manual.

I think dynamic sql is not executed because of the pipe character in the sql statement.

View 2 Replies View Related

Reports & Discoverer :: How To Represent Special Characters In Oracle

Aug 21, 2012

How to represent special characters in oracle reports. i have a field which takes some data in varchar format in this i used some special symbol its fine when store it into the database but when i generate report this special symbols are represented by mirror of ?

View 3 Replies View Related

SQL & PL/SQL :: Pass More Characters To In Mode Parameter Using Procedure

Feb 26, 2012

I am trying to pass many characters to the in mode parameter using procedure , but i am getting the below error.

ORA-06550:
PLS-00172: string literal too long

CREATE TABLE USR_DETAILS
(
LOAD_ID NUMBER NOT NULL,
LOAD_DATE DATE,
USER_VALUE VARCHAR2(4000 BYTE),
USERID VARCHAR2(4000 BYTE)
)
insert into user_details values('1','2/10/2011','PROD1','USER1');
insert into user_details values('2','2/10/2011','PROD2','USER2');
[code]......

I have written the code as below...

Procedure concept :

Here i will seperate the strings(input parameters) using comma(,) symbol . Here users may pass more than 5000 characters to single in mode parameter, so i have tried with clob datatype but no luck.

CREATE OR REPLACE procedure user_details_proc (user_value1 IN varchar2,
user_value2 IN varchar2,
user_value3 IN varchar2,
user_value4 IN varchar2,
user_value5 IN varchar2,
userid IN varchar2
) as
[code].......

View 2 Replies View Related

Reports & Discoverer :: Special Characters Coming In Text Output Format Of Oracle?

Jan 27, 2012

I have developed one rdf in Text Output Format.In this some special characters is coming for Text Output format of rdf.Shall i do any adjustments in layout? How to remove these special characters?

View 3 Replies View Related

SQL & PL/SQL :: How To Pass Type Object As A Parameter To Stored Procedure

May 9, 2012

I am fairly new to oracle, here's what I am doing.

Create or replace type csc_info as object( source_code varchar2(10),
Docno varchar2(10),
Key_value_1 varchar2(10),
Key_value_2 varchar2(10));

[Code]....

I need to test the procedure how do I pass the inputs for the type object csc_info?

View 2 Replies View Related

PL/SQL :: How To Pass Object Type As Input For Search Criteria

Mar 26, 2013

I have search function that takes the input parameters and returns all the matching rows. this is straight forward only. My problem is having multiple types as a input parameter. that is the reason i am not able to pass the input value for these types.

My Input Type table looks like this.

CREATE OR REPLACE TYPE T_T_PARTY_REQUEST_CRITERIA
AS TABLE OF T_O_PARTY_REQUEST_CRITERIA;
/
CREATE OR REPLACE TYPE T_O_PARTY_REQUEST_CRITERIA
AS OBJECT
(
SYSTEM_IDENTIFER VARCHAR2(50),
PROCESS_TYPE VARCHAR2(50),
[code]........

Last two inputs are type again.my question here is how to pass the values for these two T_T_PARTY_KEY_IDENTIFIER and T_T_ADDTN_IDENTIFIER_INFO. I have defined the the last two types following.

CREATE OR REPLACE TYPE T_T_PARTY_KEY_IDENTIFIER
AS TABLE OF T_O_PARTY_KEY_IDENTIFIER;
/
CREATE OR REPLACE TYPE T_T_ADDTN_IDENTIFIER_INFO
AS TABLE OF T_O_ADDTN_IDENTIFIER_INFO;
/
[code].......

I have pasted the query here from my function. when i pass the null as part of input for these 2 types my query is working. otherwise it is saying invalid Identifier.First I tried with first Type.

I am passing the value as

(PRKYTP.PRTY_KEY_TYP_NM = ITTPRC.PARTY_KEY_IDENTIFIER.PARTY_KEY_TYP_NM OR ITTPRC.PARTY_KEY_IDENTIFIER.PARTY_KEY_TYP_NM = 'ALL' OR ITTPRC.PARTY_KEY_IDENTIFIER.PARTY_KEY_TYP_NM IS NULL);

Error is Error(34,147): PL/SQL: ORA-00904: "ITTPRC"."PARTY_KEY_IDENTIFIER"."PARTY_KEY_TYP_NM": invalid identifier

SELECT DISTINCT T_O_PARTY_REQUEST_IDENTIFIER(PR.PRTY_RQST_ID) BULK COLLECT INTO T_T_P_R_CRITERIA
FROM TABLE(CAST(I_T_T_PARTY_REQUEST_CRITERIA AS T_T_PARTY_REQUEST_CRITERIA)) ITTPRC,
PRTY_RQST PR
JOIN BUSN_APPLC BIAP ON BIAP.BUSN_APPLC_ID = PR.BUSN_APPLC_ID
[code]........

View 4 Replies View Related

Application Express :: Google ReCaptcha Plugin In 4.2

Oct 31, 2012

We have just upgraded from APEX 4.0.1 to APEX 4.2. The installation and migration of the applications went very well (after installing the patch for the import of the workspaces :-) ). But we have met a problem - we have a Google reCaptcha plugin on 101 page (authentication page). It has runs pretty well on 4.0.1, but after upgrade whole plugin item just has disappeared from 101. Actually it has disappeared from IE9, IE8, Mozilla 16 and Google chrome. The only browser that is displaying reCaptcha is Opera.

why this happened and how we can fix it? The client wants to make some tests this week and we have to fix the situation.

View 1 Replies View Related

Application Express :: Integration With Google Map Visualization

Nov 1, 2013

Is there a way I can integrate my customer base (over 100k with address information) to a Google map. High level, I want my user to enter an address and on google map it should show me markers for existing customers closer to that address. 

View 3 Replies View Related







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