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 SUSE
mono-asp-apps
mono-asp-apps(1) User Commands mono-asp-apps(1)NAME
mono-asp-apps - utility to manage ASP.NET 2.0 applications installed from RPMs
SYNOPSIS
mono-asp-apps command [options]
DESCRIPTION
The 'mono-asp-apps' command is useful on systems which install applications from RPM packages and when the RPM packages have been created
according to the Mono RPM packaging guidelines for ASP.NET applications.
The utility allows one to initialize, enable, disable and start installed applications. Note that you do not use this utility to manage
applications hosted and managed by the Apache (or other) web server, only by xsp.
Note that this utility is useful only on systems where at least one application packaged according to the Mono ASP.NET 2.0 RPM packaging
guidelines has been installed.
COMMANDS
The commands which take an application name, require the it to be one of the registered names. See the `list` command below.
init APPLICATION_NAME
Initializes the application named APPLICATION_NAME, if it hasn't been done already. Initialization actions performed are applica-
tion specific, but may include creating databases and populating them, creating directories, downloading files etc.
enable APPLICATION_NAME
Enables APPLICATION_NAME for automatic start when XSP is started as part of the system bootup process.
disable APPLICATION_NAME
Disables APPLICATION_NAME, so that it is not started automatically when XSP is started as part of the system bootup process.
start APPLICATION_NAME [server_options]
Manually starts the xsp2 process passing the configuration of APPLICATION_NAME to the xsp2 process. Applications may ship with a
bundled start script which will be used instead of xsp2 if present. server_options are passed verbatim to the server process.
list Lists all the applications known to the utility.
AUTHORS
Marek Habersack <mhabersack@novell.com>
SEE ALSO xsp(1)MORE INFORMATION
The Mono project (http://www.go-mono.com) is a collaborative effort led by Novell (http://www.novell.com) to implement an open source ver-
sion of the .NET Framework.
MAILING LISTS
Mailing lists are listed at the http://www.mono-project.com/Mailing_Lists
mono-asp-apps 2.6.4 31 Oct 2007 mono-asp-apps(1)