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
DROP TRIGGER(7) SQL Commands DROP TRIGGER(7)NAME
DROP TRIGGER - remove a trigger
SYNOPSIS
DROP TRIGGER name ON table [ CASCADE | RESTRICT ]
INPUTS
name The name of an existing trigger.
table The name (optionally schema-qualified) of a table.
CASCADE
Automatically drop objects that depend on the trigger.
RESTRICT
Refuse to drop the trigger if there are any dependent objects. This is the default.
OUTPUTS
DROP TRIGGER
The message returned if the trigger is successfully dropped.
ERROR: DropTrigger: there is no trigger name on relation "table"
This message occurs if the trigger specified does not exist.
DESCRIPTION
DROP TRIGGER will remove an existing trigger definition. To execute this command the current user must be the owner of the table for which
the trigger is defined.
EXAMPLES
Destroy the if_dist_exists trigger on table films:
DROP TRIGGER if_dist_exists ON films;
COMPATIBILITY
SQL92 There is no DROP TRIGGER statement in SQL92.
SQL99 The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command
is simply DROP TRIGGER name.
SEE ALSO
CREATE TRIGGER [create_trigger(7)]
SQL - Language Statements 2002-11-22 DROP 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)