Solved

i want to provide the output of df -k to insert scirpt in oracle

Posted on 2007-11-25
3
353 Views
Last Modified: 2007-12-13
i want a script for output of df -k into oracle table. i need a scirpt for the df -k to generate insert script so that i can run in oracle some thing like .

insert into table aaaa values ('-------output of df -k-------');

0
Comment
Question by:rpmindtools
  • 2
3 Comments
 
LVL 48

Expert Comment

by:Tintin
ID: 20346737
Do you want the output of dk -k in a single column or multiple columns?
0
 

Author Comment

by:rpmindtools
ID: 20347008
Single Column
0
 
LVL 48

Accepted Solution

by:
Tintin earned 500 total points
ID: 20347847
Something like:

#!/bin/sh

sqlplus -s / <<EOF
insert into table aaaa values `df -k`
/
EOF
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
Background Still having to process all these year-end "csv" files received from all these sources (including Government entities), sometimes we have the need to examine the contents due to data error, etc... As a "Unix" shop, our only readily …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now