ALTER TRIGGER(7) SQL Commands ALTER TRIGGER(7)NAME
ALTER TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER trigger ON table
RENAME TO newname
INPUTS
trigger
The name of an existing trigger to alter.
table The name of the table on which this trigger acts.
newname
New name for the existing trigger.
OUTPUTS
ALTER TRIGGER
Message returned from trigger renaming.
ERROR Message returned if trigger is not available, or new name is a duplicate of another existing trigger on the table.
DESCRIPTION
ALTER TRIGGER changes the definition of an existing trigger. The RENAME clause causes the name of a trigger on the given table to change
without otherwise changing the trigger definition.
You must own the table on which the trigger acts in order to change its properties.
NOTES
Refer to CREATE TRIGGER for a further description of valid arguments.
USAGE
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
SQL92
The clause to rename triggers is a PostgreSQL extension from SQL92.
SQL - Language Statements 2002-11-22 ALTER TRIGGER(7)
Check Out this Related Man Page
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)
....does the dbms_output.put_line work inside unix shell script?
i mean this is to be inside the sqlplus connection as follows!!
sqlplus -s $UP <<EOJ
..
..
..
dbms_output.put_line ('Insertion procedure failed for UPC BC : ' || wk_key_value || ' Sqlcode: ' || SQLCODE || ' Error... (2 Replies)
i would like to learn how to integrate my little knowledge in shell scripting with sqlplus. well... i know how to make basic query in sqlplus but i dont know how i can integrate it with shell script. can someone :) please help me on this? can you give me some basic example on how to do this kind of... (10 Replies)
Hi,
I need a script to execute below task. As of now I am doing it manually and want it automated.
1)go to below path
cd /path/of/file
check for the availibility of two file as below of the latest date.
test.week1.data
test.week2.data
Case1. If above files are not present... (3 Replies)
I made a script to execute below task. As of now I am doing it manually and want it automated.
Please note that this is a single script and for clarification i have put here in different task
1st task
check for the availibility of two file as below of the latest date.
test.week1.data... (0 Replies)
Hi,
I created a script which connects to database and update a table.
This script is running fine when i run it manually but when i am trying to execute it scheduling in crontab.script is executing but Data is not getting updated.
below is my script
sqlplus test/##### >> test_feed.log <<!... (6 Replies)