12-12-2006
Some errors are coming
I tried that &&;
sqlplus -s -L $dbausername/$dbapwd $1 $password <<EOF
create user &&1 identified by &&2;
grant create session to &&1;
exit;
EOF[FONT=Courier New]
Still ,it's giving some errors...
Can someone help me??
Thanks
10 More Discussions You Might Find Interesting
1. Programming
I want to pass a variable set in my c program to a shell script (which will also be invoked or initiated from the same C program using the C's system command). Is it possible ?
:confused: (3 Replies)
Discussion started by: kapilv
3 Replies
2. UNIX for Advanced & Expert Users
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies
3. UNIX for Dummies Questions & Answers
Need to select count(*) from table to check for zero result in unix script (2 Replies)
Discussion started by: struggle
2 Replies
4. Shell Programming and Scripting
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Discussion started by: kripssmart
3 Replies
5. Shell Programming and Scripting
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Discussion started by: Anaramkris
5 Replies
6. UNIX for Dummies Questions & Answers
hi All,
i m trying to pass a user choice paramter from unix to sqlplus connect command
here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance.
sqlplus -s $1/$2
where $ 1 and $2 will b... (2 Replies)
Discussion started by: Jcpratap
2 Replies
7. Shell Programming and Scripting
Hi,
I ahve a unix code as below.
sqlTxt=$*
sqlReturn=`echo "set feedback off;
set heading off;
set term off;
set verify off;
set serveroutput on size unlimited
set lin 1000;
VARIABLE GV_return_val NUMBER;
VARIABLE GV_script_error varchar2(4000);
EXEC :GV_return_code := 0;
EXEC... (6 Replies)
Discussion started by: bhaski2012
6 Replies
8. Shell Programming and Scripting
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies
9. Shell Programming and Scripting
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Discussion started by: amvip
7 Replies
10. UNIX for Beginners Questions & Answers
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT DEBIAN
gchem3d
GCHEM3D(1) gnome-chemistry-utils GCHEM3D(1)
NAME
gchem3d - a small chemical viewer application
SYNOPSIS
gchem3d [OPTION(S)...] [FILE...]
DESCRIPTION
gchem3d is a small chemical viewer application, which can show several chemical file formats.
OPTIONS
The following options are accepted:
-b COLOR, --bgcolor=COLOR
Use the given color as background color. COLOR can be one of "black" (default), "white", "#rrggbb" (don't forget to escape the "#"
character in the shell).
-d MODEL, --display3d=MODEL
Choose how molecules are displayed. MODEL can be one of "BallnStick" (default), "SpaceFill".
-?, --help
Show application help options.
--help-all, --help-*
Print all or just a group of help options. These options are not documented here. Instead see gtk-options(7) and gnome-options(7).
-v, --version
Print gchem3d version information.
SEE ALSO
gnome-options(7), gtk-options(7)
AUTHORS
Jean Brefort <jean.brefort@normalesup.org>
Program author.
Daniel Leidert <daniel.leidert@wgdd.de>
Manpage author.
COPYRIGHT
Copyright (C) 2002-2007 Jean Brefort
Copyright (C) 2004-2007 Daniel Leidert
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any
later version published by the Free Software Foundation.
gcu 0.12 $Date: 2009-03-19 10:53:47 +0100 (jeu. 19 mars 2009) $ GCHEM3D(1)