Trigger whoever logged in sqlplus through UNIX Post: 302334159

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to send a trigger file from Unix to Windows

I need to send a file from a Unix box to a Windows sever to kick off a Crystal Reports job. Any good ideas how to do this? Can it be done with FTP?

2. Shell Programming and Scripting

Need example program for sqlplus in Unix

Hi I am new to unix .I need a example program to connect oracle10g DB from shell script.The task is to connect sql from shellscript and to write a query inside to retieve some fiels.The reseult should be stored in a seperate .dat file(by using spool). Thanks Bala.

3. UNIX for Dummies Questions & Answers

connect sqlplus from unix

hi, I have this basic query. I have created a new user on unix. I have given home directory and permission through chmod to create directory stucture. Now need to connect sqlplus. What permissions should we give, so that this works? Any help is appreciated. Thanks, Neha

4. UNIX for Dummies Questions & Answers

SQLPLUS in unix

HI Guys, i just want ask the steps when trying to create a simple SQL select statement in linux. I know how to use the select statement in SQLplus, but im having a difficult time in having a unix script connect direct to SQL plus and then retrieve the selected statement. example....

5. Shell Programming and Scripting

Update trigger for unix file (solaris)

Hello, from log error file of process that i's updating in append mode, i need to capture the new entries for every day. How i can know and save only the new errors? This it's a sample of error log file (oas report server engine) thanks and regards Fran

6. Shell Programming and Scripting

Source trigger in Unix shell

Hi All, Is ther any way to write the script with source trigger ? To trigger the script on particular time we have crontab. Similarly in a path, when a file comes particular script has to run. Thanks:)

7. Shell Programming and Scripting

Trigger functionality in Unix

Hi, I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening., Below is...

8. Shell Programming and Scripting

Reading value from sqlplus in UNIX

I have a unix shell script that calls two Select Queries using sqlplus as shown below. more extract.sh result=$(sqlplus -s usr/swd@myhost_sid @/tmp/SELECT_QUERY.run) more @/tmp/SELECT_QUERY.run SELECT PROBLEM_TYPE, COUNT (*) FROM BATCH WHERE UPPER (STATUS) = 'NEW' AND PROB_TYPE...

9. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

hi guys i have a sqlplus : sqlplus -s username/password << EOF @mysql.sql EOF in mysql.sql there is a count of a table, i want to write in a variabile unix. how can i do? Thanks a lot Regards Francesco.

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to send a trigger file from Unix to Windows

Discussion started by: robw95

2. Shell Programming and Scripting

Need example program for sqlplus in Unix

Discussion started by: tobalajia

3. UNIX for Dummies Questions & Answers

connect sqlplus from unix

Discussion started by: nehak

4. UNIX for Dummies Questions & Answers

SQLPLUS in unix

Discussion started by: mdap

5. Shell Programming and Scripting

Update trigger for unix file (solaris)

Discussion started by: fran61

6. Shell Programming and Scripting

Source trigger in Unix shell

Discussion started by: jesu

7. Shell Programming and Scripting

Trigger functionality in Unix

Discussion started by: cratercrabs

8. Shell Programming and Scripting

Reading value from sqlplus in UNIX

Discussion started by: mohtashims

9. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

Discussion started by: Francesco_IT