I am having a sql script file which does below operations
Code:
ALTER TABLE M1
EXCHANGE PARTITION FOR (TO_DATE('&1','dd-MON-yyyy'))
WITH TABLE &2
INCLUDING INDEXES;
i need to pass variables in such a way that if i pass start date and end date as parameter , something like my start and end dates as 01-JAN-2015 - 04-JAN-2015, i need to call this .sql file
Code:
calling test.sql for 01-JAN-2015
Test.sql 01-JAN-2015 T1 #establish connection using connect user/user_name@db
completed for 01-JAN-2015
calling test.sql for 02-JAN-2015
Test.sql 02-JAN-2015 T2
completed for 02-JAN-2015
calling test.sql for 03-JAN-2015
Test.sql 03-JAN-2015 T3
completed for 03-JAN-2015
calling test.sql for 04-JAN-2015
Test.sql 04-JAN-2015 T4
completed for 04-JAN-2015
Here T is constant value where T1,T2,T3,T4 needs to be appended accordingly based in one day interval
Moderator's Comments:
Please use CODE tags for sample input, sample output, AND sample code segments; not just for code segments.
Last edited by Don Cragun; 01-06-2016 at 06:29 PM..
Reason: Add more CODE tags.
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting...... (1 Reply)
My sh scripts is :
sqlplus -S "user/pwd@server" <<!!
SET SQLPROMPT
exec IN_PROC_TEST;
!!
It prompt 'PL/SQL procedure successfully completed.' but not execute actually :mad:
I run this procedure in sqlplus, no problem
and I also could execute simple DDL in this sh script, but why... (2 Replies)
I have an awk file where I need to pass a filename and a value as a parameter from a sh script. I need to know how to pass those values in the sh script and how to use the same in the awk file.
Thanks in advance!!!
Geetha (3 Replies)
Hi,
I am trying to write a script like this:
#!/bin/ksh
#script name: msgflow
#The awk commands for Solaris and Linux are incompatible
if ]
then
msgflow-solaris $*
elif ]
then
msgflow-linux $*
fi
This script is shared by a file system which is visible to both... (3 Replies)
Dear All
I am trying to write one shell which will be running through Cron which contain one SQL query. But I want to draw/fetch the Username password and Instance name (required to loging to the database) from one single file to run that SQL query . Also this file contain details of multiple... (2 Replies)
Hi, for example I have this function:
function get_param ()
{
test=echo "some string"
test2=echo "someother string"
}
I want to call this function and get test or test2 result, how do I do that ?
Thank you (2 Replies)
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Why does this work
for myfile in `find . -name "R*VER" -mtime +1`
do
SHELLVAR=`grep ^err $myfile || echo "No error"`
ECHO $SHELLVAR
done
and outputs
No error
err ->BIST Login Fail 3922 err
No error
err ->IR Remote Key 1 3310 err
But... (2 Replies)
Hi I have a batch file aaa.exe which needs two input parameters:
Usually the command's format likes
aaa 555 10000
But I want to use parameters to do it.
aaa $1 $2
These two parameters come from a text file list.txt
41800497 41801375
41814783 41816135
41814930 41816135
41819987 41820843... (4 Replies)
I need to pass values at runtime for the below awk command where
l is the length and partial.txt is the file name.
awk -v l=285 '{s="%-"l"s\n";printf(s,$0);}' partial.txt > temp1.txt; (5 Replies)
Discussion started by: Amrutha24
5 Replies
LEARN ABOUT SUSE
alter_trigger
ALTER TRIGGER(7) SQL Commands ALTER TRIGGER(7)NAME
ALTER TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table RENAME TO newname
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name The name of an existing trigger to alter.
table The name of the table on which this trigger acts.
newname
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE [alter_table(7)], not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE [alter_table(7)]
SQL - Language Statements 2010-05-14 ALTER TRIGGER(7)
01-06-2016
