04-19-2010
Quote:
Originally Posted by
tapia
...
alias sett='export ORACLE_SID=devdb2;sqlplus system/system@test'
now this command make me reach upto only into sqlplus
i want to set the prompt of sqlplus also ...
any suggestion please ....
Here's a suggestion - set the sqlprompt in your glogin.sql or login.sql file.
And retain this alias.
That way your sqlplus program will pick up the value of sqlprompt automatically.
tyler_durden
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want to create a command alias. I know what shell I'm
using, I just don't know which file to inter the command alias.
When I type "echo $SHELL" the output is as follows:
bin/sh
If I'm correct, this is the bourne shell. Does anyone know which file to edit in this particular shell? Thanks. (2 Replies)
Discussion started by: cstovall
2 Replies
2. UNIX for Advanced & Expert Users
Hi,
i want to make alias for rm command. It should actually move the file to a directory in my home.
Say if i type
%rm abc.txt
the command should expand to
%mv abc.txt ~ashishp/trash
How should I write the alias for this?
-Ashish (8 Replies)
Discussion started by: shriashishpatil
8 Replies
3. UNIX for Advanced & Expert Users
Hi
'm executing a java program from my shell script on solaris 9 as
$JAVA_HOME\bin\java -ms32m -mx128m -classpath $CLASSPATH com.abc.fwk,abcServer.abcfwkServer $1 &
where $1 is port number
when i do ps -ef, it shows whole command , i want to give this some alias name as abcProcess, so... (2 Replies)
Discussion started by: b_garima
2 Replies
4. Shell Programming and Scripting
how do I alias the following command:
ls -l |egrep 'drw|dr-|d--|d-w'
The alias command needs single quotes and so does the above command, so this does not work:
alias LSDIR 'ls -l |egrep 'drw|dr-|d--|d-w' '
My problem is how do I get a listing of only directories?
Solaris 8
SUN Ultra 10... (4 Replies)
Discussion started by: ajp7701
4 Replies
5. UNIX for Dummies Questions & Answers
Please could someone advise me the command - to set up aliases commands within a .profile using shell sh
regards
venhart (13 Replies)
Discussion started by: venhart
13 Replies
6. Linux
Hi I have a serious issue when trying to join to files
so I have two files, one for meals and one for people
Meal1:Turkey:Potato Chips:Twinkie:Coke:5.95
Meal2:Ham & Cheese:Doritos:Cookie:Sprite:6.49
Meal3:Vegetarian:Cheese Crackers:Brownie:Pepsi:5.75
Meal4:Tuna:Cheese Puffs:Eclair:Diet... (1 Reply)
Discussion started by: ehshi1992
1 Replies
7. Shell Programming and Scripting
I'm trying to set up an alias in .bash_aliases to show just the filenames of the files in a directory, which the following command will do:
ls -l | grep ^- | awk '{print $NF}'
kjb.zip
ap.zip
tor.zip
However when I set up the following alias in .bash_aliases:
alias lf="ls -l | grep ^- |... (16 Replies)
Discussion started by: gencon
16 Replies
8. Shell Programming and Scripting
Hi all,
In a directory, I have many video files. Example :
As you can see, some of the video files come with a .aspx file (wich
means the video is actually being uploaded and not entirely written on
the FS)
I try to write a bash script that would find all video files in the
... (1 Reply)
Discussion started by: gniagnia
1 Replies
9. UNIX for Dummies Questions & Answers
Hi Friends,
I have added some aliases in .bash_profile file under the root folder. Its works fine and very useful, but does not go well with cp command.
alias deploy="cd /usr/local/tomcat/webapp"
alias artifacts="cd /usr/local/artifacts"
but when i try to cp from artifacts folder... (2 Replies)
Discussion started by: prashdeep
2 Replies
10. Shell Programming and Scripting
Hello,
I'm attempting to configure shell settings in my new Macbook. The standard unix command line 'alias' doesn't seem to be working:
bash-3.2$ alias dir ls -la
bash: alias: dir: not found
bash: alias: ls: not found
bash: alias: -la: not found
bash-3.2$ alias dir 'ls -la'
bash:... (1 Reply)
Discussion started by: palex
1 Replies
LEARN ABOUT SUSE
apache::session::store::oracle
Session::Store::Oracle(3) User Contributed Perl Documentation Session::Store::Oracle(3)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.12.1 2007-09-28 Session::Store::Oracle(3)