SQL & PL/SQL :: Insert Rupee (currency) Symbol
Apr 8, 2013I want to display currency Rupee(Indian Currency) symbol in salary.
I am getting only $ symbol.
how to do it.
tell the process.
ADVERTISEMENT
Reports & Discoverer :: How To Set New India Rupee Symbol In Report
Jan 7, 2012I 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 RelatedForms :: Insert The New Indian Rupee Font?
May 6, 2011I would like to know how to insert the new indian rupee font in forms and report.
I did try doing it myself, but couldnt succeed.
Performance Tuning :: Update Currency Column Of One Table Using Other Table Currency Column?
May 11, 2012I am trying to update currency column of one table using the currency column of other table using the following sql code.
update ODS.SO_ITEM OSI
set CURRENCY__CODE=(select currency__code from sa_sales.SO_ITEM SSI where SSI.ID=OSI.ID)
This update is taking taking a lot of time and is never ending.
should i create index on source table (SA_SALES.SO_ITEM) or on target table (ODS.SO_ITEM) ?
Client Tools :: Unable To Insert Euro Symbol In Database With Character Set WE8MSWIN1252?
Mar 29, 2011I 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
$
How To Change Decimal Symbol And Digit Grouping Symbol
Jun 19, 2011Currently , 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 RelatedSQL & PL/SQL :: Currency Conversion In SQL To Create A View
Apr 27, 2012I need to implement the Currency Conversion logic in SQL to create a view.
Sample data
Acount Table
Accno Amt Crncy_id
--------------------
101 1000 1
102 500 2
103 500 2
104 500 3
107 500 4
.
.
.
Currency Table
Crncy_id Crncy_nm
-------------------------
1 INR
2 USD
3 GBP
4 EUR
My local currency is INR, I need to write a query to convert the foreign currency to loacl currency INR.In my case i need to write aSQL for a view.It should not implement through PL/SQL
Reports & Discoverer :: How To Use System Parameter As Currency
Jun 8, 2010How the use the system parameter as currency, decimal and thousand.
View 2 Replies View RelatedApplication Express :: Currency Format For List Item Values
Sep 18, 2012How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.
View 2 Replies View RelatedSQL & PL/SQL :: Escape Operator Symbol?
Feb 28, 20111) 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
SQL & PL/SQL :: Join In A Query Which Has (+) Symbol At End
Oct 26, 2011I have come across a join in a query which has the (+) symbol at the end of it.
View 3 Replies View RelatedSQL & PL/SQL :: Encountered The Symbol End-of-file?
May 27, 2011i 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_
How To Get The Column Data Consist Of % Symbol
Mar 15, 2009I 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).
SQL & PL/SQL :: Trimming Euro Symbol In Given String
Nov 23, 2012I 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€)")
SQL & PL/SQL :: PLS-00103 - Encountered Symbol NUMBER
Jun 7, 2011I 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]....
PLS-00103 / Encountered The Symbol (end-of-file)
May 18, 2010when 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
JVM :: Ncomp Cannot Find Symbol TransitiveClosureDumper
Aug 22, 2012I'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.
PLS-00103 / Encountered Symbol NUMBER When Expecting One Of Following
Jun 7, 2011I 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.
Forms :: How To Display Password In Symbol Style
Dec 14, 2011i 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 RelatedForms :: How To Validate Alphanumeric And Symbol In Textbox
Nov 12, 2012I 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 RelatedClient 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.
Reports & Discoverer :: How To Put New Indian Rupees Symbol
Sep 13, 2011I 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]...
Client Tools :: Print Temperature Along With Its Symbol?
May 23, 2012I 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 RelatedSQL & PL/SQL :: TRIM Function - Remove Symbol Only From LEFT Or RIGHT Side
Feb 22, 2011Is 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;
Client Tools :: To See Euro Symbol In PL/SQL Developer On Windows 7
Nov 22, 2012When 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.
Reports & Discoverer :: Rupees Symbol On Linux Environment In 6i
Nov 30, 2011I 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.
Reports & Discoverer :: How To Print Copyright Symbol In Rdf Report
Jul 17, 2012how to print copyright symbol in rdf reports. I receive a ? when it gets printed.
View 3 Replies View RelatedReports & Discoverer :: Recover From Hour Glass Symbol
Mar 21, 2011I 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.
Precompilers, OCI & OCCI :: Unsatisfied Code Symbol (dladdr) In Load Module?
Jul 15, 2008Recently, 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?
Server Utilities :: Insert Data Without Writing Insert Statement In Oracle?
May 15, 2010how to insert data in oracle table without writing insert statement in oracle 9i or above. i am not going to write insert all, merge, sqlloder and import data.
View 2 Replies View Related