My first Script


 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions My first Script
# 1  
Old 01-31-2017
My first Script

Hi All,

I created my first script that will display all table fields. since the tables are too many, I write script that will automate describe all the tables and put into one file.

I know for the others, this is very simple script but since this is my first time I don't know how to debug the error.

anybody can help me?

1. The problem statement, all variables and given/known data:
this is the error;
Code:
ora_describe_table.sh[5]: describe: not found [No such file or directory]
ora_describe_table.sh[5]: describe: not found [No such file or directory]
ora_describe_table.sh[5]: describe: not found [No such file or directory]
ora_describe_table.sh[5]: describe: not found [No such file or directory]

2. Relevant commands, code, scripts, algorithms:
Code:
#!/bin/sh
cat Match_Table
sqlplus user/pwd@TABLE
while read Match; do
      describe table TABLE.$Match >> Describe_table.txt
done < Match_Table
exit


3. The attempts at a solution (include all code and scripts):



4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Xavier university, Philippines, lincaro, computer engineering

Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).
# 2  
Old 01-31-2017
describe is NOT a command known to the shell. I think you need to do the loop inside ORACLE.
This User Gave Thanks to RudiC For This Post:
# 3  
Old 02-02-2017
Thanks RudiC..

I amend my script but there another error. can you help point my mistake. Thanks
Code:
while read match
do
  sqlplus user/pwd@table <<EOF
  describe $match;
done < Match_Table
exit
EOF

Code:
ora_describe_table.sh: syntax error at line 10: `do' unmatched

# 4  
Old 02-02-2017
Read the error message carefully and look at your script to find out why the done can't be found:
Code:
while read match
do                              <-----------+
  sqlplus user/pwd@table <<EOF          <-- | --+
  describe $match;                          |   |
done < Match_Table              <-----------+   |
exit                                            |
EOF                                     <-------+

This User Gave Thanks to RudiC For This Post:
# 5  
Old 02-02-2017
Thanks RudiC.. got it and is working now..Smilie
This User Gave Thanks to Sonny_103024 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question