Forms :: Individual Tab Page Bar Color?
Aug 12, 2011Can i set individual tab page bar color?
Like the attached screenshot..
ADVERTISEMENT
Forms :: Tab Page Text Color In Oracle Form?
Jul 19, 2013i have the two tab pages in canvase...one is for the personal page and other one is the education. now i want to change the color of the text like personal and education.
i want only change the text color of label not the background color...
Forms :: How To Change Color Of Text
Mar 13, 2012i want to change the text background color as red ex: if desc is the field in the forms and when i type the word china in that field then that china backgroud color should change when i move to next item to red for that record alone..in the key_next_item trigger i wrote this
set_item_property('desc' backgroud_colour,'RED');
IS THIS RIGHT only that particular record should change
Forms :: Change Color Of Canvas
Aug 30, 2012I have a problem while changing in a form canvas color
i make some modification in a form. The layout color of the canvas is blue. i want to change the layout color of it to default (<unspecified>) (which is the default color).
when i change in the property pallet the background color to <unspecified>. it give me that error FRM-12305 color by this name doesn't exist and i want it the default color.
how can i do it without recreating the form from the beginning.
Forms :: Text Box Background Color?
Nov 24, 2011How can i change my text box into a transparent background?Any color code for it? I'm using Form 6i
View 5 Replies View RelatedForms :: Drop Down List Color
Mar 3, 2010I want to display may drop down list on different colors. Let's say I have 3 choices on list,
I want choice 1 to have a blue background, red for choice 2 and green for choice 3.
Forms :: Highlight Field Value With Blue Color
Jun 25, 2011My requirement is, when ever cursor entered into a field, the value of the field will highlight with Blue color and text color will be white, if field is not empty. It the feature of oracle application.
View 5 Replies View RelatedForms :: Change Color Of Canvas To Default
Apr 12, 2010The Background colour of the canvas is "gray" i want to change it to default.
View 4 Replies View RelatedForms :: Change Background Color At Runtime
Nov 25, 2010I have a text item in the control block and I want to change the background color at runtime..I used set_item_property but it doesn't working.I used WHEN-MOUSE-MOVE TRIGGER at the field level and the code.
is
SET_ITEM_PROPERTY(':master_blk.department', FOREGROUND_COLOR, 'VISUAL');
'VISUAL' is the visual attribute name and before making the visual attribute I used
SET_ITEM_PROPERTY(':CONTROL.CREATE', FOREGROUND_COLOR, 'red');
but it was also not working..
Forms :: Changing Button Color At Runtime?
Jan 21, 2012i want to change the button color in the runtime. is it possible by using set_item_property. if not, can we set by using property palette at design time.
i tried by setting the property in both ways but it's not working.
Forms :: List Item Background Color?
Nov 25, 2010In the attachement, i have one record. if i click on the list_item then it is showing fully blue as background colour, but i want like if i click on the list item then only current value background should show as blue rest of the values white in background colour.
View 1 Replies View RelatedForms :: Change Color Of Text Item Using Timers
Feb 23, 2010How can I change the color of a text item in Oracle forms using timer for every 500 milliseconds? The text must appear to be blinking.
View 3 Replies View RelatedForms :: Change Color Of Active / Inactive Tab Canvas
Apr 19, 2010how can we change the color of active & inactive Tab canvas dynamically. I am using Dev Suite 10gR2
View 2 Replies View RelatedForms :: Changing Background Color Back To Default
Sep 17, 2010I created a tab canvas and changed the background color of one of the tabs. Now I am unable to change it back to the default color.
I tried entering "None" in the Background Color property and even tried keeping the field blank. But it keeps on prompting me to enter a color value. Now it is looking funny with all the tabs in the default color and only one tab in some different color.
How do I get back the default color?
Forms :: How To Extract Selected Color From ColorPicker Bean
Mar 31, 2010How to extract the selected color from the ColorPicker bean. I managed to display the ColorPicker bean but i am not able to retrive the color.
How to set the selected color from ColorPicker as background of the form.
Forms :: Fetching Background Color Of Text Field?
Jul 29, 2013i want to fetch the background color of my text field
i am using
Get_Item_Property('TEXT1',BACKGROUND_COLOR)='r0g127b127
is this valid? if yes then its not working here.
Forms :: Customize Font Color Of Only Selected Nodes In Hierarchical Tree?
Mar 11, 2010how to customize the font color of only selected nodes in a hierarchical tree.
View 5 Replies View RelatedForms :: Change Color In Fields In Form Filled Via Data Block?
Jan 4, 2012I'm trying to change the attributes on a display where the info is gathered via a routine that fills the data block with info. I've searched and tried using 'set item instance property' in several places within the data block using different triggers but still doesn't work.
No errors are encountered or shown. Attributes aren't changed based on a small test condition.
SQL & PL/SQL :: Sequence Into Individual Records
Feb 23, 2010create table x (
field1 varchar2(10) );
insert into x values ('001-002');
insert into x value ('0150-0152');
insert into x value ('0100-0101');
create table y (
field varchar2(6));
recortd in table y
001
002
0150
0151
0152
0100
0101
Forms :: Can't Move From Canvas To Canvas To Change Its Color
May 11, 2011I have Table that save a color (specific color) , i want to change this color for all forms included windows and canvases at Runtime (by Code) .
My problem is : i can't move from canvas to canvas to change its color ( name of canvas ) - no next canvas code - like next block?
Insert Separated Data As Individual Rows
Sep 3, 2008I have a table with three columns X, Y and Z.The data in Column z is of the type 20/1425SE, 13/1235NW.Is there a way to split the data entries where Z LIKE '%/% and insert them as two separate rows.
I don't want to have any entries with '/'. Can these be deleted along with splitting the data entries?
SQL & PL/SQL :: Finding Individual Dates Having Date Plus 2 Days
Jan 26, 2011I want to find the dates which have a date plus with in 2 days after this date. I mean group by 3 days each even the date i missing between two days. Actualy I want to find the start date where the employ was missing on job.
Basic concept is employes have allowed to use 10 personal leaves of a year. Each leave can be use for maximum 3 days.
If employ did not come on the job for one day or two days or three days, it shoul be count as ONE personal leave. And If employ is missing at job for four or five days, it should be count as 2 personal leaves.
seq date
------------------------------
101.01.10
205.01.10
306.01.10
410.01.10
512.01.10
613.01.10
714.01.10
815.01.10
916.01.10
1018.01.10
1119.01.10
[Code]...
The result should be (Don't use Pl/Sql)
seq date
------------------------------
101.01.10
205.01.10
310.01.10
413.01.10
516.01.10
619.01.10
723.01.10
826.01.10
929.01.10
After finding these days I want to select the starting date of 5th personal leave. (which is 16.01.10).
I am not a expert of using SQL, but I think it could be possible with using partitioning a table on the givin reslult and further partition the reslut on rownum() as rn and the using case statement where rn = 5.
SQL & PL/SQL :: Access Individual Item From A Table Of Type ROWTYPE
Jun 1, 2010Script for test:
CREATE TABLE TEST(empno VARCHAR2(4), empname VARCHAR2(50), empstd NUMBER(2))
insert into test values(0001,'A',2);
insert into test values(0002,'B',5);
insert into test values(0003,'C',2);
insert into test values(0004,'D',7);
insert into test values(0005,'E',9);
Now I want to get empno for the particular employees based upon subscript and I have written below
DECLARE
CURSOR cur_rec
IS
SELECT *
FROM TEST;
TYPE cur_type IS TABLE OF cur_rec%ROWTYPE;
v_cur_rec cur_type;
BEGIN
OPEN cur_rec;
FETCH cur_rec
BULK COLLECT INTO v_cur_rec;
[code]....
how to access individial item froma table of rowtype data.
CM: Added [code] tags, please do so yourself next time, see the orafaq forum.
SQL & PL/SQL :: Distinct And Individual Records In Single Or Minimum Pass(es)
Feb 21, 2012I have following data
select rowid,object_name,object_type from do;
ROWID OBJECT_NAME OBJECT_TYPE
------------------ ------------------------------ ------------------
AAA/wuAAHAAAW73AAA CON$ TABLE
AAA/wuAAHAAAW73AAB I_COL2 INDEX
AAA/wuAAHAAAW73AAC I_USER# INDEX
AAA/wuAAHAAAW73AAD C_TS# CLUSTER
AAA/wuAAHAAAW73AAE I_OBJ# INDEX
AAA/wuAAHAAAW73AAF I_CON2 INDEX
6 rows selected.
I want it in the following manner
select rowid,object_name,object_type from do;
ROWID OBJECT_NAME OBJECT_TYPEGROUP
------------------ ------------------------------ ---------------------------
AAA/wuAAHAAAW73AAA CON$ TABLE2
AAA/wuAAHAAAW73AAB I_COL2 INDEX1
AAA/wuAAHAAAW73AAC I_USER# INDEX1
AAA/wuAAHAAAW73AAD C_TS# CLUSTER1
AAA/wuAAHAAAW73AAE I_OBJ# INDEX1
AAA/wuAAHAAAW73AAF I_CON2 INDEX1
6 rows selected.
Here the GROUP is changing when the data type is changing and thus for same data type the group shall remain the same As of now this is achieved by - first selecting distinct object_type, then it's mod(rownum,<input variable) and this result of 'mod' is doing the grouping which is the retrieved along with rowid of all individual record
Present query is as following and it is not much efficient
SELECT DO.ROWID RWID, RID
FROM DO,
(
SELECT OT,CASE MOD(ROWNUM,:v) WHEN 0 THEN :v ELSE MOD(ROWNUM,:v) end as RID
FROM(
(SELECT DISTINCT OBJECT_TYPE OT
[code]....
I tried using sequence with cycle but it gave different results. Even I tried following but it did not gave satisfactory results
select d.rowid,d.object_type,x.x1 from do d,(select distinct object_type,mod(rownum,:v) x1 from do where
created>'01-jan-2008')x where d.object_type=x.object_type and created>'01-jan-2008';
In short the query needs Distinct with mod(rownum) and individual records in a single pass The mod(rownum) i.e. group shall change when the object_type changes but then shall remain constant through out the particular object_type.
Server Administration :: Listener Shutdown For Individual Instances
May 17, 2013I am upgrading a DB using catupgrd.sql, and one of the prerequisites is to shut down the listener. Now, I have multiple database instances registered with this listener, and I don't want the other ones to become unavailable while I do the upgrade. Is there any way to do this for a particular instance only?
View 9 Replies View RelatedServer Administration :: How To Find The Size Of Individual Folder In ASM 10g
Mar 16, 2012Would like to know, how to find the size of individual folder in ASM 10g !
Also I am not able to find the PATH/name of the raw devices in ASM 10g !
SQL & PL/SQL :: Write Outer Query Which Will Bring Individual Records Which Don't Sum Up To Zero
May 9, 2011I have to write a sub query / build a logic for the below.
There are several accounts which should have a zero balance i.e sum of all the amoutns in that account should be zero. If they are non zero , i have to report which amounts make up non zero balance.
If i have amts as +20 , -20 , -30,-10 i.e the sum is -40 indicating a non zero amount. I need the entire details of the records which makes up non zero sum. So in above case details related to -30 aand -10.
I'm using a sum group clause on several fields at which sum is required to be checked ie. date , account , currency . query that will bring individual records that don't make the sum zero.
Is it possible to write a outer query which will bring individual records which don't sum up to zero.
How To Calculate Individual Sums Of Multiple Columns In Single Query
May 13, 2013Using Oracle 11gR2 on windows 7 client. I have a question on calculating sum() on multiple columns on different columns and store the results in a view. Unfortunately I could not post the problem here as it keeps on giving error "Sorry, this content is not allowed", without telling where or what it is! So I had to post it in the stack-overflow forum, here is the link: [URL] .........
View 6 Replies View RelatedApplication Express :: Can Open Page 306 As Modal Window But Page Closes Immediately
Nov 13, 2012i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page
Jun 4, 2013We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
