08-15-2001
no i don't have linux installed in me, what i have is a compaq presario 1200 notebook in which windows 98 is currently installed. i only starting to get a hang on unix at work and someday would like to familiarize with sqlplus. it will be good to my competency at the same time self-fulfilling in my part
please help...
thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
2. Shell Programming and Scripting
I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to... (4 Replies)
Discussion started by: aya_r
4 Replies
3. Shell Programming and Scripting
How to execute a query which is stored in a variable.
Say for example :
v_source_query=”select count(*) from emp”
v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF | tr '\n' ' '
set feed off
set pagesize 0
set head... (12 Replies)
Discussion started by: trupti_d
12 Replies
4. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
5. Programming
Hi,
I am trying to execute the update statment in shell sqlplus.But nothing prompts.if i do ctrl+c i got the below error.
SQL> update table set enabled='N' where type_code='xx';
^C update table set enabled='N' where type_code='xx'
*
ERROR at line 1:
ORA-01013: user requested... (2 Replies)
Discussion started by: nmahendran
2 Replies
6. Shell Programming and Scripting
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies
7. Shell Programming and Scripting
I have shell script which will try to login to SQL Plus and retrieve some data, based on the outcome i will proceed further
Below is the content of the file
pebblz02% cat test1.ksh
#! /bin/ksh
dummyvar=`sqlplus -S csm_admin/csm_admin@SIDNAME <<EOF echo hi; exit; EOF`
Error message on... (0 Replies)
Discussion started by: kiranlalka
0 Replies
8. Shell Programming and Scripting
Hi
When I use sqlplus in shell script, I get sqlplus: command not found.
ORACLE_HOME is not set. How to set ORACLE_HOME in unix?
Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies
9. Shell Programming and Scripting
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
Discussion started by: big123456
1 Replies
10. Shell Programming and Scripting
friends because when calling a sqlplus from a shell it brings me the following message
sqlplus -s $BDDUSER/$BDDPASS@$BDDHOST @$DIR_SQL/prueba.sql
echo "bandera 3 " $?
STATUS=$?
if ;then
echo "bandera 4 " $?
#log_info "La ejecucion de... (1 Reply)
Discussion started by: tricampeon81
1 Replies
LEARN ABOUT HPUX
xinstallcolormap
XInstallColormap() XInstallColormap()
Name
XInstallColormap - install a colormap.
Synopsis
XInstallColormap(display, colormap_return)
Display *display;
Colormap colormap_return;
Arguments
display Specifies a connection to an X server; returned from XOpenDisplay().
colormap_return
Specifies the colormap to install.
Description
XInstallColormap() installs a virtual colormap into a hardware colormap. If there is only one hardware colormap, XInstallColormap() loads
a virtual colormap into the hardware colormap. All windows associated with this colormap immediately display with their chosen colors.
Other windows associated with the old colormap will display with false colors. If additional hardware colormaps are possible, XInstallCol-
ormap() loads the new hardware map and keeps the existing ones. Other windows will then remain in their true colors unless the limit for
colormaps has been reached. If the maximum number of allowed hardware colormaps is already installed, an old colormap is swapped out. The
MinCmapsOfScreen(screen) and MaxCmapsOfScreen(screen) macros can be used to determine how many hardware colormaps are supported.
If colormap_return is not already an installed map, a ColormapNotify event is generated on every window having colormap_return as an
attribute. If a colormap is uninstalled as a result of the install, a ColormapNotify event is generated on every window having that col-
ormap as an attribute.
Colormaps are usually installed and uninstalled by the window manager, not by clients. At any time, there is a subset of the installed
colormaps, viewed as an ordered list, called the "required list." The length of the required list is at most the min_maps specified for
each screen in the Display structure. When a colormap is installed with XInstallColormap() it is added to the head of the required list
and the last colormap in the list is removed if necessary to keep the length of the list at min_maps. When a colormap is uninstalled with
XUninstallColormap() and it is in the required list, it is removed from the list. No other actions by the server or the client change the
required list. It is important to realize that on all but high-performance workstations, min_maps is likely to be 1. If the hardware col-
ormap is immutable, and therefore installing any colormap is impossible, XInstallColormap() will work but not do anything.
For more information, see Volume One, Chapter 7, Color.
Errors
BadColor Invalid colormap.
See Also
XDefaultColormap(), XDisplayCells(), XCopyColormapAndFree(), XCreateColormap(), XFreeColormap(), XGetStandardColormap(), XListInstalledCol-
ormaps(), XSetStandardColormap(), XSetWindowColormap(), XUninstallColormap().
Xlib - Colormaps XInstallColormap()