How to eliminate OR clause when joining tables? Post: 302962177

10 More Discussions You Might Find Interesting

1. 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:...

2. UNIX for Dummies Questions & Answers

if clause

hi, pls could you help me with one program in KSH ( i have sunOS). I need to create an If clause, that prints an error message and filenames, when in a directory are found some files of null size (find . -type f -size 0 ). thanks

3. Shell Programming and Scripting

Dynamic SQL for where clause

Hi, I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4 Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value. eg. where Field1=AAA eg. where Field1=AAA and Field2=BBB eg....

4. Shell Programming and Scripting

multiple conditions in 'if clause'

Hi, When i use the below code snippet in my shell script OFC_10.sh: if then echo "Success" exit 2 elif then echo "Failure" exit 6 I get the error message: ./OFC_10.sh: line 41: ' ./OFC_10.sh: line 45: ' Line 41 is the line where If loop starts and line 45 is...

5. Shell Programming and Scripting

How to eliminate ^L

Hi, I am trying to create a text file from data retrieved from a query.The data retrieved is having this character '^L' at regular intervals of the data. How can i eliminate this, Please find below the sample data. I tried sed -e "s/\^L//g" to convert it, but with no luck ^LCODE*SERIAL...

6. Shell Programming and Scripting

Use a shell variable in where clause

Hi all, I want to use a variable inside my sql query and below is my script: #!/bin/ksh export b="abcd" a=`sqlplus -s abc/def@ghi <<++ set heading off; set feedback off; select xxx from mytable where clmn_nm='$b'; exit; ++` echo $a But the output i get is below: $>...

7. Shell Programming and Scripting

If clause in perl

HI friends , I am very new to perl .please dont mind if i ask silly questions. I seee below code in one sript if ( exists $ENV{FMTWRP_TMP_DIR} and $ENV{FMTWRP_TMP_DIR} ) { $tdir = $ENV{FMTWRP_TMP_DIR}; } whats does this mean . I am very confused about the if clauses in...

8. Shell Programming and Scripting

../ in perl and if clause

Hi can anyone please explain what the below code does? i mean $fide_stopfile = ? when $FIDE_SCR = '/fs/dir1/dir2/common/scr' and also little confused with if clause too. what it check? $fide_stopfile = "$ENV{FIDE_SCR}/../tmp/STOP"; if ( -e $fide_stopfile > 0 ) { ...

9. Shell Programming and Scripting

How to search for a directory with if clause?

Hello All, I want to do a conditional search for a directory, i.e pathname=/abc/def foldername=xyz if ( $pathname/$foldername/aaa ) then .................. fi Here i am searching for aaa directory inside the path and if it exist then it should go inside the loop. Can...

10. Shell Programming and Scripting

If clause query

Hi, i need to add a condition in my IF clause where i need to check if the file exists in a folder and return true out of it. but in my directory i have multiple files with same name but datestamp append on it for e.g. export f1 = filename export f2=filename1 if ] then echo "No...

LEARN ABOUT DEBIAN

sqlobject-admin

SQLOBJECT-ADMIN(1)					      General Commands Manual						SQLOBJECT-ADMIN(1)

NAME

       sqlobject-admin - manage your database as defined with SQLObject classes

SYNOPSIS

       sqlobject-admin [options] command

DESCRIPTION

       The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.

       Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
       database to match the version of the schema in your code.

COMMANDS

       The following commands are recognized:

       help
	   Show the help text.

       create
	   Find the tables and create them. Existing tables are simply skipped.

       sql
	   Show the SQL to create all the tables.

       drop
	   Drop tables. Missing tables are skipped.

       execute
	   Execute an arbitrary SQL expression.

       list
	   List out all the found classes.

       status
	   Show if tables are present in the database.

       record
	   Record historical information about the database status

       upgrade
	   Update the database to a new version (as created by record)

OPTIONS

       -c CONNECTION, --connection=CONNECTION
	   Connection string for the database .

       -f FILENAME, --config-file=FILENAME
	   Configuration file from which to get the connection to the database.

       -m MODULE, --module=MODULE
	   A module to look in for classes.

       -p PACKAGE, --package=PACKAGE
	   A package to look in.

       --class=CLASSMATCH
	   Restricting the found classes to the matching classes.

       --egg=EGG_SPEC
	   Egg description that should be loaded.

AUTHORS

	   This manual page was written by Carl Chenet <chaica@ohmytux.com>.

LICENSE

	   This package is licensed under the GNU Lesser General Public License. You can
	   find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
	   Debian system.

								    06/03/2010							SQLOBJECT-ADMIN(1)