I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job... (3 Replies)
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
Hi,
I am trying to write a generic script as a part of a framework which will establish Oracle DB connection once and loops in to check for some files which gives the SQL statements to execute.
The script is running but I am stuck with capturing errors ( ORA and SP) and outputs. Example:
... (4 Replies)
Hi Guys,
I would like with this script
"DATA=`ora123 su -c 'echo "SET HEADING OFF;\n SET FEED OFF;\n select USER NAME, ACCOUNT_STATUS from dba_users;\n exit" | sqlplus / as sysdba -s /' `
echo $DATA >> $DAT"
make a sql query, but the statement
"select USER NAME, ACCOUNT_STATUS from... (6 Replies)
Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query?
e.g.
echo "enter value"
read value
insert into tablename where col=$value /*something like this*/ (1 Reply)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Hi All,
I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $... (8 Replies)
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
LEARN ABOUT OSX
talagent
TALAGENT(8) BSD System Manager's Manual TALAGENT(8)NAME
talagent -- helper agent for the Transparent App Lifecycle feature.
SYNOPSIS
talagent [command [arguments]]
DESCRIPTION
The talagent daemon provides services related to the Transparent App Lifecycle feature. talagent may also be run manually as a command line
tool to output information about persistent state.
The options are as follows:
-help
Outputs usage information.
-dump bundle_id_fragment
Outputs the persistent state of an application whose bundle ID contains the given fragment, case insensitive ("textedit" for example).
You may also pass a path directly to the app's persistent state directory, usually in ~/Library/Saved Application State.
-launch bundle_id
This launches an app (in this case, TextEdit) in a manner approximating how apps get launched at login. You can pass either a bundle ID
fragment or a path to an app. The app is maintained stopped until you hit return in the launching window (or until it receives SIGCONT).
This is the easiest way to test the login scenario without needing to log in.
-casinfo [ASN]
With no arguments, outputs summary information about all apps. With one argument (an ASN), outputs the CAS record for that app.
-memory_pressure
Simulates memory pressure, which may cause apps that support automatic termination to exit. This does not actually allocate any memory.
-refresh_encryption
Rotates the bitmap encryption key, and attempts to cross-encrypt all existing window bitmaps under the new key. This is done periodically
by talagent.
HISTORY
First appeared in Mac OS X 10.7
Mac OS X September 1, 2010 Mac OS X