Sponsored Content
Top Forums Shell Programming and Scripting unix script to export data from csv file to oracle database Post 78485 by vinayagan on Wednesday 20th of July 2005 04:16:40 AM
Old 07-20-2005
Thanks to you both DirkLottering and vgersh99. I'll try it. If i want to make it as recurring process, can I do it by control file ?

I'm new to unix so bear with me if its silly question.

thanks again.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

export table from oracle database

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it. thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies

2. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies

3. Shell Programming and Scripting

Need Shell Script to upload data from Text file to Oracle database

Hi Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database. Requirement:- 1. Need to connect to Oracle database from Unix Shell script. 2. Need to pick Text file from some location on Unix Box. 3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies

4. Shell Programming and Scripting

unix script for loading a data from a file into database

Hi All, I am trying to load a data from a files in a particular directory to a database.. cd $SCC isql metdb >> ${LOGDATA}/LOAD.LOG < ! load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE ! But it's showing the error "syntax error at line 46 : `<<' unmatched" Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies

5. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

6. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

7. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies

8. Linux

Parsing - export html table data as .csv file?

Hi all, Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table. Please see the attached html and PNG of what it looks like. ... (7 Replies)
Discussion started by: lxdorney
7 Replies

9. Shell Programming and Scripting

Script to Gather data from logs and export to a CSV file

Greetings, After a few hours of trial and error, I decide to ask for some help. I am new to AWK and shell script, so please don't laugh :p I made the below script, to gather data from some logs and have the output into a CSV file : #!/bin/sh #Script to collect Errors ... (9 Replies)
Discussion started by: Yagami_Sama
9 Replies

10. UNIX for Beginners Questions & Answers

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

Hello All, just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table. Can you please suggest why? or any better idea? export FILE="/abc/autom/file/geo_JOB.csv" Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
pud-faq(7)							  MISCELLANEOUS 							pud-faq(7)

  NAME
	  pud-faq - faqs and facts about the Portable Unix Documentation FAQ authoring language.

	  This	document  describes  the Portable Unix Documentation (PUD) faq mini-language in the style of a FAQ. PUD-faq is built on top of the
	  macro interpreter zoem. A PUD document is generally well-structured, relatively free of formatting statements, compact to write and eas-
	  ily  extendable.  It	can  be converted to both troff and html, for viewing in terminals and browsers. High quality Postscript and plain
	  text formats can be derived from the troff output. Refer to pud-man for examples.

  DESCRIPTION
	  The PUD faq macros extend the PUD manual macros; a PUD faq document must import both man.zmm and faq.zmm. There are  only  a	few  addi-
	  tional faq macros in faq.zmm. The overall layout of a faq document is as follows:

	  import{man.zmm}
	  import{faq.zmm}

	  egin{pud::man}{
	     {name}{pud-faq}
	     {html_title}{The PUD faq mini-language FAQ}
	     {author}{Stijn van Dongen}
	     {section}{7}
	  }

	  "faq::preamble"

	  ${html}{"man::maketoc"}

	  sec{toc}{TOC}
	  "faq::maketoc"

	  egin{faqsec}{{ref}{Labelx}{cap}{Captionx}}
	     content
	  end{faqsec}

	  egin{faqsec}{{ref}{Labely}{cap}{Captiony}}
	     content
	  end{faqsec}

	  end{pud::man}

	  The PUD manual macros are documented in the pud-man manual page.

	  Create your FAQ according to the lay-out above and as described further below. Refer to Question 2.3 for full-size examples.

	  Once you have written your FAQ, process it as follows.

	     zoem -i your-faq.azm -d html
	     zoem -i your-faq.azm -d html
	     zoem -i your-faq.azm -d roff -o your-faq.7
	     zoem -i your-faq.azm -d roff -o your-faq.7

	  This generates files your-faq.html and your-faq.7.  Each device is run twice to be certain that references are found and linked.

  RESOURCES
	  o The Zoem User Manual.
	  o The pud-man manual page.

  TOC
  1...... How do I create and link to questions and sections?
   1.1... How do I start a section?
   1.2... How do I make a faq entry?
   1.3... How do I link to a question?
   1.4... How do I link to a section?
   1.5... Is that not a whole lot of typing just for linking?

  2...... Miscellaneous
   2.1... Is it really possible to have more than one section?
   2.2... Is there an easy way to get back to the TOC?
   2.3... Show me a real FAQ, not this nonsense.
   2.4... I want to change the appearance of my FAQ.
   2.5... Show me the source to this FAQ.

  FAQ
						    How do I create and link to questions and sections?

   1.1	  How do I start a section?

	  You would for example type

	  egin{faqsec}{
	     {ref}{kind}
	     {cap}{How do I link to questions and sections?}
	  }

   1.2	  How do I make a faq entry?

	  You create an entry as follows:

	  faq{q_question}{How do I make a faq entry?}
	     You create an entry as follows:
	     ...

   1.3	  How do I link to a question?

	  car{Like this: linking to
	  iref{q_qlink}{Question~
efnumber{q_qlink}},
	  or a silly link to the iref{q_qlink}{current question}.
	  Linking to iref{s_basics}{Question~
efnumber{q_slink}},
	  or a link to the iref{q_slink}{next question}.}

	  par{
	  Of course, you have to use wordings such that the
	  text still makes sense in the absence of links
	  (assuming you are intested in the troff version of
	  the FAQ you are writing), so normally you just refer to
	  iref{q_slink}{Question~
efnumber{q_slink}} and be done
	  with it.}

	  Like this: linking to Question 1.3, or a silly link to the current question.	Linking to Question 1.4, or a link to the next question.

	  Of course, you have to use wordings such that the text still makes sense in the absence of links (assuming you are intested in the troff
	  version of the FAQ you are writing), so normally you just refer to Question 1.4 and be done with it.

   1.4	  How do I link to a section?

	  car{Like this: linking to
	  iref{q_qlink}{Section~
efnumber{s_basics}} and
	  linking to iref{q_stupid}{Section~
efnumber{s_stupid}}.}

	  Like this: linking to Section 1 and linking to Section 2.

   1.5	  Is that not a whole lot of typing just for linking?

	  It sure is. Note the repeating elements though. Feel free to create your own shortcuts by using Zoem's macro facilities.

								       Miscellaneous

   2.1	  Is it really possible to have more than one section?

	  QED

   2.2	  Is there an easy way to get back to the TOC?

	  In the HTML version of the faq, one can click on the number to the left of the question; this will take you to the top of the  TOC  part
	  pertaining to the section that question belongs to.

   2.3	  Show me a real FAQ, not this nonsense.

	  The  reason I began writing zoem and PUD was that I wanted decent (both HTML and troff) and easy to write documentation for my implemen-
	  tation of the MCL cluster algorithm.

	  o http://micans.org/mcl/src/mcl-latest/doc/mclfaq.azm
	  o http://micans.org/mcl/src/mcl-latest/doc/mclfaq.html
	  o http://micans.org/mcl/src/mcl-latest/doc/mclfaq.ps

   2.4	  I want to change the appearance of my FAQ.

	  Well, you need to make a copy of the faq macros and possibly the man macros, and hack those changes in.  Zoem itself is  very  flexible,
	  but  the  PUD faq macros are not, in this respect. They can be made so, if you wish.	If you just want to change or add some style sheet
	  rules for the HTML version, it will be quite easy.  The same holds for changing font styles and possibly even spacing rules.

   2.5	  Show me the source to this FAQ.

	  Search for pud-faq.azm in your install of zoem.  Take note though that I played a few silly tricks in this FAQ, so the source looks more
	  unreadable than your average FAQ.  The FAQ pointed to in Answer 2.3 gives a more realistic impression.

  AUTHOR
	  Stijn van Dongen.

  SEE ALSO
	  The pud-man manual page, documenting the PUD manual language. The FAQ language imports the manual definitions and you use these e.g. for
	  sectioning commands as described above.

	  The pud manual page gives an overview of PUD.

  pud-faq 1.002, 10-008 					      8 Jan 2010							  pud-faq(7)
All times are GMT -4. The time now is 05:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy