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.
where $ 1 and $2 will b taken from user.
please help in implementing this
Moderator's Comments:
Please use next time code tags for your code and data
Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF
But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??
Thanks... (3 Replies)
Hi,
I am trying to replace a URL by another URL in the SED command e.g.
cat dir/filename1 | sed -e 's/"http:\/\/*dtd"/"http:\/\/abc.def.com\/xyz.dtd"/' > dir/newfile.xml
But I need to pass a parameter to the SED command which should have the new url string i.e.... (2 Replies)
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)
I have an Oracle concurrent program that I'm passing a parameter to a unix shell script. An example value of the Oracle parameter is PO_TOP. The Oracle parameter represents the unix env var PO_TOP, meaning, on the unix side there is env var called PO_TOP (ex value: /oradev/apps/po/11.0.3/). My... (7 Replies)
I have a bash script which utilizes a random function and then runs a file at now plus a random time.
The problem is, that the php file requires a parameter after it eg:
phpfile.php?code=123245b3
When i put in the file including the full path, with the at command, it will run, but not with... (1 Reply)
Hi,
I have a function which connects to the db and runs the sql.
it works fine when I run it like: function "select empname from emp;"
but when I try to pass the sql string to a variable which in turn in fed to the function , it throws error.
please advise.
Thanks,
Arnie. (1 Reply)
Hi,
I have a situation where I need to create a SQL statement using Unix script for each value in first field (ID). The file looks like this.
Id,TARGET_FIELD_NAME,SOURCE_FIELD_NAME
1,Test_Rate,Field1
1,Test_Factor,Field2
1,Test_Size,Field3
2,Test_Rate,Field4
2,Test_Factor,Field5... (3 Replies)
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
Hi All,
Just trying to implement the below shell script using AIX ksh shell.
myfunc {
eval "$*"
}
CMD='ls -la /etc/hosts | awk '{print $9"|"$5}''
myfunc $CMD
Keeping getting "|}: not found" errors, any pointers would greatly be appreciated.
Kind Regards
Ed
Please... (2 Replies)
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
LEARN ABOUT DEBIAN
mysql_import_combined_log2
mysql_import_combined_log.pl(1) General Commands Manual mysql_import_combined_log.pl(1)NAME
mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.
SYNOPSIS
mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]
OPTIONS
--host|-h <host name>
The host to connect to. Default is localhost.
--database|-d <database name>
The database to use. Required.
--username|-u <username>
The user to connect as.
--password|-p <password>
The user's password.
--table|-t <table name>
The name of the table in which to insert data.
--logfile|-f <file name>
The file to read from. If not given, data is read from stdin.
--help|-?
Print out this help message.
--version
Print out the version of this software.
AUTHOR
Aaron Jenson
Updated to work under Perl 5.6.1 by Edward Rudd
MAN PAGE CREATED BY
Michael A. Toth <lirul.lists@gmail.com> - based on content of script
COMMENTS
This man page was written using xml2man (1) by the same author.
Manuals User mysql_import_combined_log.pl(1)