tables in scripts

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out...

2. Shell Programming and Scripting

Scripts for exporting backup from selected tables of Oracle DB

dear all please help me ! i need a script for exporting the selected tables of oracle database installed on CentOs. i waiting your response. thanks and regards

3. Shell Programming and Scripting

KSH - How to call different scripts from master scripts based on a column in an Oracle table

Dear Members, I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc. I would like to create a script which will will call other scripts based on the request action. Can we directly read from the REQUEST_ACTION...

4. Shell Programming and Scripting

Changing the Bash Scripts to Bourne Scripts:URGENT

Hi, I have to write a program to compute the checksums of files ./script.sh I wrote the program using bash and it took me forever since I am a beginner but it works very well. I'm getting so close to the deadline and I realised today that actually I have to use normal Bourne shell...

5. Shell Programming and Scripting

Running scripts within scripts from cron

Hi all, I have set up a cron job which calls another shell script shell script which in turn calls a Java process. The cron tab looks so. 0,30 7-18 * * 1-5 /u01/home/weblogic/brp/bin/checkstatus.sh >> /u01/home/weblogic/logs/checkstatus.log The checkstatus.sh scripts looks like this. ...

6. Shell Programming and Scripting

Help with Script using rsh and scripts within scripts

Hi, I've written a script that runs on a Database server. It has to shutdown the Application server, do an Oracle Dump and then restart the Application server. Its been a long time since I wrote any shells scripts. Can you tell me if the scripts that I execute within my script will be executed...

7. UNIX for Dummies Questions & Answers

Profile scripts versus rc scripts....

what is the difference between login and profile scripts versus the rc scripts?

8. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:...

9. Shell Programming and Scripting

use shell scripts to update tables from databases

Hi I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility...

10. UNIX for Dummies Questions & Answers

finding out tables not used in scripts.

Hi all, Please see my requirement and post me asap. Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence...

LEARN ABOUT MOJAVE

expand

EXPAND(1)						    BSD General Commands Manual 						 EXPAND(1)

NAME

     expand, unexpand -- expand tabs to spaces, and vice versa

SYNOPSIS

     expand [-t tab1,tab2,...,tabn] [file ...]
     unexpand [-a | -t tab1,tab2,...,tabn] [file ...]

DESCRIPTION

     The expand utility processes the named files or the standard input writing the standard output with tabs changed into blanks.  Backspace
     characters are preserved into the output and decrement the column count for tab calculations.  The expand utility is useful for pre-process-
     ing character files (before sorting, looking at specific columns, etc.) that contain tabs.

     The unexpand utility puts tabs back into the data from the standard input or the named files and writes the result on the standard output.

     The following options are available:

     -a      (unexpand only.)  By default, only leading blanks and tabs are reconverted to maximal strings of tabs.  If the -a option is given,
	     then tabs are inserted whenever they would compress the resultant file by replacing two or more characters.

     -t tab1,tab2,...,tabn
	     Set tab stops at column positions tab1, tab2, ..., tabn.  If only a single number is given, tab stops are set that number of column
	     positions apart instead of the default number of 8.

ENVIRONMENT

     The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of expand and unexpand as described in environ(7).

EXIT STATUS

     The expand and unexpand utilities exit 0 on success, and >0 if an error occurs.

STANDARDS

     The expand and unexpand utilities conform to IEEE Std 1003.1-2001 (``POSIX.1'').

HISTORY

     The expand command appeared in 3.0BSD.

BSD
								 October 13, 2006							       BSD

Shell Programming and Scripting