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
ADVERTISEMENT
Fix Number Of Digit After Decimal Point?
Mar 21, 2007I have a small prob. I want an amount to be always 2 decimal places. I've used the Round function - Round(amount,2). the problem is that if the amount is only to 1 dp like 1.4. the above function will return 1.4. I want it to appear like 1.40
View 2 Replies View RelatedPL/SQL :: Round Function Output Depend On 2nd Digit After Decimal Point
Oct 19, 2012I have a question on Round Function
Round(###.###,1)
Will the round function output depend on 2nd digit after decimal point also or not?
SQL & 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 :: 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.
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 :: 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 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?
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
$
Reports & Discoverer :: Symbol In Oracle Reports
Oct 29, 2011I 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.
PL/SQL :: Function That Returns The Check Digit Of 9-digit Number
Jan 17, 2013I would like a pl/sql function that returns the check digit of a 9-digit number?
Look at
[UR]......
For example number 109409714 (9 digits) should do check digit. I want validation of check digit, & want to return the check digit.
SQL & PL/SQL :: REGEXP Digit Extraction?
Oct 25, 2011I am trying to write a pattern that will return multiple numbers when it finds the string "My String" in a Text such as
Text String:
My String 5 Test Need a good regExp 34 to test multiple 12334 occurrences of the same 566 search string My String 3 hopefully this time My String 7 with three of these'
Expected Output:
5
3
7
I managed to write Regular expression that returns only for the first match as shown below.
select TO_NUMBER(REGEXP_SUBSTR(REGEXP_SUBSTR (vSearchText1, ('My String' d+')), 'd+'))
SQL & PL/SQL :: Function To Accept 4 Digit Number Which Should Not Be Repeated?
Aug 15, 2012i nee a function which accepts 4 digit number and in four digit number the number should not be repeated. i want all the number in the output.
ex:1234
2367
1262(is not valid)