Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013

    Red face Unanswered: Input from a DB field

    Hi I'm new in shell scripting and i have a problem.. I've got a DB with a column names Date_elab (this is a field with the dates of a partition that must be cancelled). In my shell i have to get an input of the date (for example 2013-01-01). How can i do it? When i say "input" i mean with a parameter. ($1)

  2. #2
    Join Date
    Sep 2009
    Provided Answers: 1
    write a sql script that will output the date and:
    #!/bin/ksh  (or bash)
    DATE=`sqlplus myscript.sql`
    export DATE
    DATE is now available to all processes within this script.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts