hi everybody,
i am Talip, a begginner at unix based systems and i have a problem (actually, we may think myself as the problem, in this situation).
i am not sure if this is the correct platform for my questions. if it is not please forgive me about this inappropriate mail.
what i have:
*... (2 Replies)
Hi,
I need to write a shell script file that does
1)Connects to DB using SQL plus
2)Do some SQL query like select * from....
3)Based on the output that I got from the sql query I will have to write a if else loop.
Plz let me know how to write the shell scripting for this.
Thanks for... (1 Reply)
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Hi ,
Daily I sneding report to client about the status of State 2 jobs in Control M .
I would like to schedule it via cron . I am using teh following command :
sudo su - <control M server Name>
then reach to the control M server
then run
#isql
<It ask for the password >
... (1 Reply)
Hello Experts !!!
Im new to this so, please bear with me !
I have the following 2 sql statements
create table CMD_NEW_USER as
Select FD.EMPLOYEE, FD.PASTUSER, .....
FROM REPORTS FS, TASKLIST FD
WHERE FS.EMPLOYEEID = FD.EMPLOYEEID ;
create table CMD_OLD_USER as
Select FD.EMPLOYEE,... (4 Replies)
Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need.
In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script:
---filename... (3 Replies)
Discussion started by: hamanjam
3 Replies
LEARN ABOUT DEBIAN
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)