SQL & PL/SQL :: Trimming Euro Symbol In Given String

Nov 23, 2012

I am using the following query to trim the white space and enter character in the given string. BUt it is trimming the euro symbol also.

SQL> select regexp_replace(i_ruleexpression, '([^[:graph:]|^[:blank:]])','') into i_ruleexpression from dual ;
i_ruleexpression: Item.addChildByName("Advantage Smart 75 (-15€)")

View 11 Replies


ADVERTISEMENT

Client Tools :: To See Euro Symbol In PL/SQL Developer On Windows 7

Nov 22, 2012

When I try to select euro symbol in a table it is showing as '¿' in pl/sql developer on windows 7 where as I am able to see in windows XP.

SQL> select '€' from dual;

'¿'
---
¿

suggest to get the euro symbol.

View 1 Replies View Related

Client Tools :: Unable To Insert Euro Symbol In Database With Character Set WE8MSWIN1252?

Mar 29, 2011

I am using oracle 9.2.0.6.0 on HP-UX.

I am unable to insert and even display euro symbol from server as well as windows client.

Following are the details of my database server

SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252

[code]....

1) When I try to insert € from Db server (using putty) using Alt+0128 it does not print anything (nothing gets typed on the screen). Not even junk characters Also following query does not print anything

SQL> select chr(128) from dual;
C
-

2) while I set NLS_LANG on client and try to insert €, Alt+0128 produces a question mark symbol And following query displays junk character

SQL> select chr(128) from dual;

C
-
Ç

3) Regardless when I inserted couple of rows and tried UNISTR following was the result

SQL> select unistr(v) from t;
Error 45 initializing SQL*Plus
Internal error
$

View 19 Replies View Related

How To Change Decimal Symbol And Digit Grouping Symbol

Jun 19, 2011

Currently , my system using , as digit grouping symbol and . as decimal symbol in Oracle forms and report. Is there any way to reverse that to the whole system?

View 3 Replies View Related

Trimming Strings - Comparing?

Jul 26, 2007

I have 2 strings that I want to compare for example

string1 = 'ABC~AB/10/1234'
string2 = 'ABC~AB/10/1234~.....'

There could be anything after the 2nd ~ in string 2 is there a easy way of trimming string2 to the first 14 Characters? Or do I have to find the 2nd instance of ~ and then remove everything after (and including) that?

View 2 Replies View Related

Forms :: Trailing Space Automatic Trimming In Forms

Sep 20, 2012

We are using Oracle Forms 6i and back-end as Oracle 10g Database. We are facing a specific problem while working with Forms6i. I am giving the steps as showm below:

1. We have a table named TEST (a number not null, b char(1) not null).
2. When we insert a record throuhg SQL*PLUS like this:
insert into test values (1, ' '). The record is inserted in the table TEST successfully.
3. We checked the length of column b i.e. select length(b) from test, it is showing 1. This is the correct value because it has inserted a space in column 'b' of the table TEST. (That's what we want).
4. We created a form having data-block from table TEST and trying to insert the same record throuhg Forms9i.
5. There it gives an error of "Unable to INSERT record" becuase in form builder, it is trimming the spaces for column 'b' automatically and making it NULL. Since the column 'b' defined as NOT NULL in table TEST, hence generating the error. (Basically there in form builder, it is generating ORA-01400 error which is can not insert NULL value in NOT NULL column).

We would like to know why in form builder, space is automatically being trimmed to NULL..? We do not want this to happen. We want space to be inserted as space only. How can i implement this case, becuase we need this kind of functionality in our form builder application.

View 2 Replies View Related

SQL & PL/SQL :: Escape Operator Symbol?

Feb 28, 2011

1) Can we set a different symbol other than '' for escape operator.
2) If yes, how to see the current escape operator symbol.
3) How to find out the below name with escape operator?

Employee name ----> rama_krishna_raj

View 2 Replies View Related

SQL & PL/SQL :: Join In A Query Which Has (+) Symbol At End

Oct 26, 2011

I have come across a join in a query which has the (+) symbol at the end of it.

View 3 Replies View Related

SQL & PL/SQL :: Encountered The Symbol End-of-file?

May 27, 2011

i am getting error for this code

CREATE OR REPLACE FUNCTION "ABS"."PROCESS_YEAR"(processYear DATE) RETURN NUMBER DETERMINISTIC IS
year NUMBER:=NULL

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_

View 3 Replies View Related

How To Get The Column Data Consist Of % Symbol

Mar 15, 2009

I want a query to get the column data , which consists of % symbol ,using like .

Sample :

The varchar data type column consit of columns 100%,100 ,90% ,77% with the Query i have to get the rows as 100%,90% ,77%. (i can get the data using in operator but i want to know how to get that using like).

View 1 Replies View Related

SQL & PL/SQL :: Insert Rupee (currency) Symbol

Apr 8, 2013

I want to display currency Rupee(Indian Currency) symbol in salary.

I am getting only $ symbol.

how to do it.

tell the process.

View 2 Replies View Related

SQL & PL/SQL :: PLS-00103 - Encountered Symbol NUMBER

Jun 7, 2011

I am trying to schedule a DBMA_JOB and getting the below mentioned error.

JOB:
====

declare
VARIABLE v_jobnum NUMBER;
begin
DBMS_JOB.SUBMIT(job => v_jobnum,
what => 'dbms_refresh.refresh(""CLARITY"."M_MV_INBASKET_ANALYSIS"");',
next_date => to_date("05-07-2011 13:45","DD-MM-YYYY HH24:MI"),
interval => '(ADD_MONTHS(TRUNC(SYSDATE,"MM")+4,1)+13.75/24)');
end;
[code]....

View 20 Replies View Related

PLS-00103 / Encountered The Symbol (end-of-file)

May 18, 2010

when creating this,

create or replace package body test as

employees emp_tab := emp_tab();
procedure test1 as
g_ref sys_REFCURSOR;
BEGIN
employees.EXTEND(2);
employees(1) := emp_type (1, 'name1');
employees(2) := emp_type (2, 'name2');
OPEN g_ref FOR
SELECT * FROM TABLE (CAST (employees AS emp_tab));
END test1;

I got a error ERROR at line 11: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

begin end function package pragma procedure form

1. create or replace package body test as
2. employees emp_tab := emp_tab();
3. procedure test1 as

View 1 Replies View Related

JVM :: Ncomp Cannot Find Symbol TransitiveClosureDumper

Aug 22, 2012

I'm trying to ncomp a helloworld jar.I have already loaded the jar file in the db using loadjava. JAVA_HOME is pointing to ORACLE_HOME/jdk

While ncomping I'm getting the following error :

resolving: source oracle/jaccelerator/server/SQL
errors : source oracle/jaccelerator/server/SQL
oracle/jaccelerator/server/SQL:20: cannot find symbol
symbol: class TransitiveClosureDumper
public class MinimizeNcompListAndDumpTC extends TransitiveClosureDumper

Oracle Version is 11.2 on a linux box.

View 0 Replies View Related

PLS-00103 / Encountered Symbol NUMBER When Expecting One Of Following

Jun 7, 2011

I am getting the below error while trying to schedule a simple dbms_job.

JOB:
=====
declare
VARIABLE v_jobnum NUMBER;
begin
DBMS_JOB.SUBMIT(job => v_jobnum,
what => 'dbms_refresh.refresh(""SCHEMA"."MyMaterializedView"");',
next_date => to_date("05-07-2011 13:45","DD-MM-YYYY HH24:MI"),
interval => '(ADD_MONTHS(TRUNC(SYSDATE,"MM")+4,1)+13.75/24)');
end;
/

ERROR:
======
LINE TEXT
2 ORA-06550: line 2, column 19:
1 PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following:
1 := . ( @ % ; not null range default character
1 The symbol ":=" was substituted for "NUMBER" to continue.

View 2 Replies View Related

Forms :: How To Display Password In Symbol Style

Dec 14, 2011

i want to make a form from creating new user and password but i don't know how to display password in *** style and how to save it with s-key character.

View 1 Replies View Related

Forms :: How To Validate Alphanumeric And Symbol In Textbox

Nov 12, 2012

I have created a form that have a button to check the character in the textbox is alphanumeric and symbol. Here attached the code, that i tried from other post.

View 5 Replies View Related

Client Tools :: Comment On Column With And Symbol?

Jul 31, 2012

I wanted to Comment on Column with & symbol. correct the syntax

Syntax
SQL> comment on column scott.emp.empname is ' Jerry&Tom. ' ;

ERROR
Enter value for t:
SP2-0546: User requested Interrupt or EOF detected.

View 5 Replies View Related

Reports & Discoverer :: How To Put New Indian Rupees Symbol

Sep 13, 2011

I want to put new indian rupees symbol in my oracle report i have put fornts in start > controlpanel >fornts. and i type this symbol in microsoft word also but i cannot put this symbol in oracle forms. So how can i put this symbol in oracle forms

i also read this [URL]...

View 4 Replies View Related

Client Tools :: Print Temperature Along With Its Symbol?

May 23, 2012

I need to print temperature along with its symbol. how it is possible in oracle reports? for example 45 (degree centigrade in symbol format.)

View 5 Replies View Related

SQL & PL/SQL :: TRIM Function - Remove Symbol Only From LEFT Or RIGHT Side

Feb 22, 2011

Is there any possibilites to remove the symbol '*' only from LEFT or RIGHT side, instead BOTH the side.

select '>' || trim (both '*' from '***removing stars at both sides***') || '<' "Stars removed" from dual;

View 4 Replies View Related

Reports & Discoverer :: Rupees Symbol On Linux Environment In 6i

Nov 30, 2011

I have one problem related to run Report 6i on Linux Environment.I have created new report with New Rupees Symbol(Rupee foradian) for Windows Operating System it is working properly appears new rupees symbol sign properly.

But i compile same report in linux environment and after that run through browser new rupees symbol not show properly instead of rupees symbol `(entitled sign)appears on my report.

View 9 Replies View Related

Reports & Discoverer :: How To Print Copyright Symbol In Rdf Report

Jul 17, 2012

how to print copyright symbol in rdf reports. I receive a ? when it gets printed.

View 3 Replies View Related

Reports & Discoverer :: How To Set New India Rupee Symbol In Report

Jan 7, 2012

I want to know how to set new India rupee symbol in report.I have change the format and paste that icon but when run report it's not showing that report.

View 3 Replies View Related

Reports & Discoverer :: Recover From Hour Glass Symbol

Mar 21, 2011

I have logged into Oracle and Discoverer several times and every time when I'm running a report in Discoverer, it quits responding. This is after I already have the data, and I'm scrolling to the bottom of the data to get the next 10,000 rows.

I just get the "hour glass symbol" and then i basically have to shut down and restart my computer.how to recover from these type of hour glass symbol.

View 2 Replies View Related

Precompilers, OCI & OCCI :: Unsatisfied Code Symbol (dladdr) In Load Module?

Jul 15, 2008

Recently, i had to restore /usr/lib folder (because some files crashes) to a previous point. This restore point is previous to Oracle client installation. Well, now, when i try to compile my Pro*C samples:

# make -u -f demo_proc32.mk sample1
/usr/ccs/bin/make -f
/oracle/oracle/product/10.2.0/client_1/precomp/demo/proc
/demo_proc32.mk OBJS=sample1.o EXE=sample1 build

[code]...

Can i fix it without re-installing Oracle client?

View 1 Replies View Related

ORA-02085 - Database Link String Connects To String

Jun 19, 2012

I have this error (and solution):

ORA-02085: database link string connects to string

Cause: a database link connected to a database with a different name. The connection is rejected.

Action: create a database link with the same name as the database it connects to, or set global_names=false.
Where should I set global_names=false ?

View 7 Replies View Related

SQL & PL/SQL :: How To Find Whether Exact String Is Present / Not In Given String

Mar 14, 2013

I'm facing some problem even after using INSTR function in Oracle.The problem is I have written the logic in the PL/SQL block which appends all the values fetched in a loop on the basis of whether the string is present or not.

For ex:

The first value fetched from the select query first is ABCDEFG which gets appended to a variable
The next value fetched is AB even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The next value fetched is BCDEF even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The third Value fetched is ABCDEFG this will not get appended presently according to the logic which is correct.

writing that piece of code to append the value fetched which doesn't exactly match with the existing string

View 3 Replies View Related

How To Use String Buffer Instead Of String Query

May 9, 2008

show an ex to use string buffer for select statemnt

View 1 Replies View Related

Reports & Discoverer :: Symbol In Oracle Reports

Oct 29, 2011

I have a report I am currently working on...see attached file. I have circled two symbols. I know the one on the left is "page break after" but I am not sure why this field would have this setting.

Tell me what the symbol on the right means? Also, I have confine and flex set to "off" on all fields and items, yet when I move one of the fields other fields start to move as well. I am supposed to swap the bill to and ship to address which should be simple but so far it's not.

View 4 Replies View Related







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