Forms :: 6i Displaying Oracle Only Negative Sign
Nov 12, 2012
can you to display a field with negative value
S -- format mask display both sing + and -
MI -- format mask display negative sign at end
PR --Returns negative value in <angle brackets>. and Returns positive value with a leading and trailing blank.
I want the output should display only leading negative if the value is negative. I have used S99990.99 as format Mask. but need output should display only leading negative if the value is negative.
View 1 Replies
ADVERTISEMENT
Jul 15, 2011
I found the data in DB with negative time as below
Quote:
1 SELECT
2 c.time
3 FROM partition c
4 WHERE
5* c.time < to_date('0001-01-01','YYYY-MM-DD')
SQL> /
DEACTIVATION_TIME
------------------------------------------------------------------------
17-JUN-08 04.06.22.893 PM
The data type for c.time is Timestamp.
When I use JDBC to retrieve the data and convert it to mill seconds, and it also shows as negative time. My question is the retrieved time doesn't show the negative date, but obvious it is a BC date and earlier than 0001-01-01.
1. How can we detect/show the date to show correctly for the BC date without checking c.time < to_date('0001-01-01','YYYY-MM-DD')? (I am wondering if there is format configuration to show the time like 17-JUN-08 04.06.22.893 PM BC, or something to show the time is negative )
2.how could we fix it negative time to positive ?
View 6 Replies
View Related
Jan 4, 2013
how can i create and customize a sign in popup when running an oracle form?
View 1 Replies
View Related
Apr 24, 2009
i am working with image. I have successfully stored image in oracle table. Now i want to display the stored image in oracle form 6i. There i unable to display the image although i have created the data block using the same table name as the data source.
View 9 Replies
View Related
Oct 6, 2010
I have successfully Stored image file in Oracle 10g Database Table using Forms 6i. But I cannot retrieve that image and display on Forms 6i. Image Item on Form is not a database Item.
View 8 Replies
View Related
Jan 9, 2012
I am doing a Gross Profit percentage. I want to display zero if the GP% is have negative value.
for example
If GP% shows -75 I want to display as 0.
trunc((sum(total)-(sum(DECODE(po_pur,'',0,PO_PUR))+sum(DECODE(pl_pur,'',0,PL_PUR))+SUM(parts))) / SUM(DECODE(TOTAL,0,1,TOTAL))*100,2) "GP%"
View 2 Replies
View Related
Sep 15, 2009
1-i have exported a database 9i with character set WE8MSWIN1252 which is her original character set;
2- i have created a new database 10G R2 with character set AL32UTF8;
3- i have imported the .dmp file to this new database with imp.exe 9i version configured with WE8MSWIN1252 character set;
-The problem is:
* when i use sqlplus, arabic data displays correctly but, in forms 10G, arabic data displays lick this ?E?? EC???IEC...... HOW CAN I CONFIGURE FORMS TO DISPLAY CORRECTLY ARABIC DATA?
View 3 Replies
View Related
Jan 20, 2013
In my explorer/menu form there is a image item, I want to display company logo in this image item therefore I am using read_ image_ file ('c:application LOGO.jpg','JPG','IMAGE53') in WHEN_NEW_FORM_INSTANCE trigger but image isn't showing.
View 3 Replies
View Related
Oct 17, 2004
I have problem in displaying icons in the push button during run time. Actually from few days i m trying to display icons at run time but with out any success.
i had made a simple push button and in its properties i had made the following changes
iconic=yes
icon filename=c:tempsave
the file save.GIF is saved under c:temp directory.
i had tried all the changes in registry.dat,orion file through the doc 203846.1 from metalink. Give me sample code step to step for showing a
push button with icon during run time. Also I tried the steps mentioned in the pdf document of
[URL].....
But it did not solve my problem. My icon file name is save.GIF , I wanted to know whether save.GIF file name convention is valid or not. Give the path from where I can get the icons used for web.
View 4 Replies
View Related
Feb 14, 2012
i got an error running my form. And when i re-run it again, the message at the bottom was nowhere to be found. How can i bring it back?
View 3 Replies
View Related
Aug 2, 2010
I want to display time in reverse count down using oracle forms 10g.
View 3 Replies
View Related
Apr 28, 2011
I have one column table with negative and positive values and want to display positive and negative values in different columns thru a single query.
Column
1
-4
3
-6
output should be like
A B
1 -4
3 -6
View 14 Replies
View Related
Apr 24, 2012
I am currently working on a Data Dictionary project where we need to run a few rules against the give data sources to see if they all comply together.
One of the rule is to check if the no. is negative or not. So for that what I tried to do was to check if first the field is number or not and then check on if it is negative or not.
This is the code I am currently trying on and is not looking good.
SELECT 1 FROM DUAL
WHERE decode(DECODE( TRANSLATE('-123.45','-0.123456789',''), NULL, 1,0), 1,substr('-123.45',1,1) ,' ' ) = '-'
View 13 Replies
View Related
Oct 8, 2010
I have created a form in which I have 2 canvases - content canvas and a tabbed canvas.
I have only 4 fields on the content canvas and the remaining on the tabbed canvas. My requirement is such that the tabbed canvas should appear below the content canvas when I run the form, i.e. the fields on the content canvas will be visible, and below them will be the tabbed canvas.
For the content canvas, I have set the viewportX and viewport Y position as (0,0), and for the tabbed canvas, I have set the viewportX and viewportY position as (0,100). However when I run the form, I only see the tabbed canvas and the area at the top where I should see the contents from the content canvas appear blank.
View 2 Replies
View Related
Sep 27, 2007
I have 3 canvases ---> X ( Content), Y ( Stack) and Z ( Stack) which has 3 blocks BX, BY, BZ resp.
WHEN-NEW-BLOCK-INSTANCE trigger of BX :
execute_query;
show_view('Y') ;
Now X and Y both canvases are displayed.
[code]....
Now only X is displayed. Canvas Y is vanished after a single blink. But I require both canvases as in initial stage.
View 5 Replies
View Related
Dec 15, 2010
I am working on a script that is reading from a numeric column converting it to a character string where the decimal is dropped (assumed) and the value is padded with leading zeros to fill the specified lengh. Using to_char(payment_amt,'FM0000000V00') is working fine for non-negative values. When the value of the field is a negative number the output includes a leading - (i.e., -000002458).
For the negative numbers I need to convert them to a 'Signed EBCDIC' value, where the last digit is converted to a specified character (in the above example it would be changing the 8 to a Q) and also replace the - with a zero, resulting in 00000245Q.
What I am doing is generating a fixed-length record with values in a specific location. What I'm getting now looks like this:
AAAA 000002358 BBBBBBB
CCCC -000002458 DDDDDDD
EEEE 000024555 FFFFFFF
And what I need it to look like is:
AAAA 000002358 BBBBBBB
CCCC 00000245Q DDDDDDD
EEEE 000024555 FFFFFFF
View 1 Replies
View Related
Jul 8, 2012
In form i call a record from database table through execute_query. i have lov on ITEM_NO
i want to display on that form, no. of records of ITEM_NO which i select from the list. like if i have 10 records with item_no which i select from list is must show 1/10.
if i press the down arrow it should show next record of the same item_no.
View 5 Replies
View Related
Apr 24, 2010
i want displaying the query data page wise.
i want place 4 buttons
1 for 1st page, 2nd for next page, 3rd nxt page and 4th for last page.
how can i do this through programming in oracle forms 10g.
give me the entire process of doing this.
i am waiting for your response.
View 9 Replies
View Related
Apr 23, 2011
I want to display a pdf file (or other types of documents like word or excel) that is already stored in a blob column in the database, in a form control and be able to view the records one by one just like an image.
Is this possible? if so, how? If not, can you direct me to additional code, technology, package or whatever solution that can achieve the desired results. sing Oracle forms 6i and database 10g.
View 1 Replies
View Related
Jul 25, 2012
on clicking select.show,while running the form data(DATE and APPLICANT_NO) is being accesed from local database but after uploading the form the data is not coming from main database,even if the data is present in the main database.
View 1 Replies
View Related
Jul 9, 2013
RE: Partial install of SSO leaves orphaned instances.
Background: Lost connection to Linux system while attempting SSO install. During reinstall installer states instance name already in use - suggests using different name.
Using deconfig.pl tool (user: cn=orcladmin) to remove SSO configuration, but error encountered. Reason: incorrect SYS password. Note: Can access db using SYS password with no problem.
Question: Does deconfig.pl completely remove SSO configuration? If not, what other steps are required to completely remove SSO?
View 1 Replies
View Related
Jan 24, 2012
I have following table: tab1
id configured_size current_size percentage
1 500 100 20
2 300 100 33
... ... ...
When I launch select * from tab1 I get :
id configured_size current_size percentage
1 500 100 20
2 300 100 33
... ... ...
My question is is there any way how to edit the abovementioned select to get something like :
id configured_size current_size percentage
java_eml 500 100 20%
java_hdl 300 100 33%
... ... ...
I want to append two things:
sign of % in row percentage
when id =1 then in output have java_eml
when id =2 then in output have java_hdl
The problem is I cant update the table (not sufficient rights) so is there any way how to adapt that output?
View 7 Replies
View Related
Feb 22, 2013
The below query is taken from the procedure
SELECT l_stafnum = stafnum,
category,
duty,
date,
signon,
signoff,
l_rest = rest,
valid,
FROM SESSION.valid_pf
WHERE invalid != 'I'
In the above query has set of data which each staff may have more than one duty.
For example
stafnum categoy duty date signon signoff rest valid
232 M a/c 2/3/12 5:00 8:00 12:00 I
232 M Sup 2/3/12 10:00 13:00 8:00 I
111 M Clen 2/3/12 9:00 12:00 12:00 I
232 M Sw 2/3/12 15:00 20:00 12:00 I
111 M Wp 2/3/12 10:00 14:00 06:00 I
121 M a/c 2/3/12 5:00 8:00 12:00 I
The select query will retrieve the value which mentioned this example.Now, First I need to take how many duty has been allocated for each stafnumber.
232 staff allocated to three duty (a/c,sup,sw) Then need to compare signoff value for first row addition of rest value for the same row i.e, i = 08:00+1200
Then need to compare value of signon for the same staff 232 for the second row which is 10:00 if (i>10:00) then valid;
how I can take same staff number and find it how many duty the staff has.And how to take sign off and rest field value of first row, for the same staff then compare those value with the same staff number second row signon value.
View 7 Replies
View Related
May 6, 2010
i am doing a data transformation using the following function
FLOOR(ONSET_TPQ-VAX_DATE)
Where ONSET_TPQ and VAX_DATE are both dates. Now in a situation where the ONSET_TPQ precedes VAX_DATE I want the result to be null for those records. As an example if ONSET_TPQ= 2000 and VAX_DATE=2010
I want the result to be NULL as I dont want negative values. Any exact SQl syntax on how to do that. DO i write a case statement?
View 6 Replies
View Related
Jul 25, 2011
I have 2 blocks, block 1 which is the master and block 2 which is the detail. Both block 1 and block 2 are multi record blocks. For my form I want to display a warning message to the user if they create a master block without also creating a detail.
View 2 Replies
View Related
Feb 12, 2012
I want to ask what's wrong with my multi-record block.
When i click a node on my tree, it should display the records on it. For example, my root node is Sections, the parents are 1st sem and 2nd sem. In each sections in 1st sem, whenever i click a child node, it should display on display items. I have set its number of items displayed to 9. Since each sections have 9 subjects. The problem when i run it is that it displays many rows.
View 35 Replies
View Related
Feb 14, 2012
I have for example two text items(number of records to display is set to 9). What I want is when i go to studentprofile block, it should automatically shows his subjects that are already taken up. the first text item is for 1st semester subjects and the other for 2nd semester.
here is the structure of my subjsec table:
ID number(1)
subj_code varchar2(10)
day varchar2(10)
and for subjects table:
subj_code varchar2(10)
description varchar2(50)
units number(1)
semester varchar2(10)
I restricted subjects that are in 1st sem. So i did something like this in my
DECLARE
CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, g.subj_code, s.description, s.units, s.semester
FROM studgrades g , subjects s
WHERE g.subj_code = s.subj_code
AND g.stud_id = :Studentprofile.student_id;
[Code]....
View 32 Replies
View Related
Jan 17, 2012
I have two values:
'AA:10%:1'
'AC:P35:20%'
I need to extract the numerical value preceding the '%' sign. for first row 10 should be extracted and for the second 20.
View 2 Replies
View Related
Jun 5, 2012
searched here for Tick Sign in Reports & Discoverer section, but did not find. i am trying to work on Reports and have a requirement of Tick Sign should appear in report if the column value is 'Y' means yes.
i tried following SQL statement in SQL*Plus, but failed to find and Tick Sign.
declare
n number:=0;
c varchar2(1);
begin
for i in 1..255
loop
select chr(i)
into c
from dual;
dbms_output.put_line ('* '||lpad(to_char(i),3,' ')||' -> '||c);
end loop;
end;
View 3 Replies
View Related
Jan 29, 2012
We need to display a pdf file in the email generated through the oracle database procedure.
We created a blob object to store the pdf file and it is working fine then we created a package to read the file and display it but when i am running the procedure from the sqlplus prompt the following message is appearing
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.OWA_UTIL", line 377
ORA-06512: at "WHADMIN.IMAGE_GET", line 14
ORA-06512: at line 1
i am copying the procedure and package that i created for the same
create table demo
( id int primary key,
theBlob blob
)
declare
l_blob blob;
l_bfile bfile;
[code]....
when i am running image_get.pdf(1) from sqlplus prompt following error message is displayed on the screen
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.OWA_UTIL", line 377
ORA-06512: at "WHADMIN.IMAGE_GET", line 14
ORA-06512: at line 1
View 4 Replies
View Related
