07-15-2009
In a loop where? In the database via PL/SQL or outside via shell script?
I would suggest using one database connection to get and format all data/output.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings.
I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file.
I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies
2. Shell Programming and Scripting
can anyone tell me how to bink a text in a ksh script
for e,g
file 1
#!/bin/ksh
"this is my file"
-----------------------------------------------
i want "this is my file" text to blink.thanks (9 Replies)
Discussion started by: ali560045
9 Replies
3. UNIX for Advanced & Expert Users
Hi,
I am writing a mailing script by using mutt command. I that i have facing a issues. because, i want to send Some Formatted text as the mail message. but, i try to send the Word Document file as the Mail message. it shows some junk characters in the mail. :confused:I think the mutt command is... (1 Reply)
Discussion started by: krsenkumar
1 Replies
4. Shell Programming and Scripting
hi to all
i wrote a script to cut a word from the file....that works only if the word is fixed field.
example..
sed -n '1p'|awk '{ print $2 }'|cut -d '(' -f2|sed 's/(//'|sed 's/)//'|sed 's/"//g' filename
i know that word is starting with "app" then "(" ----> ex: app("xxxx").
it... (2 Replies)
Discussion started by: honeym210
2 Replies
5. Shell Programming and Scripting
First I have to say thank you to this community and this forum. You helped me very much builing several useful scripts.
Now, I can't get a solution the following problem, I'm stuck somehow. Maybe someone has an idea.
In short, I dump a site via lynx and pipe the output in a file. I need to... (7 Replies)
Discussion started by: lowmaster
7 Replies
6. Shell Programming and Scripting
Hi All,
I would like help with a script which can get rid of the first work of all lines in text file.
File 1
The name is Scott.
Output : name is Scott
---------- Post updated at 02:38 PM ---------- Previous update was at 02:37 PM ----------
Hi ALL
There is typo error in... (3 Replies)
Discussion started by: bubbly
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a BASH shell script that batch processes data. I often start this script before I leave to go home for the day, and leave it processing over night. It has come to my attention that it would be very useful for me to add the capability of making the script notify me about certain things... (2 Replies)
Discussion started by: msb65
2 Replies
8. UNIX for Dummies Questions & Answers
How can i make a script to add text before the first word on a line in a textfile :
Example:
Old line:
is my place
New line:
this is my place
Please use and tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks. (3 Replies)
Discussion started by: mjanssen
3 Replies
9. Shell Programming and Scripting
Hi,
I am new to shell programming.I need to write a script that would accept a word from each line fo an input text file.Can anyone help me with this?Exact requirement: word1 word2 word3 (separated by space) .Now I need word3 from each such line in the text file.
Thanks in Advance,
Manish (3 Replies)
Discussion started by: manish007
3 Replies
LEARN ABOUT REDHAT
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)