You might want to throw in a "drop table" somewhere before the "create table"
Assuming Oracle:
In your script source your .profile, set ORAENV_ASK to NO, set your ORACLE_SID to that of the database you're planning to connect, and then source "oraenv".
As for the "11 PM" part, set up a cronjob.
Last edited by Scott; 11-15-2010 at 08:27 PM..
Reason: Changed 11 to 23 on cronjob -- oops :)
Hi gurus,
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
Thanks
sish (6 Replies)
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)
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Hi,
I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them.
Each of... (20 Replies)
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Hello,
I'm attempting to open multiple xterms and run a command as an SAP user via sudo using PSSH. So far, I'm able to run PSSH to a file of servers with no check for keys, open every xterm in to the servers in the file list, and SUDO to the SAP(ADM) user, but it won't do anything else... (11 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
matchbox-panel
matchbox-panel(1) General Commands Manual matchbox-panel(1)NAME
matchbox-panel - a desktop panel for resource-limited systems
SYNOPSIS
matchbox-panel [options]
DESCRIPTION
matchbox-panel is a desktop panel, which can hold small `applets' such as a clock, system monitor and wireless monitor.
Matchbox is a base environment for the X Window System running on non-desktop embedded platforms such as handhelds, set-top boxes, kiosks
and anything else for which screen space, input mechanisms or system resources are limited.
OPTIONS -display display
X display to connect to
-geometry geometry
Use --size/--orientation instead
--id int
Panel number
--size int, -s int
Width/height of panel in pixels
--orientation north|east|south|west
--default-apps app list, -da app list
Comma-separated list of apps to add to a panel when no session starts
--margin-start +int
Initial app offset in pixels (panel start)
--margin-end +int
Initial app offset in pixels (panel end)
--titlebar
Request panel in titlebar
--no-session, -ns
Disable automatic session saving
--no-menu, -nm
Disable popup menu
--no-flip, -nf
Disable automatic panel rotation when display is rotated
--overide-bubbles, -o
Set override-redirect attribute on popup information windows
--help help
AUTHOR
matchbox-panel was written by Matthew Allum <mallum@o-hand.com>.
Jul 17 2004 matchbox-panel(1)