First Script: Query every table with column xxx.

Iniquity · #1 (**permalink**) 02-01-2007

Hi all,

Im new to scripting and have no idea how to start this. Recently I had to Query an Oracle database to find a count(distinct version) from every single table inside. I want to write this up into a script for the future.

I have a template to connect to the database, so that is not the issue.
I have tried SELECT COUNT(DISTINCT version) from user_tables, but it will just fail if the column is not found.

So I would like to maybe put in a message that says this table does not contain this column, and then continue on.

Also I would like it to skip any table with a $ in front of it.

Any ideas?

Iniquity · #2 (**permalink**) 02-06-2007

I think what I want to accomplish is a mix of sql and scripting, anyone willing to help?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
updating a column in a unix table for a particular row	thanuman	Shell Programming and Scripting	5	02-09-2009 06:52 PM
shellscript.query Oracle table..populate in a text file	bhagat.singh-j	Shell Programming and Scripting	7	01-15-2009 02:07 PM
file in to the column of the table	sant_leo	Shell Programming and Scripting	0	11-30-2006 05:33 PM
Reading a table in a shell script	luiscarvalheiro	Shell Programming and Scripting	13	08-10-2006 06:16 PM
updating a column in oracle table using shell script	sveera	Shell Programming and Scripting	3	05-09-2005 01:01 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by