Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2007-11-25
3
366 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
Recently, an awarded photographer, Selina De Maeyer (http://www.selinademaeyer.com/), completed a photo shoot of a beautiful event (http://www.sintjacobantwerpen.be/verslag-en-fotoreportage-van-de-sacramentsprocessie-door-antwerpen#thumbnails) in An…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

789 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