Client Tools :: Change Background And Foreground Color Of Sql*plus?

Nov 9, 2010

how to change background and foreground color of sql*plus.

View 2 Replies


ADVERTISEMENT

Forms :: Change Background Color At Runtime

Nov 25, 2010

I 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..

View 6 Replies View Related

Client Tools :: Run A Query In Background In Toad Or Sqlplus

Feb 3, 2011

i do have a set of monthly process, where i need to run query one after the other. Some query will take one hours time to complete but some will take 10 hours or more to execute. My problem is that we have wait or machine shouldn't hang or log off during that time ...

I am executing the query in TOAD and windows SQL*Plus. Query can run Parallel at a time.

Is the there anyway to run the query in the background like what we do in the unix nohup command in toad?

View 11 Replies View Related

Forms :: Text Box Background Color?

Nov 24, 2011

How can i change my text box into a transparent background?Any color code for it? I'm using Form 6i

View 5 Replies View Related

Forms :: List Item Background Color?

Nov 25, 2010

In 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 Related

Forms :: Changing Background Color Back To Default

Sep 17, 2010

I 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?

View 5 Replies View Related

Forms :: Fetching Background Color Of Text Field?

Jul 29, 2013

i 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.

View 1 Replies View Related

Application Express :: Changing Background Color Of A Cell From APEX_ITEM?

Apr 30, 2013

I created a javascript to change background color upon double click on particular cell, and it works for normal tabular form.However I created another tabular form using APEX_ITEM and unable to replicate the same behaviour.. how to do that if I'm using APEX_ITEM?

View 2 Replies View Related

Client Tools :: How To Disable Shortcut Or Change Key Mapping

Feb 18, 2008

I have a problem with getting '|' sign in TOAD Editor. It is default for Croatian keyboard layout that I get '|' sign when I press Alt_gr+W key combination.

But in Toad, when I press Alt_gr+W combination Watches dialog is opened.I want to get '|' sign in Toad Editor when I press Alt_gr+W.

View 9 Replies View Related

Client Tools :: Change Separator Line Of Compute SUM Or Count?

Jul 9, 2013

Is that possible to modify the ***** and ----- in the TEXT report?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
************* ********** ----------
sum 13000

From above lines, you can see ****** and ----- which are above sum&13000.

Is that possible to change them as '='?

DEPARTMENT_ID JOB_ID LAST_NAME SALARY
============= ========== ========================= ==========
20 MK_MAN Hartstein 13000
============= ========== ==========
sum 13000
"set underline =" is only shot the headers.

View 3 Replies View Related

Client Tools :: Force Parameter Value To Change Filename For Every Execution Of Sql Script

Jan 24, 2012

I wrote an sql script (spooler) which runs a select query and produces results into a file.

I want to have the filename with the year attached. Can i pass a parameter when i run the script from SQL*PLUS

@'B: Year Of FinancingPLSQLspoolersSpooler_File_Creation' 01/01/2010 2010;

the first parameter 01/01/2010 is passed to the select query and taht works fine.

Since the output file contains 2010 data, I want the spooled file to mention in its name the 2010, so User's can know the file contains 2010 data in it.

So i wrote the statement within the spooler script

SPOOL X:HARSOrganizationsFinancialDataFor&2.txt

&2 should take 2010 has its value and produce the file FinancialDataFor2010.txt

how to use Substitution variables to produce the Filename i want.

View 10 Replies View Related

Forms :: How To Change Background Image

Jan 28, 2010

I was confuse about oracle applet parameter form that's in formsweb.cfg at line

# Forms applet parameter
background=C:imagea.jpg

but when i run oracle form it's still not appear image that i want to appear with a.jpg . how to change background of oracle form.

View 5 Replies View Related

Forms :: How To Change Color Of Text

Mar 13, 2012

i 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

View 14 Replies View Related

Forms :: Change Color Of Canvas

Aug 30, 2012

I 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.

View 2 Replies View Related

Forms :: Change Background To Logo Message

Jun 30, 2010

I want to change the Background "Oracle Forms AS services" to one of our logo. I searched in formsweb.cfg and tried many parameters. I got succeeded in changing Title, forms background but not able to change the oracle logo message in the white background of html web page.

View 2 Replies View Related

Forms :: Change Color Of Canvas To Default

Apr 12, 2010

The Background colour of the canvas is "gray" i want to change it to default.

View 4 Replies View Related

Forms :: Change Color Of Text Item Using Timers

Feb 23, 2010

How 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 Related

Forms :: Change Color Of Active / Inactive Tab Canvas

Apr 19, 2010

how can we change the color of active & inactive Tab canvas dynamically. I am using Dev Suite 10gR2

View 2 Replies View Related

Forms :: Change Color In Fields In Form Filled Via Data Block?

Jan 4, 2012

I'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.

View 2 Replies View Related

Application Express :: Change Of Color On Tabbed Navigation List (Apex 4.1)?

Jun 21, 2012

I am using apex 4.1

I have a list on page 0 which is "Tabbed Navigation List" and there are three pages running on it.

I want to change the color of the button when i click on the specific button.

View 6 Replies View Related

Application Express :: Interactive Report / Change Text Color Based Upon Value In Another Column

Nov 12, 2013

I have a sample report at this url:

workspace: homeworldusername: test_reportpassword: test_report APEX version is 4.2.3, database 11g release 2... Application #: 202 : IR REPORTS TEST Page in question is page #2   

I have the report setup and need to make the following change... I have 2 columns: Comm and bonus,

if the bonus > comm, I need to change the text color of the bonus color to Red   if the bonus < comm

I need to change the text color of the bonus color to Green   if the bonus = comm, I need to change the text color of the bonus color to Black I have tried using code with the select and am NOT wanting that since it will be bundled with the data when downloaded as CSV or Excel.. Had thought about using the built in highlighting but that doesn't allow comparing a column to another.. Was thinking of a dynamic action, but not clear as to HOW to do it.

View 10 Replies View Related

Forms :: Can't Move From Canvas To Canvas To Change Its Color

May 11, 2011

I 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?

View 1 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

Client Tools :: Basic Tools For Oracle Version Control

Aug 26, 2011

I'm looking for 3 simple things.

1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.

2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).

3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.

View 9 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Client Tools :: BR*Tools Appearance Not Complete

Jan 16, 2013

I want to use BR*Tools to administer an Oracle database. I have installed BrGUI local, set the JAVA Home variable and edited the brgui.properties file accordingly.I am able to login, but the menues are mising. The login screen is incomplete.

View 5 Replies View Related







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